https://bugs.documentfoundation.org/show_bug.cgi?id=150089
Bug ID: 150089
Summary: MariaDB: Pasting table from internal HSQLDB to MariaDB
finishes with wrong command "RESTART WITH".
Product: LibreOffice
Version: 7.2.0.4 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Open a connection to MariaDB, Could be it is the same with MySQL. Error appears
here with MariaDB and direct connection, also JDBC connection.
Copy a table of an existing HSQLDB database, which contains a primary key as
auto value.
Switch to MariaDB.
Paste this table to MariaDB. Could be you have to add the name of the database
(database.table).
Table will be created and pasting ends with an error: "… see near RESTART WITH
…".
RESTART WITH is an command, which works with both internal databases, but won't
work with MariaDB: There it is special used with ALTER SEQUENCE. For
auto-Increment see:
https://mariadb.com/kb/en/auto_increment/
ALTER TABLE tablename AUTO_INCREMENT=8;
will set the next value in MariaDB.
But: This is needless. The data will be inserted right and the next value will
be automatically the next free value.
Tested this with LO 7.4.0.1 on OpenSUSE 15.3 64bit rpm Linux.
This bug won't appear with LO 7.1.5.2 on the same machine.
This bug appears also with LO 7.3.5.2, 7.2.5.1, 7.2.0.4 on the same machine.
--
You are receiving this mail because:
You are the assignee for the bug.
