Jeremy Taylor

@FiV0 yep I just checked also against the examples above - all look good now :clap:

`xt$txs` probably shows it as not-committed. The [Fiddle](https://fiddle.xtdb.com/?version=2.0.0-SNAPSHOT&type=sql&txs=W3sic3lzdGVtLXRpbWUiOm51bGwsInR4cyI6IklOU0VSVCBJTlRPIGZvbyAoeHQkaWQsIGJhcikgVkFMVUVTICgxLCAndG90bzEnKTtcbklOU0VSVCBJTlRPIGZvbyAoeHQkaWQsIGJhcikgVkFMVUVTICgyLCAndG90bzInKTsifSx7InR4cyI6IlVQREFURSBmb28gU0VUIGJhciA9ICd0b3RvMycgV0hFUkUgeHQkaWQgPSAyOyIsInN5c3RlbS10aW1lIjpudWxsfV0%3D&query=U0VMRUNUIGZvby4qIEZST00gZm9vOw%3D%3D) version queries the `xt$txs` table automatically and surfaces the actual error: ``` Error: xtdb.IllegalArgumentException Invalid SQL query: - XTDB requires fully-qualified columns:...

Aside: the utility of `submit-tx` as an API is under consideration. Something more like `transact` would probably be more appropriate as the default user journey. I don't think there's an...

Looks [fixed](https://play.xtdb.com/?version=2.0.0-SNAPSHOT&type=sql&txs=W3sic3lzdGVtLXRpbWUiOm51bGwsInR4cyI6IklOU0VSVCBJTlRPIGZvbyAoeHQkaWQsIGJhcikgVkFMVUVTICgxLCAndG90bzEnKTtcbklOU0VSVCBJTlRPIGZvbyAoeHQkaWQsIGJhcikgVkFMVUVTICgyLCAndG90bzInKTtcblVQREFURSBmb28gU0VUIGJhciA9ICd0b3RvMycgV0hFUkUgeHQkaWQgPSAyOyJ9XQ%3D%3D&query=U0VMRUNUIHh0JGlkLCBiYXIgRlJPTSBmb28%3D).

Noting that this exists: https://github.com/geoarrow/geoarrow

Unfortunately there's no change, running against the latest commit (#3619 isn't released yet): ``` jdt=> INSERT INTO docs (xt$id, foo, xt$valid_from) VALUES (1, 'bar', DATE '2024-03-25'); INSERT 0 0 jdt=>...

Hey @shevchuk thanks for the report :pray: `lets` probably needs an apostrophe too!

Update: no longer stopping ingestion, but there's a silent failure when submitting to psql (_txs shows committed) ``` jdt=> insert into foo (xt$id, foo) values (1, {"fo;o":2}); INSERT 0 0...

I just checked out the current state of this and it now returns an error rather than incorrect result: ``` jdt=> INSERT INTO docs (_id, foo) VALUES (1, 'bar'); INSERT...

The built version (via the preview URL you shared) doesn't work right on Chromium 124.0 - producing several JS errors:  Meaning components aren't initialized properly as a result: