Clojurians Log v2
Clojure programming
Channels
Apps
xtdb
Piotr Roterski 2025-04-01T04:07:58.931579Z
Hello 👋
I played with xtdb2 (2.0.0-beta6) via clojure API and ran into a bit inconsistent/confusing behaviour around table names with dashes and * queries.
When a table has a name with a dash e.g. table-a then * queries don't work with it unless you use an underscored version of the table name in the query i.e.`table_a` . Please see the attached snippet for code example.
Is this some sort of a known limitation or a bug?
refset 2025-04-01T13:43:21.272139Z
Hey @pt.roterski this is due to the 'normalization' to snake_case on the way in that ensures everything remains queryable via SQL (i.e. hyphens aren't supported in SQL table names unless quoted). The behaviour you're observing when querying here is (should be) the same as you'd see when using next.jdbc and some other SQL db.
However we do have a small bit of outstanding work to reduce confusion here, per https://github.com/xtdb/xtdb/issues/3672 - so I'd say this is an outstanding but known bug currently, and we probably want this API to coerce back to kebab-case. Hope that makes sense! We've been focusing all energy recently on the Postgres compatibility API, so that will be more stable. You might be interested to see this if you've not come across it already https://github.com/xtdb/driver-examples/blob/main/clojure/dev/user.clj
🙌 1