View Issue Details

IDProjectCategoryView StatusLast Update
0004003SymmetricDSBugpublic2019-06-25 14:06
ReporterelongAssigned Toelong 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.2 
Target Version3.10.3Fixed in Version3.10.3 
Summary0004003: MySQL table creation failed for ENUM during initial load
DescriptionTable with enum does not use correct SQL to create the table on the target. The XML in the log looks correct:

<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
    <table name="fruits">
        <column name="id" primaryKey="true" required="true" type="INTEGER" size="10">
            <platform-column name="mysql" type="INT" size="10"/>
        </column>
        <column name="fruit" type="CHAR" size="6">
            <platform-column name="mysql" type="ENUM" size="6" enumValues="apple,orange,pear"/>
        </column>
    </table>
</database>

But the SQL it generates is not correct:

CREATE TABLE `fruits`(
    `id` INT NOT NULL,
    `fruit` CHAR(6) NULL,
    PRIMARY KEY (`id`)
);

Here is the correct SQL:

CREATE TABLE `fruits`(
    `id` INT NOT NULL,
    `fruit` ENUM('apple','orange','pear') NULL,
    PRIMARY KEY (`id`)
);
Tagsddl/schema, dialect: mysql/mariadb

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 7c2f34f3

2019-06-13 14:02:10

admin

Details Diff
0004003: MySQL table creation failed for ENUM during initial load
0004003
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mysql/MySqlDdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2019-06-13 13:56 elong New Issue
2019-06-13 13:56 elong Status new => assigned
2019-06-13 13:56 elong Assigned To => elong
2019-06-13 13:56 elong Tag Attached: ddl/schema
2019-06-13 13:56 elong Tag Attached: dialect: mysql/mariadb
2019-06-13 14:02 elong Status assigned => resolved
2019-06-13 14:02 elong Resolution open => fixed
2019-06-13 14:02 elong Fixed in Version => 3.10.3
2019-06-13 15:00 admin Changeset attached => SymmetricDS 3.10 7c2f34f3
2019-06-25 14:06 admin Status resolved => closed