1037 lines
37 KiB
Markdown
1037 lines
37 KiB
Markdown
## Summary
|
||
<!--Explain briefly what goes wrong and explain why you believe this is a bug and not the intended behavior of SQLite (if it is not a crash).-->**No review yet**
|
||
|
||
## Minimized query
|
||
|
||
```sql
|
||
SAVEPOINT sp5080;
|
||
PRAGMA read_uncommitted = OFF;
|
||
.timeout datetime(999999)
|
||
CREATE TABLE T1 (
|
||
a INTEGER,
|
||
b TEXT
|
||
);
|
||
CREATE TABLE T2 (
|
||
a INTEGER,
|
||
b TEXT
|
||
);
|
||
INSERT INTO T1 VALUES (1,'a'),(2,'b');
|
||
INSERT INTO T2 VALUES (1,'c'),(1,'d');
|
||
SELECT T1.b,
|
||
(
|
||
SELECT GROUP_CONCAT(b,',')
|
||
FROM T2
|
||
WHERE T2.a=T1.a
|
||
) AS c
|
||
FROM T1;
|
||
PRAGMA module_list;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (-upper('hello') + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
|
||
CREATE TABLE `T` (
|
||
a TEXT,
|
||
b TEXT,
|
||
c REAL
|
||
);
|
||
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
|
||
SELECT a,b,c,
|
||
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
|
||
CREATE INDEX IF NOT EXISTS idx_T_2871 ON T((b + 1));
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
SELECT MAX(a) FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
|
||
CREATE TABLE T (
|
||
a TEXT,
|
||
b TEXT,
|
||
c REAL
|
||
);
|
||
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
|
||
SELECT a,b,c,
|
||
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
|
||
CREATE INDEX IF NOT EXISTS idx_T_2871 ON T((b + 1));
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
SELECT MAX(a) FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
|
||
CREATE TABLE T (
|
||
a TEXT,
|
||
b TEXT,
|
||
c REAL
|
||
);
|
||
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
|
||
SELECT a,b,c,
|
||
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
|
||
CREATE INDEX IF NOT EXISTS idx_T_2871 ON T((b + 1));
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
SELECT MAX(a) FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
|
||
CREATE TABLE T (
|
||
a TEXT,
|
||
b TEXT,
|
||
c REAL
|
||
);
|
||
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
|
||
SELECT a,b,c,
|
||
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
|
||
CREATE INDEX IF NOT EXISTS idx_T_2871 ON T((b + 1));
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
SELECT MAX(a) FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
|
||
CREATE TABLE T (
|
||
a TEXT,
|
||
b TEXT,
|
||
c REAL
|
||
);
|
||
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
|
||
SELECT a,b,c,
|
||
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
|
||
CREATE INDEX IF NOT EXISTS idx_T_2871 ON T((b + 1));
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
SELECT MAX(a) FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
.log ON
|
||
.quit
|
||
PRAGMA encoding=UTF16le;
|
||
CREATE TABLE `tkt3376`(a COLLATE nocase PRIMARY KEY);
|
||
INSERT INTO main.tkt3376 VALUES('abc');
|
||
INSERT INTO tkt3376 VALUES('ABX');
|
||
SELECT DISTINCT a FROM tkt3376;
|
||
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_6708 AS SELECT a FROM tkt3376;
|
||
CREATE INDEX IF NOT EXISTS idx_tkt3376_5408 ON tkt3376((a + x'ba14badb54c11059534514678aee')) WHERE a IS NOT NULL;
|
||
INSERT INTO tkt3376 SELECT * FROM tkt3376;
|
||
DROP INDEX IF EXISTS tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_8280 AS SELECT a FROM tkt3376;
|
||
INSERT INTO tkt3376 VALUES (NULL);
|
||
SELECT * FROM tkt3376;
|
||
SELECT * FROM tkt3376 WHERE a IN (SELECT a FROM tkt3376 LIMIT (0 + 0));
|
||
UPDATE tkt3376 SET a = NULL WHERE 1;
|
||
|
||
SELECT COUNT(*) FROM tkt3376;
|
||
CREATE VIEW IF NOT EXISTS v_tkt3376_4824 AS SELECT a FROM tkt3376;
|
||
|
||
CREATE TABLE T (
|
||
a TEXT,
|
||
b TEXT,
|
||
c REAL
|
||
);
|
||
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
|
||
SELECT a,b,c,
|
||
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
|
||
CREATE INDEX IF NOT EXISTS idx_T_2871 ON T((b + 1));
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
ALTER TABLE tkt3376 DROP COLUMN a;
|
||
SELECT MAX(a) FROM tkt3376;
|
||
|
||
SELECT TOTAL(a) FROM tkt3376;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_592 AS SELECT a FROM tkt3376;
|
||
REINDEX;
|
||
ALTER TABLE tkt3376 RENAME COLUMN a TO a_r442;
|
||
SELECT * FROM tkt3376 AS a CROSS JOIN tkt3376 AS b ON a.rowid = b.rowid;
|
||
CREATE TABLE T (
|
||
a INTEGER,
|
||
b TEXT,
|
||
c REAL,
|
||
d REAL
|
||
);
|
||
INSERT INTO T VALUES (1,'a',40.5,-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999);
|
||
SELECT b FROM T WHERE ABS(c) > 5 AND ABS(d) > 5;
|
||
ALTER TABLE T RENAME COLUMN c TO c_r3437;
|
||
RELEASE sp5080;
|
||
CREATE INDEX IF NOT EXISTS idx_T_2499 ON T(lower(a));
|
||
WITH cte AS (SELECT NULL AS x) SELECT COALESCE(x, 0) FROM cte;
|
||
INSERT INTO T1 VALUES (NULL, NULL);
|
||
SELECT b FROM T2 UNION SELECT b FROM (SELECT * FROM T2) AS sub;
|
||
INSERT INTO T2 VALUES (1, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
|
||
ANALYZE;
|
||
CREATE TEMP VIEW IF NOT EXISTS v_tkt3376_2093 AS SELECT a FROM tkt3376;
|
||
CREATE TABLE T1 (
|
||
a INTEGER,
|
||
b REAL
|
||
);
|
||
CREATE TABLE T2 (
|
||
a INTEGER,
|
||
b REAL
|
||
);
|
||
INSERT INTO T1 VALUES (1,1.0);
|
||
INSERT INTO T2 VALUES (1,-1.0),(2,9e999);
|
||
INSERT OR REPLACE INTO T1
|
||
SELECT * FROM T2;
|
||
SELECT * FROM T1;
|
||
```
|
||
|
||
## Actual output
|
||
|
||
```sql
|
||
a|c,d
|
||
b|
|
||
sqlite_dbdata
|
||
generate_series
|
||
completion
|
||
fsdir
|
||
tables_used
|
||
sqlite_stmt
|
||
json_tree
|
||
fts4aux
|
||
fts3
|
||
fts4
|
||
sqlite_dbptr
|
||
fts3tokenize
|
||
bytecode
|
||
rtree_i32
|
||
sqlite_dbpage
|
||
rtree
|
||
dbstat
|
||
json_each
|
||
```
|
||
|
||
## Expectation
|
||
|
||
```sql
|
||
a|c,d
|
||
b|
|
||
fsdir
|
||
generate_series
|
||
bytecode
|
||
dbstat
|
||
tables_used
|
||
sqlite_stmt
|
||
sqlite_dbpage
|
||
rtree_i32
|
||
fts4aux
|
||
fts3
|
||
zipfile
|
||
fts4
|
||
completion
|
||
rtree
|
||
fts3tokenize
|
||
```
|
||
|
||
## Flag
|
||
|
||
```
|
||
|
||
```
|
||
|