xtdb icon indicating copy to clipboard operation
xtdb copied to clipboard

Unexpected "Table/Column not found" WARNs during UPDATE

Open refset opened this issue 1 year ago • 0 comments

Starting XTDB 2.x (pre-alpha) @ "dev-SNAPSHOT" @ 28e33c5 ...
10:24:36 | INFO  xtdb.api.metrics.PrometheusMetrics | Prometheus server started on port 8080
10:24:40 | INFO  xtdb.server | HTTP server started on port:  3000
10:24:41 | INFO  xtdb.pgwire | PGWire server started on port: 5432
10:24:41 | INFO  xtdb.cli | Node started
10:25:17 | WARN  xtdb.sql.plan | Table not found: foo
10:25:17 | WARN  xtdb.sql.plan | Column not found: xt$id
➜  ~ psql -h localhost -p 5432
psql (16.3, server 16)
Type "help" for help.

jdt=> INSERT into foo (_id, val) VALUES (1, 1);
INSERT 0 0
jdt=> UPDATE foo SET val = 2 WHERE _id = 1;
UPDATE 0
jdt=> SELECT * FROM foo;
 _id | val 
-----+-----
   1 |   2
(1 row)

refset avatar Aug 06 '24 10:08 refset