Jeremy Taylor
Jeremy Taylor
``` xtdb=> SELECT AVG("UserID") FROM hits; ERROR: unexpected server error during query execution ``` At a minimum we want to bubble up the exception to the pgwire user. This is...
e.g. Clickbench uses `GROUP BY 1` in: `SELECT 1, URL, COUNT(*) AS c FROM hits GROUP BY 1, URL ORDER BY c DESC LIMIT 10;` One possible workaround might be...
Various Postgres tooling (e.g. Looker below) expects to be able to pass a quoted string like `'SECOND'` to the DATE_TRUNC function, instead of simply `SECOND` as the unit parameter (which...
XTDB captures timestamp timezone information wherever it is provided, and returns it to clients (in the original timezone) wherever possible. It does this to align with the underlying [Apache Arrow...
with beta7 (the first event below doesn't include a timezone) ``` xtdb=> WITH events AS ( SELECT 1 AS event_id, TIMESTAMP '2025-04-25T14:00:00' AS event_time UNION ALL SELECT 2, TIMESTAMP WITH...
[The docs](https://docs.xtdb.com/reference/main/data-types) currently show "TIMESTAMP WITH TIMEZONE" (etc.) but AFAICT right now we only generally support "TIME ZONE" (two words, not one word): `SELECT TIMESTAMP WITH TIMEZONE '2020-01-01 18:00:00+00:00'` =>...
``` WITH x AS ( SELECT 1 as a, ROW_NUMBER() OVER ( PARTITION BY a ORDER BY a ) AS rn ) FROM x ``` => `ERROR: Error preparing statement:...
SQLTools generally _appears_ to work fine already from the UI, but looking at XT's logs we can see a couple of failing queries: ``` 17:29:13.049 DEBUG xtdb.pgwire - Interpreting SQL:...
An ability to set the default admin password via an environment variable (currently always `xtdb`/`xtdb`) would bring XTDB in line with how containerised Postgres is typically configured, where POSTGRES_PASSWORD is...
e.g. Postgres achieves this via a [configuration](https://www.postgresql.org/docs/current/auth-pg-hba-conf.html) in `pg_hba.conf`: ``` # Disallow non-SSL hostnossl all all 0.0.0.0/0 reject ```