drawdb-io / drawdb-io/drawdb

[BUG]Some keywords that are not recognized when importing SQL source code (PG).

Open
#540 4 comments 1 reaction 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.