dt-sql-parser icon indicating copy to clipboard operation
dt-sql-parser copied to clipboard

[Bug]: postgreSQL syntax error

Open Cythia828 opened this issue 1 year ago • 0 comments

Version

lasted

Which SQL?

Postgre

SQL content

CREATE TABLE distributors (
    did     integer,
    name    varchar(40),
    CONSTRAINT con1 CHECK (did > 100 AND name <> '')
);

JavaScript/TypeScript code

No response

What happened?

image image image image
  • 从前三个图可以看出,CREATE TABLE语句中的字段在CONSTRAINT情况下字段名是非必填的,但是明显我们不填也不报错,甚至把CONSTRAINT解析为字段名了,说明语法上有点问题
  • 从第四个图可以看出SELECT语句中将本应是字段的地方解析为了function_name了,目前我们基本都没收集function_name在各类语句使用的形态,但是一旦我们开启要收集、提示function_name就会出现实体收集错误的情况

Relevant log output

No response

Cythia828 avatar Aug 01 '24 03:08 Cythia828