mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 14:23:38 +00:00
15 lines
282 B
Plaintext
15 lines
282 B
Plaintext
|
|
CREATE TABLE t5(a, b, c DEFAULT 'c', d);
|
|
|
|
|
|
INSERT INTO t5(a) SELECT 456 UNION ALL SELECT 123 ORDER BY 1;
|
|
SELECT * FROM t5 ORDER BY rowid;
|
|
|
|
|
|
CREATE VIRTUAL TABLE t0 USING fts4(a);
|
|
|
|
|
|
INSERT INTO t0 SELECT 0 UNION SELECT 0 AS 'x' ORDER BY x;
|
|
SELECT * FROM t0;
|
|
|