## Summary **No review yet** ## Minimized query ```sql PRAGMA recursive_triggers = NO; PRAGMA count_changes = ON; PRAGMA cache_spill = YES; .dbconfig CREATE TABLE t1(a,b); INSERT INTO t1 VALUES(x'2dd46a66034f1ed5356137b9903e6f4c',11); INSERT INTO t1 VALUES(2,22); INSERT INTO t1 SELECT a+2, b+22 FROM t1; CREATE TABLE T ( A VARCHAR(20), B VARCHAR(10), PRIMARY KEY (A, B) ); INSERT INTO T VALUES ('a', 'p'); INSERT INTO T VALUES ('a', 'q'); INSERT INTO T VALUES ('b', 'q'); INSERT INTO T VALUES ('c', 'r'); INSERT INTO T VALUES ('b', 'r'); INSERT INTO T VALUES ('b', 't'); SELECT B, COUNT(DISTINCT A) AS D FROM T GROUP BY B ORDER BY D DESC, B ASC; INSERT INTO t1 SELECT a+4, b+44 FROM t1; CREATE TABLE t2(c,d); INSERT INTO t2 SELECT a, 900+b FROM t1; PRAGMA automatic_index=ON; SELECT b, d FROM t1 JOIN t2 ON a=c ORDER BY b; CREATE INDEX IF NOT EXISTS idx_t1_8154 ON t1(a COLLATE NOCASE) WHERE a > 0; DELETE FROM t2 WHERE c IS NULL; ALTER TABLE t1 RENAME COLUMN b TO b_r305; INSERT OR REPLACE INTO t2 VALUES (NULL, 0); PRAGMA wal_checkpoint('FULL'); SELECT * FROM t2 AS a RIGHT JOIN t2 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 1 1 2 1 1 1 1 1 1 q|2 r|2 p|1 t|1 4 8 11|911 22|922 22|933 33|922 33|933 44|944 44|955 55|944 55|955 66|966 66|977 77|966 77|977 88|988 0 1 0|-1|-1 -ÔjfOÕ5a7¹>oL|911|-ÔjfOÕ5a7¹>oL|911 2|922|2|922 2|933|2|933 4|944|4|944 4|955|4|955 6|966|6|966 6|977|6|977 8|988|8|988 |0||0 ``` ## 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 1 1 2 1 1 1 1 1 1 q|2 r|2 p|1 t|1 4 8 11|911 22|922 22|933 33|922 33|933 44|944 44|955 55|944 55|955 66|966 66|977 77|966 77|977 88|988 0 1 0|-1|-1 -Ôjf^CO^^Õ5a7¹>oL|911|-Ôjf^CO^^Õ5a7¹>oL|911 2|922|2|922 2|933|2|933 4|944|4|944 4|955|4|955 6|966|6|966 6|977|6|977 8|988|8|988 |0||0 ``` ## Flag ``` ```