<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - time change causes the return of "parameter index out of range... using mysql and J/connector"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123999">bug 123999</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>lionel@mamane.lu
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - time change causes the return of "parameter index out of range... using mysql and J/connector"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123999#c13">Comment # 13</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - time change causes the return of "parameter index out of range... using mysql and J/connector"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123999">bug 123999</a>
from <span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span></b>
<pre>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?</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>