Skip to content

SQL: Table name identifiers should be normalized to lowercase unless quoted #1771

@mkmik

Description

@mkmik

Describe the bug

Since we claim postgresql dialect compatibility, table identifiers in SQL should be normalized to lowercase unless quoted.

To Reproduce

> create table t1 as select * from (values (11, 'a')) as sq;
> select column1 from T1;
Plan("Table or CTE with name 'T1' not found")

Expected behavior

> create table t1 as select * from (values (11, 'a')) as sq;
> select column1 from T1;
+---------+
| column1 |
+---------+
| 11      |
+---------+
> select column1 from "T1";
Plan("Table or CTE with name 'T1' not found")

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions