https://bugs.freedesktop.org/show_bug.cgi?id=85013
Bug ID: 85013
Summary: MySQL throws syntax errors for LibreOffice generated
queries
Product: LibreOffice
Version: 4.3.2.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Database
Assignee: [email protected]
Reporter: [email protected]
I get this when I try to add a table into a previously created MySQL database:
SQL State: 42000
Error code: 1064
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ' PRIMARY KEY
(`Instructor_ID`))' at line 1
Steps to reproduce
1st-Create a MySQL database using whatever way you like.
2nd-Connect this database in LibreOffice Base using JDBC.
3rd-Open table design window and create a table with a primary key having the
type "INT UNSIGNED", add more columns as you like.
4th-Try saving this.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs