Closed
Description
When creating a MYSQL database creating a table with an ENUM
or SET
column type the exported SQL file (under file > export SQL) is incorrect.
Whether valid, invalid, or empty values are entered in the drawdb column's values input.
Currently, the exported syntax is
CREATE TABLE .... (
`enum_column` ENUM ...,
`set_column` SET ...,
...
);
missing brackets containing the enum/set's values
the expected output is...
CREATE TABLE .... (
`enum_column` ENUM('value','val',...) ...,
`set_column` SET('a','1',...) ...,
...
);
To Reproduce
Steps to reproduce the behaviour:
- Go to drawdb editor
- Choose a MySQL database
- Create a new table
- Add a column of set or enum type
- Add values for the column
- Click on file > 'Export SQL'
- See erroneous create table statement
Desktop:
- OS: Microsoft Windows 11 Home
- Browser Microsoft Edge
Additional context
Not sure if the MySQL export is for a different version of MySQL (I'm using MySQL V8.0.30), I have a pr to solve the issue that I will link to this issue.
Metadata
Metadata
Assignees
Labels
No labels