ast-project/part1/results/3/bug_23902fb4-4435-4216-8877-c614a880190a_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  a TEXT,
  b TEXT
);
INSERT INTO T VALUES ('a','b'), ('c','d');
SELECT * FROM T WHERE a = REPLACE('a;',';','') AND b = 'b';
BEGIN EXCLUSIVE TRANSACTION;
PRAGMA secure_delete = 1;
PRAGMA index_list(users);
PRAGMA reverse_unordered_selects = TRUE;
.dbinfo main
CREATE TABLE map_integer (id INT, name);
INSERT INTO map_integer VALUES(1,'a');
CREATE TABLE map_text (id TEXT, name);
INSERT INTO map_text VALUES('4','e');
CREATE TABLE data (id TEXT, name);
INSERT INTO data VALUES(1,'abc');
INSERT INTO data VALUES('4','xyz');
CREATE VIEW idmap as SELECT * FROM map_integer UNION SELECT * FROM map_text;
CREATE TABLE mzed AS SELECT * FROM idmap;
PRAGMA automatic_index=ON;
SELECT * FROM data JOIN idmap USING(id);

ALTER TABLE map_text RENAME COLUMN id TO id_r1807;
END;

Actual output

a|b
1
database page size:  4096
write format:        1
read format:         1
reserved bytes:      0
file change counter: 0
database page count: 2
freelist page count: 0
schema cookie:       1
schema format:       4
default cache size:  0
autovacuum top root: 0
incremental vacuum:  0
text encoding:       1 (utf8)
user version:        0
application id:      0
software version:    0
number of tables:    1
number of indexes:   0
number of triggers:  0
number of views:     0
schema size:         37
data version         3
1|abc|a

Expectation

a|b
1
database page size:  4096
write format:        1
read format:         1
reserved bytes:      0
file change counter: 0
database page count: 2
freelist page count: 0
schema cookie:       1
schema format:       4
default cache size:  0
autovacuum top root: 0
incremental vacuum:  0
text encoding:       1 (utf8)
user version:        0
application id:      0
software version:    0
number of tables:    1
number of indexes:   0
number of triggers:  0
number of views:     0
schema size:         37
data version         3
4|xyz|e

Flag