0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-07-12 10:29:25 +00:00
Files
libsql/libsql-sqlite3/test/fixtures/misc4.test
2024-05-27 12:59:10 +02: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;