greptimedb
greptimedb copied to clipboard
Cannot select column with upper case letter in name
Desc
I try to query a column with upper case letter in its name and get an "Invalid identifier" error.
Reproduce
mysql> create table test (Column_1 int, column_2 int, ts timestamp, TIME INDEX (ts));
Query OK, 1 row affected (0.02 sec)
mysql> select Column_1 from test;
ERROR 1815 (HY000): Failed to execute query: select Column_1 from test, source: Failed to execute sql, source: Cannot plan SQL: SELECT Column_1 FROM test, source: Error during planning: Invalid identifier '#column_1' for schema fields:[test.Column_1, test.column_2, test.ts], metadata:{"greptime:timestamp_column": "ts", "greptime:version": "0"}
mysql> select column_2 from test;
Empty set (0.01 sec)