Issue 67114

Summary:	trying to create an ENUM column in a MySQL table fails with a syntax error
Product:	Base	Reporter:	Frank Schönheit <frank.schoenheit>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	CLOSED FIXED_WITHOUT_CODE	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues, oooforum
Version:	680m174
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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