greptimedb icon indicating copy to clipboard operation
greptimedb copied to clipboard

Cannot select column with upper case letter in name

Open waynexia opened this issue 2 years ago • 0 comments

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)

waynexia avatar Nov 04 '22 03:11 waynexia