ast-project/part1/results/2/bug_4dc83307-a484-43a5-b1a6-1c19b61f8ed2_logic.md

Summary

**No review yet**

Minimized query

.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;
PRAGMA vdbe_listing = FALSE;

Actual output

0
Run Time: real 0.000 user 0.000075 sys 0.000000
Run Time: real 0.000 user 0.000096 sys 0.000000
Run Time: real 0.000 user 0.000130 sys 0.000000
Run Time: real 0.000 user 0.000022 sys 0.000000
Run Time: real 0.000 user 0.000010 sys 0.000000
Run Time: real 0.000 user 0.000009 sys 0.000000
Run Time: real 0.000 user 0.000009 sys 0.000000
Run Time: real 0.000 user 0.000063 sys 0.000000
Run Time: real 0.000 user 0.000009 sys 0.000000
Run Time: real 0.000 user 0.000007 sys 0.000000
meyers|3
Run Time: real 0.000 user 0.000040 sys 0.000000
abc|xxxabc
def|yyydef
Run Time: real 0.000 user 0.000022 sys 0.000000
Run Time: real 0.000 user 0.000003 sys 0.000000
Run Time: real 0.000 user 0.000043 sys 0.000000
Run Time: real 0.000 user 0.000009 sys 0.000000
Run Time: real 0.000 user 0.000019 sys 0.000000
1073741823
Run Time: real 0.000 user 0.000005 sys 0.000000
Run Time: real 0.000 user 0.000010 sys 0.000000
Run Time: real 0.001 user 0.000301 sys 0.000000
Run Time: real 0.000 user 0.000064 sys 0.000000
1
2
3
4
5
6
7
Run Time: real 0.000 user 0.000080 sys 0.000000
Run Time: real 0.000 user 0.000549 sys 0.000000
Run Time: real 0.000 user 0.000047 sys 0.000000
Run Time: real 0.000 user 0.000002 sys 0.000000

Expectation

0
Run Time: real 0.000066 user 0.000079 sys 0.000000
Run Time: real 0.000118 user 0.000118 sys 0.000000
Run Time: real 0.000137 user 0.000138 sys 0.000000
Run Time: real 0.000038 user 0.000038 sys 0.000000
Run Time: real 0.000009 user 0.000009 sys 0.000000
Run Time: real 0.000006 user 0.000007 sys 0.000000
Run Time: real 0.000006 user 0.000007 sys 0.000000
Run Time: real 0.000043 user 0.000044 sys 0.000000
Run Time: real 0.000007 user 0.000007 sys 0.000000
Run Time: real 0.000005 user 0.000005 sys 0.000000
meyers|3
Run Time: real 0.000050 user 0.000050 sys 0.000000
abc|xxxabc
def|yyydef
Run Time: real 0.000020 user 0.000020 sys 0.000000
Run Time: real 0.000004 user 0.000004 sys 0.000000
Run Time: real 0.000034 user 0.000036 sys 0.000000
Run Time: real 0.000009 user 0.000010 sys 0.000000
Run Time: real 0.000020 user 0.000021 sys 0.000000
4294967294
Run Time: real 0.000004 user 0.000005 sys 0.000000
Run Time: real 0.000009 user 0.000010 sys 0.000000
Run Time: real 0.000296 user 0.000296 sys 0.000000
Run Time: real 0.000041 user 0.000041 sys 0.000000
1
2
3
4
5
6
7
Run Time: real 0.000069 user 0.000069 sys 0.000000
Run Time: real 0.000394 user 0.000395 sys 0.000000
Run Time: real 0.000038 user 0.000039 sys 0.000000
Run Time: real 0.000003 user 0.000003 sys 0.000000

Flag