docs icon indicating copy to clipboard operation
docs copied to clipboard

Add notes for table name that contain uppercase letters

Open sunng87 opened this issue 2 years ago • 1 comments

When querying table that has uppercase letter in its name, it results in following error.

{
    "code": 3000,
    "error": "Query engine output error: Failed to execute query: select distinct instance from node_memory_HugePages_Total, source: Failed to plan statement, source: Cannot plan SQL: SELECT DISTINCT instance FROM node_memory_HugePages_Total, source: Error during planning: Table not found: greptime.public.node_memory_hugepages_total",
    "execution_time_ms": 1
}

To resolve this, we will have to add single quote to table name: select distinct instance from 'node_memory_HugePages_Total'

sunng87 avatar Jun 25 '23 08:06 sunng87

Already has a note in compatibility doc, but it must be noted in the user guide @nicecui

https://docs.greptime.com/reference/sql/compatibility#ansi-compatibility

killme2008 avatar Jul 25 '24 05:07 killme2008