mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 08:39:46 +00:00
30 lines
847 B
Plaintext
30 lines
847 B
Plaintext
|
|
CREATE TABLE t1(x INTEGER, y INTEGER);
|
|
WITH data(i) AS (
|
|
SELECT 1 UNION ALL SELECT i+1 FROM data
|
|
)
|
|
INSERT INTO t1 SELECT isqrt(i), isqrt(i) FROM data LIMIT 400;
|
|
CREATE INDEX t1x ON t1(x);
|
|
CREATE INDEX t1y ON t1(y);
|
|
ANALYZE;
|
|
|
|
|
|
DROP TABLE IF EXISTS t1;
|
|
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT);
|
|
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<10000)
|
|
INSERT INTO t1(a, c) SELECT x, x FROM c;
|
|
UPDATE t1 SET b=printf('x%02x',a/500) WHERE a>4000;
|
|
UPDATE t1 SET b='xyz' where a>=9998;
|
|
CREATE INDEX t1b ON t1(b);
|
|
ANALYZE;
|
|
SELECT count(*), b FROM t1 GROUP BY 2 ORDER BY 2;
|
|
|
|
|
|
explain query plan
|
|
SELECT * FROM t1 WHERE b='xyz' AND b IS NOT NULL ORDER BY +a;
|
|
/* v---- Should be "=", not ">" */
|
|
|
|
|
|
SELECT * FROM t1 WHERE b='xyz' AND b IS NOT NULL ORDER BY +a;
|
|
|