<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 - SQL... dialog Status: "Commands out of sync" when connecting to MySQL using direct (native) connector"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=103685">bug 103685</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>iplaw67@tuta.io, lionel@mamane.lu, serval2412@yahoo.fr
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - SQL... dialog Status: "Commands out of sync" when connecting to MySQL using direct (native) connector"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=103685#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - SQL... dialog Status: "Commands out of sync" when connecting to MySQL using direct (native) connector"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=103685">bug 103685</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>Lionel: When in SQL direct, Select is used + show results is checked,
"executeQuery" is used and it seems there's no pb.
In the other cases, "execute" is used. I tried to debug and think the pb is in
mariadb-connector-c since "Commands out of sync" comes from this part but not
easy to follow. The execute method should return with status =
MYSQL_STATUS_READY but it's not the case.
In mysql-connector-cpp/driver/mysql_statement.cpp
we go line 87:
80 MySQL_Statement::do_query(const ::sql::SQLString &q)
81 {
82 CPP_ENTER("MySQL_Statement::do_query");
83 CPP_INFO_FMT("this=%p", this);
84 checkClosed();
85
86 if (proxy->query(q) && proxy->errNo()) {
87 CPP_ERR_FMT("Error during proxy->query : %d:(%s) %s",
proxy->errNo(), proxy->sqlstate().c_str(), proxy->error().c_str());
88 sql::mysql::util::throwSQLException(*proxy.get());
89 }
90
91 warningsCount= proxy->warning_count();
92
93 warningsHaveBeenLoaded= false;
94 }
The pb in tdf#112423 must be similar</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>