Issue 67114 - trying to create an ENUM column in a MySQL table fails with a syntax error
Summary: trying to create an ENUM column in a MySQL table fails with a syntax error
Status: CLOSED FIXED_WITHOUT_CODE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m174
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-07-07 13:34 UTC by Frank Schönheit
Modified: 2022-05-12 17:52 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2006-07-07 13:34:31 UTC 
In a MySQL database connected via JDBC, try to create a table with an ENUM
column. Upon saving the table, this fails with a "You have an error in your SQL
syntax ..." error message from the MySQL server.
Comment 1 oooforum (fr) 2022-05-11 06:01:05 UTC 
Try with native SDBC driver provided with an OXT(*)
No problem


(*) https://extensions.openoffice.org/en/project/mysql-driver-apache-openoffice