ast-project/part1/results/2/bug_34672ec8-e1ed-4170-bf81-b5dc28512522_logic.md

Summary

**No review yet**

Minimized query

PRAGMA vdbe_debug = FALSE;
PRAGMA query_only = OFF;
PRAGMA user_version = 999;
.recover
CREATE TABLE t1(a);
INSERT INTO t1 VALUES(1);
ALTER TABLE t1 ADD COLUMN b TEXT DEFAULT -123.0;
SELECT b, typeof(b) FROM t1;
ALTER TABLE t1 ADD COLUMN c TEXT DEFAULT -123.5;
ALTER TABLE t1 ADD COLUMN d TEXT DEFAULT 'hello';
SELECT c, typeof(c) FROM t1;

ALTER TABLE t1 DROP COLUMN a;

SELECT COUNT(*) FROM t1;

Actual output

PRAGMA foreign_keys=OFF;
BEGIN;
PRAGMA writable_schema = on;
PRAGMA writable_schema = off;
COMMIT;
-123.0|text
-123.5|text
1

Expectation

.dbconfig defensive off
BEGIN;
PRAGMA writable_schema = on;
PRAGMA foreign_keys = off;
PRAGMA encoding = 'UTF-8';
PRAGMA page_size = '4096';
PRAGMA auto_vacuum = '0';
PRAGMA user_version = '999';
PRAGMA application_id = '0';
PRAGMA writable_schema = off;
COMMIT;
-123.0|text
-123.5|text
1

Flag