https://bugs.documentfoundation.org/show_bug.cgi?id=103685
Bug ID: 103685
Summary: SQL... dialog Status: "Commands out of sync" when
connecting to MySQL using direct (native) connector
Product: LibreOffice
Version: 5.2.2.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
When connecting to a MySQL database (served by a Mariadb 10.1 server) via the
LibreOffice "direct" connector method (i.e. a "Native" connector), the Execute
SQL Statement dialog can get confused and get stuck issuing this incorrect
Status:
"Commands out of sync; you can't run this command now".
This occurs only when both of the following are true:
* the 'Show output of "select" statements' box is not checked, and
* when a query returns results.
Connecting via JDBC does not exhibit this bug. In other words, JDBC works
where MySQL native is broken.
I suspect that what needs to be fixed is to get any results and throw them away
when 'Show output of "select" statements' is not checked. This would keep
MySQL happy.
=== How to setup the bug =======================================
--- STEP 1 - CONNECTING -------------
File | New | Database.
-----------
Database Wizard
[x] Connect to an existing database
[MySQL]
Next>>
------------
[x] Connect directly
Next>>
------------
Database name: a_database
[*] Server/port
Server: localhost
Port: 3306
Next>>
------------
User name root
[v] Password required
Test connection
Ok
Next>>
-----------
..register the database in LibreOffice? No
[x] Open the database for editing
Finish
-----------
Save as: bigbase mysql direct.odb
--- STEP 2 - TESTING SQL... ----------
Select: Tools | SQL...
-----------
In the "Execute SQL Statement" dialog box:
SQL Command
Command to execute:
select * from `table1`;
[x] Show output of "select" statements
Execute
Status: Command successfully executed. (This is ok)
---
select * from `table1`;
[x] Show output of "select" statements
Execute
Status: Command successfully executed. (This is ok)
-------
select * from `table1`;
[ ] Show output of "select" statements
Execute
Status: Command successfully executed. (This is ok)
---
select * from `table1`;
[x] Show output of "select" statements
Execute
Status: Commands out of sync; you can't run this command now (This FAILS)
----
This is the full accumulated output in the status box:
1: Command successfully executed.
2: Command successfully executed.
3: Command successfully executed.
4: Commands out of sync; you can't run this command now
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
