GreptimeTeam / docs

Document for GreptimeDB
https://docs.greptime.com/
Apache License 2.0
37 stars 37 forks source link

Add notes for table name that contain uppercase letters #433

Open sunng87 opened 1 year ago

sunng87 commented 1 year ago

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'

killme2008 commented 3 months ago

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