mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-13 12:28:30 +00:00
25 lines
782 B
Plaintext
25 lines
782 B
Plaintext
|
|
CREATE TABLE nodes(
|
|
local_relpath TEXT PRIMARY KEY,
|
|
moved_to TEXT
|
|
);
|
|
INSERT INTO nodes VALUES('A',NULL);
|
|
INSERT INTO nodes VALUES('A/B',NULL);
|
|
INSERT INTO nodes VALUES('',NULL);
|
|
INSERT INTO nodes VALUES('A/B/C-move',NULL);
|
|
INSERT INTO nodes VALUES('A/B/C','A/B/C-move');
|
|
INSERT INTO nodes VALUES('A/B-move',NULL);
|
|
INSERT INTO nodes VALUES('A/B-move/C-move',NULL);
|
|
INSERT INTO nodes VALUES('A/B-move/C','x');
|
|
SELECT local_relpath, moved_to
|
|
FROM nodes
|
|
WHERE (local_relpath = 'A/B' OR
|
|
((local_relpath > 'A/B/') AND (local_relpath < 'A/B0')))
|
|
AND moved_to IS NOT NULL;
|
|
|
|
|
|
CREATE TABLE t1(x TEXT UNIQUE, y TEXT UNIQUE, z);
|
|
INSERT INTO t1 VALUES('ghi','jkl','y');
|
|
SELECT * FROM t1 WHERE (x='ghi' OR y='jkl') AND z IS NOT NULL;
|
|
|