[Libreoffice-bugs] [Bug 103685] SQL... dialog Status: "Commands out of sync" when connecting to MySQL using direct (native) connector

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=103685

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |iplaw67 at tuta.io,
                   |                            |lionel at mamane.lu,
                   |                            |serval2412 at yahoo.fr

--- Comment #3 from Julien Nabet <serval2412 at yahoo.fr> ---
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

-- 
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/20170919/d87227da/attachment.html>