Create table with a keyword(without quote) returns unknown message

[WenyXu]

What type of bug is this?

User Experience

What subsystems are affected?

Table Engine

Minimal reproduce step

It only happened in pg protocol.

CREATE TABLE "QUo"(
"rEpELLAT" TIMESTAMP(3) TIME INDEX,
minus FLOAT NOT NULL,
"SAEPe" BOOLEAN DEFAULT false,
"culPa" INT NULL,
"SUSCipit" FLOAT NOT NULL,
quibusdam BIGINT NOT NULL,
at INT,
"Non" INT NOT NULL,
"lABORE" FLOAT NULL,
PRIMARY KEY(at)
)
ENGINE=mito

What did you expect to see?

{ severity: Error, code: "XX000", message: "", detail: None, hint: None, position: None, where: None, schema: None, table: None, column: None, data_type: None, constraint: None, file: None, line: None, routine: None }

What did you see instead?

Returns some hint to users

What operating system did you use?

doesn't matter

What version of GreptimeDB did you use?

0.6.0

Relevant log output and stack trace

No response

[v0y4g3r]

Escaping at column will do the trick:

CREATE TABLE "QUo"(
"rEpELLAT" TIMESTAMP(3) TIME INDEX,
minus FLOAT NOT NULL,
"SAEPe" BOOLEAN DEFAULT false,
"culPa" INT NULL,
"SUSCipit" FLOAT NOT NULL,
"quibusdam" BIGINT NOT NULL,
"at" INT,
"Non" INT NOT NULL,
"lABORE" FLOAT NULL,
PRIMARY KEY("at")
)
ENGINE=mito;

AT is a keyword in SQL.

[WenyXu]

Escaping at column will do the trick:

CREATE TABLE "QUo"(
"rEpELLAT" TIMESTAMP(3) TIME INDEX,
minus FLOAT NOT NULL,
"SAEPe" BOOLEAN DEFAULT false,
"culPa" INT NULL,
"SUSCipit" FLOAT NOT NULL,
"quibusdam" BIGINT NOT NULL,
"at" INT,
"Non" INT NOT NULL,
"lABORE" FLOAT NULL,
PRIMARY KEY("at")
)
ENGINE=mito;

AT is a keyword in SQL.

Yes, the problem here is that error message is missing.🥺