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]When importing SQL source files, bit type fields are not supported #256

Open
majiang213 opened this issue Oct 9, 2024 · 2 comments

Comments

@majiang213
Copy link

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

@1ilit
Copy link
Member

1ilit commented Oct 9, 2024

reported taozhi8833998/node-sql-parser#2162

@srichatala
Copy link

srichatala commented Oct 25, 2024

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

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

5 participants
@srichatala @majiang213 @1ilit and others