https://bugs.documentfoundation.org/show_bug.cgi?id=132814
Bug ID: 132814
Summary: EDITING: Impossible to change an existing Integer
primarykey in MySQL/MariaDB to AutoValue in GUI
Product: LibreOffice
Version: 6.4.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rob...@familiegrosskopf.de
Use a MariaDB or MySQL-database for this bug.
Connection through ODBC, JDBC or direct driver give the same result.
Create a table in the GUI, two fields:
ID > INTEGER
name > VARCHAR(50)
Set ID to primary key, but not to AutoValue.
Save the table and close the table.
Open the table to input data. AutoValue isn't created.
Open the table for editing and set ID to AutoValue.
Save the table.
At this moment the bug appears: When saving the table the AutoValue will be set
back from "Yes" to "No". You can't can't change a primarykey in a
MySQL/MariaDB-database through the GUI form AutoValue "No" to AutoValue "Yes".
No go to Tools → SQL
ALTER TABLE `table` CHANGE `ID` `ID` INT(10) NOT NULL AUTO_INCREMENT;
The ID will be changed to AutoValue without any problem.
Seems this bug has nothing to do with the connection to MySQL/MariaDB. Its an
internal problem of the GUI.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs