## Summary **No review yet** ## Minimized query ```sql 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 ```sql 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 ```sql 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 ``` ```