Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
xuetuing opened this issue Sep 3, 2024 · 2 comments
Open

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

xuetuing opened this issue Sep 3, 2024 · 2 comments

Comments

@xuetuing
Copy link

xuetuing commented Sep 3, 2024

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
Copy link
Member

1ilit commented Sep 4, 2024

Hey! Just reported it taozhi8833998/node-sql-parser#2099

@Nopandi1101
Copy link

UQC53Sk3lkCm0E7kSejCsBk8z9f_Yf4ndp-MNNUjRhG5O0KV

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants