[Libreoffice-bugs] [Bug 123999] time change causes the return of "parameter index out of range... using mysql and J/connector
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Mar 25 22:42:58 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=123999
Julien Nabet <serval2412 at yahoo.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |lionel at mamane.lu
--- Comment #13 from Julien Nabet <serval2412 at yahoo.fr> ---
On pc Debian x86-64 with master sources updated today, I could reproduce this
with a more simple process:
- create brand new odb file
- choose Mysql then JDBC
- then click by default option + no need to register database
not sure it's useful but I was trying to reproduce the last Dan's comment from
a brand new file
- Select Database > Connection Type
- In the Data Source Properties window, click Next.
- In the Database Properties window, modify the database name.
add "serverTimezone=EST" without quotes and save
- Click finished and save the database document file
- close LO
Indeed, there's db:parameter-name-substitution="false" added
With this patch, I don't reproduce this:
diff --git a/dbaccess/source/core/dataaccess/ModelImpl.cxx
b/dbaccess/source/core/dataaccess/ModelImpl.cxx
index 00463902b340..bcf15cbbbf22 100644
--- a/dbaccess/source/core/dataaccess/ModelImpl.cxx
+++ b/dbaccess/source/core/dataaccess/ModelImpl.cxx
@@ -985,7 +985,7 @@ const AsciiPropertyValue*
ODatabaseModelImpl::getDefaultDataSourceSettings()
AsciiPropertyValue( "LocalSocket", makeAny( OUString()
) ),
AsciiPropertyValue( "NamedPipe", makeAny( OUString()
) ),
// misc known driver settings
- AsciiPropertyValue( "ParameterNameSubstitution", makeAny( false ) ),
+ AsciiPropertyValue( "ParameterNameSubstitution", makeAny( true ) ),
AsciiPropertyValue( "AddIndexAppendix", makeAny( true ) ),
AsciiPropertyValue( "IgnoreDriverPrivileges", makeAny( true ) ),
AsciiPropertyValue( "ImplicitCatalogRestriction", ::cppu::UnoType<
OUString >::get() ),
Lionel: any thoughts about this patch? Does it seem the right lead or would you
prefer I provide a bt from this location to understand the full mechanism?
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190325/397cdd3c/attachment-0001.html>
More information about the Libreoffice-bugs
mailing list