[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