drawdb icon indicating copy to clipboard operation
drawdb copied to clipboard

[BUG]MySQL, Import from SQL TEXT parsing fail

Open xuetuing opened this issue 1 year ago • 2 comments

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

xuetuing avatar Sep 03 '24 07:09 xuetuing

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

1ilit avatar Sep 04 '24 06:09 1ilit