0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-05-11 04:55:31 +00:00
Files
libsql/libsql-wal/tests/assets/fixtures/misc4.test
ad hoc ad79ef48a2 libsql wal tests (#1408)
* add tests

* add bench
2024-05-24 13:59:17 +00:00

7 lines
154 B
Plaintext

CREATE TABLE t0(a,b);
INSERT INTO t0 VALUES(1,0),(2,0);
UPDATE t0 SET b=9 WHERE a AND (SELECT a FROM t0 WHERE a);
SELECT * FROM t0 ORDER BY +a;