Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add a test case for the assert() fix in the previous commit. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
32fba11ab72f6300391267eaad64e92f |
| User & Date: | dan 2019-10-07 13:46:43 |
Context
|
2019-10-07
| ||
| 18:43 | Fix a problem with running ALTER TABLE ADD COLUMN statements within a transaction that writes to one or more virtual tables. Fix for [8fe768e9]. check-in: 31e85fbb user: dan tags: trunk | |
| 13:46 | Add a test case for the assert() fix in the previous commit. check-in: 32fba11a user: dan tags: trunk | |
| 13:26 | Fix a faulty assert() statement in the sqlite3VdbeMemExpandBlob() routine. check-in: 69a26ead user: drh tags: trunk | |
Changes
Changes to test/corruptL.test.
1066 1067 1068 1069 1070 1071 1072 1073 1074 |
| end x.db
}]} {}
do_catchsql_test 11.1 {
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking
DELETE FROM t3 WHERE x IN (SELECT x FROM t4);
} {1 {database disk image is malformed}}
finish_test
|
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 |
| end x.db
}]} {}
do_catchsql_test 11.1 {
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking
DELETE FROM t3 WHERE x IN (SELECT x FROM t4);
} {1 {database disk image is malformed}}
#-------------------------------------------------------------------------
reset_db
do_test 12.0 {
sqlite3 db {}
db deserialize [decode_hexdb {
| size 12288 pagesize 4096 filename crash-e6d070858a3a85.db
| page 1 offset 0
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3.
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 00 .....@ ........
| 96: 00 00 00 00 0d 00 00 00 02 0f 8f 00 0f bf 0f 8f ................
| 3968: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 2e ................
| 3984: 02 06 17 15 11 01 45 69 6e 64 65 78 74 31 63 62 ......Eindext1cb
| 4000: 74 31 03 43 52 45 41 54 45 20 49 4e 44 45 58 20 t1.CREATE INDEX
| 4016: 74 31 63 62 20 4f 4e 20 74 31 28 63 2c 62 29 3f t1cb ON t1(c,b)?
| 4032: 01 06 17 11 11 01 6b 74 61 62 6c 65 74 31 74 31 ......ktablet1t1
| 4048: 02 43 52 45 41 54 45 20 54 41 42 4c 45 20 74 31 .CREATE TABLE t1
| 4064: 28 61 20 49 4e 54 2c 20 62 20 49 4e 54 2c 20 43 (a INT, b INT, C
| 4080: 20 49 4e 54 20 44 45 46 41 55 4c 54 20 31 36 29 INT DEFAULT 16)
| page 2 offset 4096
| 0: 0d 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
| 4000: 00 00 00 00 00 00 00 00 07 0b 04 01 01 01 63 63 ..............cc
| 4016: 11 05 0a 04 00 00 01 11 05 09 04 08 08 01 0f 05 ................
| 4032: 08 04 00 00 01 01 56 07 04 01 08 01 07 10 07 06 ......V.........
| 4048: 14 01 01 01 06 08 10 06 05 04 f5 00 01 05 10 07 ................
| 4064: 04 04 01 01 01 04 03 10 06 03 04 01 09 01 03 10 ................
| 4080: 06 02 04 01 00 01 02 10 06 01 04 09 01 01 02 10 ................
| page 3 offset 8192
| 0: 0a 00 00 00 0b 0f b0 00 0f f9 0f f2 0f eb 0f e4 ................
| 16: 0f dd 0f d6 0f 9f 0f c7 0f be 00 00 00 00 00 00 ................
| 4016: 07 04 01 01 01 11 e2 0b 06 04 91 00 01 11 0a 07 ................
| 4032: 04 01 01 01 10 08 06 07 04 01 01 01 10 04 04 06 ................
| 4048: 04 01 01 09 10 02 06 04 01 0a 01 10 00 00 00 00 ................
| end crash-e6d070858a3a85.db
}]} {}
do_catchsql_test 12.1 {
SELECT CAST((SELECT b FROM t1 WHERE 16=c) AS int) FROM t1 WHERE 16=c;
} {1 {database disk image is malformed}}
finish_test
|