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

Reply via email to