Skip to content

Table names are case-sensitive when querying #6637

@jstirnaman

Description

@jstirnaman

Uppercase table names are allowed, but you must preserve the case when querying them:

"CPU" is needed to make table name in query to preserve the case.

+----------+
| count(*) |
+----------+
| 1        |
+----------+```
Without the `"`, you can see the same error

```❯ ./influxdb3 query -d test1 'select count(*) from CPU'
Query command failed: server responded with error [500 Internal Server Error]: query error: error while planning query: Error during planning: table 'public.iox.cpu' not found```
Note: I'm not on `3.7.0`, but I don't think version matters for this.

## Related links
- https://docs.influxdata.com/influxdb3/enterprise/admin/tables/create/#table-naming-restrictions

[Slack Message](https://influxdata.slack.com/archives/C084G9LR2HL/p1765975186314399?thread_ts=1765967953.967879&cid=C084G9LR2HL)

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions