[BUG]Some keywords that are not recognized when importing SQL source code (PG).
- Dominant language
- JavaScript
- Stars
- 39.5k
- Forks
- 3.2k
- Avg merge
- 10h 46m
- Merged PRs (30d)
- 16
Description
SQL Import Issues
When importing the provided SQL source code via the menu, two issues were encountered:
Unrecognized Auto-Incrementing Sequence: The GENERATED BY DEFAULT AS IDENTITY clause for the auto-incrementing sequence was not recognized.
Unidentifiable Enum Types: The enumeration types, such as ENUM_LOGS_ENTRY_CATEGORY, could not be created, leading to them being unrecognized.
CREATE TABLE "t_logs" (
"log_id" INTEGER NOT NULL UNIQUE GENERATED BY DEFAULT AS IDENTITY,
"pat_id" VARCHAR(50) NOT NULL,
"entry_category" ENUM_LOGS_ENTRY_CATEGORY NOT NULL,
"operation_type" ENUM_LOGS_OPER_TYPE NOT NULL,
"entry_count" INTEGER NOT NULL,
"created_at" TIMESTAMP NOT NULL DEFAULT NOW(),
PRIMARY KEY("log_id")
);
Contributor guide
Assessment
This issue has not been assessed yet.