## Summary **No review yet** ## Minimized query ```sql .dbconfig .load /home/test/sqlite3-src/build/rot13.so SELECT rot13('SMI 31/12 CHF 100000 PUTS'); BEGIN TRANSACTION; CREATE TABLE T ( A VARCHAR(15) PRIMARY KEY, B VARCHAR(30) NOT NULL, C BIGINT UNIQUE ); INSERT INTO T VALUES ('a', 'x', -9223372036854775808); INSERT INTO T VALUES ('b', 'y', -1000000); INSERT INTO T VALUES ('c', 'y', 0); INSERT INTO T VALUES ('d', 'y', 42); INSERT INTO T VALUES ('e', 'x', 9223372036854775807); INSERT INTO T VALUES ('f', 'z', 2147483648); SELECT * FROM T WHERE C > 0 ORDER BY C DESC; COMMIT TRANSACTION; SELECT MIN(A) FROM T; CREATE TRIGGER IF NOT EXISTS trg_T_7647 AFTER UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(IGNORE); END; SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid; ``` ## Actual output ```sql defensive off dqs_ddl on dqs_dml on enable_fkey off enable_qpsg off enable_trigger on enable_view on fts3_tokenizer off legacy_alter_table off legacy_file_format off load_extension on no_ckpt_on_close off reset_database off trigger_eqp off trusted_schema on writable_schema off FZV 31/12 PUS 100000 CHGF e|x|9223372036854775807 f|z|2147483648 d|y|42 a a|x|-9223372036854775808|a|x|-9223372036854775808 b|y|-1000000|b|y|-1000000 c|y|0|c|y|0 d|y|42|d|y|42 e|x|9223372036854775807|e|x|9223372036854775807 f|z|2147483648|f|z|2147483648 ``` ## Expectation ```sql attach_create on attach_write on comments on defensive on dqs_ddl off dqs_dml off enable_fkey off enable_qpsg off enable_trigger on enable_view on fts3_tokenizer off legacy_alter_table off legacy_file_format off load_extension on no_ckpt_on_close off reset_database off reverse_scanorder off stmt_scanstatus off trigger_eqp off trusted_schema off writable_schema off FZV 31/12 PUS 100000 CHGF e|x|9223372036854775807 f|z|2147483648 d|y|42 a a|x|-9223372036854775808|a|x|-9223372036854775808 b|y|-1000000|b|y|-1000000 c|y|0|c|y|0 d|y|42|d|y|42 e|x|9223372036854775807|e|x|9223372036854775807 f|z|2147483648|f|z|2147483648 ``` ## Flag ``` ```