embucket-labs icon indicating copy to clipboard operation
embucket-labs copied to clipboard

engine: `SELECT`, `WHERE`, etc - can't find uppercase `Ident`'s

Open DanCodedThis opened this issue 5 months ago • 0 comments

  • Any statements only work with lowercased Identifiers for tables (probably, schemas, databases, fields, etc)
  • This doesn't work:
CREATE OR REPLACE TABLE mytable_1 (amount NUMBER);
SELECT table_name
FROM information_schema.tables
WHERE table_name = 'MYTABLE_1';
  • This does work:
CREATE OR REPLACE TABLE mytable_1 (amount NUMBER);
SELECT table_name
FROM information_schema.tables
WHERE table_name = 'mytable_1';

DanCodedThis avatar Jul 17 '25 19:07 DanCodedThis