search

drawdb-io / drawdb

Free, simple, and intuitive online database diagram editor and SQL generator.
https://drawdb.app
GNU Affero General Public License v3.0
22.7k stars 1.58k forks source link

[BUG]MySQL, Import from SQL TEXT parsing fail #235

Open xuetuing opened 2 months ago

xuetuing commented 2 months ago

issue using "import form SQL" feature with MySQL : TEXT

How to reproduce image

CREATE TABLE `ys_map_info` (
    `id` SMALLINT NOT NULL AUTO_INCREMENT UNIQUE,
    `detail` TEXT(65535),
    PRIMARY KEY(`id`)
);

Fail

But if the datatype is VARCHAR:

CREATE TABLE `ys_map_info` (
    `id` SMALLINT NOT NULL AUTO_INCREMENT UNIQUE,
    `detail` varchar(65535),
    PRIMARY KEY(`id`)
);

image

OK

1ilit commented 2 months ago

Hey! Just reported it https://github.com/taozhi8833998/node-sql-parser/issues/2099

Nopandi1101 commented 2 months ago

UQC53Sk3lkCm0E7kSejCsBk8z9f_Yf4ndp-MNNUjRhG5O0KV