## Summary **No review yet** ## Minimized query ```sql .import employee.db main BEGIN; PRAGMA compile_options; CREATE TABLE T ( a INTEGER, b REAL, /* TEXT */ c REAL ); INSERT INTO T VALUES (NULL,round(json_object()),strftime('%s', zeroblob(10.0))), (2,-2.5,20.0), (3,-9e999,30.0); SELECT * FROM T WHERE b < 2.0 ORDER BY b; SELECT GROUP_CONCAT(b, '|') FROM T; SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; DELETE FROM T WHERE a > (SELECT AVG(a) FROM T); ALTER TABLE T DROP COLUMN a; INSERT OR FAIL INTO T VALUES (-6, 'x'); ALTER TABLE T ADD COLUMN extra_3199 FLOA COLLATE NOCASE; END TRANSACTION; INSERT INTO T SELECT * FROM T; ALTER TABLE T DROP COLUMN b; ``` ## Actual output ```sql ATOMIC_INTRINSICS=1 COMPILER=gcc-14.2.0 DEFAULT_AUTOVACUUM DEFAULT_CACHE_SIZE=-2000 DEFAULT_FILE_FORMAT=4 DEFAULT_JOURNAL_SIZE_LIMIT=-1 DEFAULT_MMAP_SIZE=0 DEFAULT_PAGE_SIZE=4096 DEFAULT_PCACHE_INITSZ=20 DEFAULT_RECURSIVE_TRIGGERS DEFAULT_SECTOR_SIZE=4096 DEFAULT_SYNCHRONOUS=2 DEFAULT_WAL_AUTOCHECKPOINT=1000 DEFAULT_WAL_SYNCHRONOUS=2 DEFAULT_WORKER_THREADS=0 ENABLE_BYTECODE_VTAB ENABLE_DBPAGE_VTAB ENABLE_DBSTAT_VTAB ENABLE_EXPLAIN_COMMENTS ENABLE_FTS3 ENABLE_FTS4 ENABLE_MATH_FUNCTIONS ENABLE_OFFSET_SQL_FUNC ENABLE_RTREE ENABLE_STMTVTAB ENABLE_UNKNOWN_SQL_FUNCTION HAVE_ISNAN MALLOC_SOFT_LIMIT=1024 MAX_ATTACHED=10 MAX_COLUMN=2000 MAX_COMPOUND_SELECT=500 MAX_DEFAULT_PAGE_SIZE=8192 MAX_EXPR_DEPTH=1000 MAX_FUNCTION_ARG=127 MAX_LENGTH=1000000000 MAX_LIKE_PATTERN_LENGTH=50000 MAX_MMAP_SIZE=0x7fff0000 MAX_PAGE_COUNT=1073741823 MAX_PAGE_SIZE=65536 MAX_SQL_LENGTH=1000000000 MAX_TRIGGER_DEPTH=1000 MAX_VARIABLE_NUMBER=32766 MAX_VDBE_OP=250000000 MAX_WORKER_THREADS=8 MUTEX_PTHREADS SYSTEM_MALLOC TEMP_STORE=1 THREADSAFE=1 3|-Inf|30.0 2|-2.5|20.0 |0.0| 0.0|-2.5|-Inf |0.0|||0.0| 2|-2.5|20.0|2|-2.5|20.0 3|-Inf|30.0|3|-Inf|30.0 ``` ## Expectation ```sql ATOMIC_INTRINSICS=1 COMPILER=gcc-11.4.0 DEFAULT_AUTOVACUUM DEFAULT_CACHE_SIZE=-2000 DEFAULT_FILE_FORMAT=4 DEFAULT_JOURNAL_SIZE_LIMIT=-1 DEFAULT_MMAP_SIZE=0 DEFAULT_PAGE_SIZE=4096 DEFAULT_PCACHE_INITSZ=20 DEFAULT_RECURSIVE_TRIGGERS DEFAULT_SECTOR_SIZE=4096 DEFAULT_SYNCHRONOUS=2 DEFAULT_WAL_AUTOCHECKPOINT=1000 DEFAULT_WAL_SYNCHRONOUS=2 DEFAULT_WORKER_THREADS=0 DIRECT_OVERFLOW_READ DQS=0 ENABLE_BYTECODE_VTAB ENABLE_DBPAGE_VTAB ENABLE_DBSTAT_VTAB ENABLE_EXPLAIN_COMMENTS ENABLE_FTS3 ENABLE_FTS4 ENABLE_MATH_FUNCTIONS ENABLE_OFFSET_SQL_FUNC ENABLE_PERCENTILE ENABLE_RTREE ENABLE_STMTVTAB ENABLE_UNKNOWN_SQL_FUNCTION HAVE_ISNAN MALLOC_SOFT_LIMIT=1024 MAX_ATTACHED=10 MAX_COLUMN=2000 MAX_COMPOUND_SELECT=500 MAX_DEFAULT_PAGE_SIZE=8192 MAX_EXPR_DEPTH=1000 MAX_FUNCTION_ARG=1000 MAX_LENGTH=1000000000 MAX_LIKE_PATTERN_LENGTH=50000 MAX_MMAP_SIZE=0x7fff0000 MAX_PAGE_COUNT=0xfffffffe MAX_PAGE_SIZE=65536 MAX_SQL_LENGTH=1000000000 MAX_TRIGGER_DEPTH=1000 MAX_VARIABLE_NUMBER=32766 MAX_VDBE_OP=250000000 MAX_WORKER_THREADS=8 MUTEX_PTHREADS SYSTEM_MALLOC TEMP_STORE=1 THREADSAFE=1 3|-Inf|30.0 2|-2.5|20.0 |0.0| 0.0|-2.5|-Inf |0.0|||0.0| 2|-2.5|20.0|2|-2.5|20.0 3|-Inf|30.0|3|-Inf|30.0 ``` ## Flag ``` ```