[Libreoffice-bugs] [Bug 112423] New: MySQL native connector "Commands out of sync..." when calling procedure second time. - Crash

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 112423
           Summary: MySQL native connector "Commands out of sync..." when
                    calling procedure second time.  - Crash
           Product: LibreOffice
           Version: 5.4.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

I have tried to get the content, which should be shown after calling a stored
procedure in MySQL/MariaDB. You could only get the content by macro, but the
commands should work also without.

If you start Tools > SQL and write down
CALL `MyProcedureName`();
the command will be executed. If you do this the second time, the native
Connector gives
"Commands out of sync; you can't run this command now"
You won't be able to see the content of any table afterwords. Base will be
crashing.

If you try the same with JDBC-connector it will work and you could get the
content of a procedure by macros.

Here a detailed description for testing:

You must have a MySQL or MariaDB database.
Connect to the database with the native connector
(https://extensions.libreoffice.org/extensions/mysql-native-connector)
Open Tools > SQL
and run the following command:

CREATE TABLE `NamesTest` (`ID` INT PRIMARY KEY, `name_last` VARCHAR(50),
`name_first` VARCHAR(50));

Could be you have to run View > Refresh Tables after executing this command.

Now run the following commands, each separately:
-------

INSERT INTO `NamesTest` VALUES
(1, 'Burger', 'Mike'),
(2, 'Nice', 'Debby'),
(3, 'Miller', 'Arthur');

CREATE PROCEDURE `AllNames`()
BEGIN
SELECT * FROM `NamesTest`;
END

CALL `AllNames`;

CALL `AllNames`;

-------
The first CALL will work, the second runs out of sync.

Close Tools > SQL.
Try to open one of the tables for viewing the content.
Base and LO will crash.

-- 
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/20170916/b1902b0a/attachment-0001.html>