drawdb icon indicating copy to clipboard operation
drawdb copied to clipboard

[BUG]When importing SQL source files, bit type fields are not supported

Open majiang213 opened this issue 1 year ago • 2 comments

Describe the bug As the title

To Reproduce Steps to reproduce the behavior: 1.文件 -> 导入 SQL 源代码

create table a
(
    deleted bit,
);

2.Get an error SyntaxError [Ln 4, Col 1]: Expected "#", "(", "--", "/*", or [ \t\n\r] but ")" found.

image

Expected behavior import success

Desktop (please complete the following information):

  • OS: MacOS 14.6.1 (23G93)
  • Arc Browser 1.63.0

Additional context Because it does not support sql type files, I changed the suffix to txt bit_test.txt

majiang213 avatar Oct 09 '24 03:10 majiang213

reported https://github.com/taozhi8833998/node-sql-parser/issues/2162

1ilit avatar Oct 09 '24 09:10 1ilit

I had similar error as @majiang213 but, what I observed, if you write sql file in following format we can see table created in UI but only the first table created from script. I am expecting to create two tables even though tables doesn't have relationship. correct me if I am wrong.

create table student(
	id int not null,
	name nvarchar(50)
)
go

create table college(
	id int not null,
	name nvarchar(50)
)
go
image

srichatala avatar Oct 25 '24 02:10 srichatala