[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

--- Comment #9 from Julien Nabet <serval2412 at yahoo.fr> ---
(In reply to Lionel Elie Mamane from comment #6)
...
> This looks like it fetches the first result set and then throws it away.
> Always. Even when the caller wants the result. I'm rather sure this will
> cause other problems. E.g. when the query actually returns multiple result
> sets, the caller will not get the first one, only the second, third, etc.
> 
> The solution is probably in code that _calls_ that. E.g. the code that
> implements the "Execute SQL Statement" dialog.

I'm not sure to understand, execute and executeUpdate never use resultsets or
did I miss something?
If yes, I don't achieve to use getMoreResults/getResultSet/disposeResultSet  to
throw away rs correctly.
Here's a small bt to see the link between execute methods:
#0  0x00007f0022c89549 in
connectivity::mysqlc::OCommonStatement::execute(rtl::OUString const&)
(this=0x555557f4ccf0, sql="CALL `AllNames`;")
    at /home/julien/lo/libreoffice/mysqlc/source/mysqlc_statement.cxx:138
#1  0x00007f0029afefcb in OStatement::execute(rtl::OUString const&)
(this=0x555557f4e640, _rSQL="CALL `AllNames`;")
    at /home/julien/lo/libreoffice/dbaccess/source/core/api/statement.cxx:489
#2  0x00007f0026e6b2b6 in
dbaui::DirectSQLDialog::implExecuteStatement(rtl::OUString const&)
(this=0x555557ec9890, _rStatement="CALL `AllNames`;")
    at /home/julien/lo/libreoffice/dbaccess/source/ui/dlg/directsql.cxx:228

-- 
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/20170921/1d1076e2/attachment-0001.html>