## Summary **No review yet** ## Minimized query ```sql .timer 192319231923 PRAGMA user_version; ATTACH DATABASE ':memory:' AS aux37; CREATE TABLE person (org_id TEXT NOT NULL, nickname TEXT NOT NULL, license TEXT, CONSTRAINT person_pk PRIMARY KEY (org_id, nickname), CONSTRAINT person_license_uk UNIQUE (license) ); INSERT INTO person VALUES('meyers', 'jack', '2GAT123'); INSERT INTO person VALUES('meyers', 'hill', 'V345FMP'); INSERT INTO person VALUES('meyers', 'jim', '2GAT138'); INSERT INTO person VALUES('smith', 'maggy', ''); CREATE TABLE t2(a PRIMARY KEY, b); INSERT INTO t2 VALUES('abc', 'xxx'); INSERT INTO t2 VALUES('def', 'yyy'); SELECT org_id, count((NOT (org_id IS NULL)) AND (NOT (nickname IS NULL))) FROM person WHERE (CASE WHEN license != '' THEN CAST(1 AS CHARACTER(20)) ELSE 0 END) GROUP BY 1; SELECT a, max(b || a) FROM t2 WHERE (b||b||b)!='value' GROUP BY a; DROP TRIGGER IF EXISTS person; CREATE TRIGGER IF NOT EXISTS trg_t2_959 AFTER INSERT ON t2 BEGIN SELECT RAISE(IGNORE); END; DETACH DATABASE aux37; INSERT INTO t2 VALUES (NULL, NULL); PRAGMA max_page_count; INSERT INTO t2 DEFAULT VALUES; VACUUM; INSERT INTO t2 DEFAULT VALUES; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<7) SELECT * FROM cnt; ALTER TABLE person RENAME COLUMN nickname TO nickname_r6468; CREATE TEMP VIEW IF NOT EXISTS v_person_8942 AS SELECT org_id FROM person; ``` ## Actual output ```sql 0 Run Time: real 0.000 user 0.000073 sys 0.000000 Run Time: real 0.000 user 0.000131 sys 0.000000 Run Time: real 0.000 user 0.000175 sys 0.000000 Run Time: real 0.000 user 0.000030 sys 0.000000 Run Time: real 0.000 user 0.000015 sys 0.000000 Run Time: real 0.000 user 0.000013 sys 0.000000 Run Time: real 0.000 user 0.000014 sys 0.000000 Run Time: real 0.000 user 0.000080 sys 0.000000 Run Time: real 0.000 user 0.000013 sys 0.000000 Run Time: real 0.000 user 0.000009 sys 0.000000 meyers|3 Run Time: real 0.000 user 0.000065 sys 0.000000 abc|xxxabc def|yyydef Run Time: real 0.000 user 0.000031 sys 0.000000 Run Time: real 0.000 user 0.000005 sys 0.000000 Run Time: real 0.000 user 0.000061 sys 0.000000 Run Time: real 0.001 user 0.000012 sys 0.000000 Run Time: real 0.000 user 0.000026 sys 0.000000 1073741823 Run Time: real 0.000 user 0.000007 sys 0.000000 Run Time: real 0.000 user 0.000014 sys 0.000000 Run Time: real 0.000 user 0.000410 sys 0.000000 Run Time: real 0.000 user 0.000077 sys 0.000000 1 2 3 4 5 6 7 Run Time: real 0.000 user 0.000104 sys 0.000000 Run Time: real 0.001 user 0.000700 sys 0.000000 Run Time: real 0.000 user 0.000078 sys 0.000000 ``` ## Expectation ```sql 0 Run Time: real 0.000026 user 0.000036 sys 0.000000 Run Time: real 0.000064 user 0.000065 sys 0.000000 Run Time: real 0.000097 user 0.000098 sys 0.000000 Run Time: real 0.000031 user 0.000031 sys 0.000000 Run Time: real 0.000009 user 0.000010 sys 0.000000 Run Time: real 0.000007 user 0.000007 sys 0.000000 Run Time: real 0.000007 user 0.000007 sys 0.000000 Run Time: real 0.000067 user 0.000067 sys 0.000000 Run Time: real 0.000008 user 0.000007 sys 0.000000 Run Time: real 0.000005 user 0.000005 sys 0.000000 meyers|3 Run Time: real 0.000039 user 0.000039 sys 0.000000 abc|xxxabc def|yyydef Run Time: real 0.000019 user 0.000020 sys 0.000000 Run Time: real 0.000003 user 0.000004 sys 0.000000 Run Time: real 0.000034 user 0.000034 sys 0.000000 Run Time: real 0.000005 user 0.000006 sys 0.000000 Run Time: real 0.000015 user 0.000015 sys 0.000000 4294967294 Run Time: real 0.000004 user 0.000005 sys 0.000000 Run Time: real 0.000008 user 0.000008 sys 0.000000 Run Time: real 0.000280 user 0.000281 sys 0.000000 Run Time: real 0.000041 user 0.000042 sys 0.000000 1 2 3 4 5 6 7 Run Time: real 0.000067 user 0.000067 sys 0.000000 Run Time: real 0.000392 user 0.000392 sys 0.000000 Run Time: real 0.000039 user 0.000040 sys 0.000000 ``` ## Flag ``` ```