| 1 |
# 2019-01-11 |
| 2 |
# |
| 3 |
# The author disclaims copyright to this source code. In place of |
| 4 |
# a legal notice, here is a blessing: |
| 5 |
# |
| 6 |
# May you do good and not evil. |
| 7 |
# May you find forgiveness for yourself and forgive others. |
| 8 |
# May you share freely, never taking more than you give. |
| 9 |
# |
| 10 |
#*********************************************************************** |
| 11 |
# |
| 12 |
|
| 13 |
set testdir [file dirname $argv0] |
| 14 |
source $testdir/tester.tcl |
| 15 |
set testprefix corruptL |
| 16 |
|
| 17 |
database_may_be_corrupt |
| 18 |
|
| 19 |
#------------------------------------------------------------------------- |
| 20 |
reset_db |
| 21 |
do_test 1.0 { |
| 22 |
sqlite3 db {} |
| 23 |
db deserialize [decode_hexdb { |
| 24 |
| size 356352 pagesize 4096 filename crash-acaae0347204ae.db |
| 25 |
| page 1 offset 0 |
| 26 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 27 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 d0 00 00 00 .....@ ........ |
| 28 |
| 32: 40 00 ea 00 00 00 00 00 00 40 00 00 00 40 00 00 @........@...@.. |
| 29 |
| 96: 00 00 00 00 0d 00 00 00 04 0e 9c 00 0f ad 0f 4f ...............O |
| 30 |
| 112: 0e fc 0e 9c 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 31 |
| 3728: 00 00 00 00 00 00 00 00 00 00 00 00 5e 04 07 17 ............^... |
| 32 |
| 3744: 1f 1f 01 81 0b 74 61 62 6c 65 74 31 5f 70 61 72 .....tablet1_par |
| 33 |
| 3760: 65 6e 74 74 31 5f 70 61 72 65 6e 74 04 43 52 45 entt1_parent.CRE |
| 34 |
| 3776: 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 70 61 ATE TABLE .t1_pa |
| 35 |
| 3792: 72 65 6e 74 22 28 6e 6f 64 65 6e 6f 20 49 4e 54 rent.(nodeno INT |
| 36 |
| 3808: 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 EGER PRIMARY KEY |
| 37 |
| 3824: 2c 70 61 72 65 6e 74 6e 6f 64 65 29 51 03 06 17 ,parentnode)Q... |
| 38 |
| 3840: 1b 1b 01 7b 74 61 62 6c 65 74 31 5f 6e 6f 64 65 ....tablet1_node |
| 39 |
| 3856: 74 31 5f 6e 6f 64 65 03 43 52 45 41 54 45 20 54 t1_node.CREATE T |
| 40 |
| 3872: 41 42 4c 45 20 22 74 31 5f 6e 6f 64 65 22 28 6e ABLE .t1_node.(n |
| 41 |
| 3888: 6f 64 65 6e 6f 20 49 4e 54 45 47 45 52 20 50 52 odeno INTEGER PR |
| 42 |
| 3904: 49 4d 41 52 59 20 4b 45 59 2c 64 61 74 61 29 5c IMARY KEY,data). |
| 43 |
| 3920: 02 07 17 1d 1d 01 81 0b 74 61 62 6c 65 74 31 5f ........tablet1_ |
| 44 |
| 3936: 72 6f 77 69 64 74 31 5f 72 6f 77 69 64 02 43 52 rowidt1_rowid.CR |
| 45 |
| 3952: 45 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 72 EATE TABLE .t1_r |
| 46 |
| 3968: 6f 77 69 64 22 28 72 6f 77 69 64 20 49 4e 54 45 owid.(rowid INTE |
| 47 |
| 3984: 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c GER PRIMARY KEY, |
| 48 |
| 4000: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 29 51 01 07 nodeno,a0,a1)Q.. |
| 49 |
| 4016: 17 11 11 08 81 0f 74 61 62 6c 65 74 31 74 31 43 ......tablet1t1C |
| 50 |
| 4032: 52 45 41 54 45 20 56 49 52 54 55 41 4c 20 54 41 REATE VIRTUAL TA |
| 51 |
| 4048: 42 4c 45 20 74 31 20 55 53 49 4e 47 20 72 74 72 BLE t1 USING rtr |
| 52 |
| 4064: 65 65 28 69 64 2c 78 30 20 50 52 49 4d 41 52 59 ee(id,x0 PRIMARY |
| 53 |
| 4080: 20 4b 45 59 2c 70 61 72 65 6e 74 6e 6f 64 65 29 KEY,parentnode) |
| 54 |
| page 2 offset 4096 |
| 55 |
| 0: 51 03 06 17 1b 1b 01 7b 74 61 62 6c 65 74 31 5f Q.......tablet1_ |
| 56 |
| 16: 6e 6f 64 65 74 31 5f 6e 6f 64 65 03 43 52 45 41 nodet1_node.CREA |
| 57 |
| 32: 54 45 20 54 41 42 4c 45 20 22 74 31 5f 6e 6f 64 TE TABLE .t1_nod |
| 58 |
| 48: 65 22 28 6e 6f 64 65 6e 6f 20 49 4e 54 45 47 45 e.(nodeno INTEGE |
| 59 |
| 64: 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c 64 61 R PRIMARY KEY,da |
| 60 |
| 80: 74 61 29 5c 02 07 17 1d 1d 01 81 0b 74 61 62 6c ta).........tabl |
| 61 |
| 96: 65 74 31 5f 72 6f 77 69 64 74 31 5f 72 6f 77 69 et1_rowidt1_rowi |
| 62 |
| 112: 64 02 43 52 45 41 54 45 20 54 41 42 4c 45 00 00 d.CREATE TABLE.. |
| 63 |
| 128: 01 0a 02 00 00 00 01 0e 0d 00 00 00 00 24 0e 0d .............$.. |
| 64 |
| 144: 0c 1a 06 85 50 46 60 27 70 08 00 00 00 00 00 00 ....PF`'p....... |
| 65 |
| 3824: 00 00 00 00 00 00 00 0d 0e 05 00 09 1d 00 74 6f ..............to |
| 66 |
| 3840: 79 20 68 61 6c 66 10 0d 05 00 09 23 00 62 6f 74 y half.....#.bot |
| 67 |
| 3856: 74 6f 6d 20 68 61 6c 66 0f 0c 05 00 09 21 00 72 tom half.....!.r |
| 68 |
| 3872: 69 67 68 74 20 68 61 6c 66 0e 0b 05 00 09 1f 00 ight half....... |
| 69 |
| 3888: 6c 65 66 74 20 43 15 f6 e6 f6 46 50 34 35 24 54 left C....FP45$T |
| 70 |
| 3904: 15 44 52 05 44 14 24 c4 52 02 27 43 15 f6 e6 f6 .DR.D.$.R.'C.... |
| 71 |
| 3920: 46 52 22 8e 6f 64 65 6e 6f 20 49 4e 54 45 47 45 FR..odeno INTEGE |
| 72 |
| 3936: 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c 64 61 R PRIMARY KEY,da |
| 73 |
| 3952: 74 61 29 5c 02 07 17 1d 1d 01 81 0b 74 61 62 6c ta).........tabl |
| 74 |
| 3968: 65 74 31 5f 72 6f 74 74 6f 6d 20 65 64 67 65 0f et1_rottom edge. |
| 75 |
| 3984: 07 05 00 09 21 00 72 69 67 68 74 20 65 64 67 65 ....!.right edge |
| 76 |
| 4000: 0e 06 05 00 09 1f 00 6c 65 66 74 20 65 64 67 65 .......left edge |
| 77 |
| 4016: 0b 05 05 00 09 19 00 63 65 6e 74 65 72 17 04 05 .......center... |
| 78 |
| 4032: 00 09 31 00 75 70 70 65 72 2d 72 69 67 68 74 20 ..1.upper-right |
| 79 |
| 4048: 63 6f 72 6e 65 72 17 03 05 00 09 31 00 6c 6f 77 corner.....1.low |
| 80 |
| 4064: 65 72 2d 72 69 67 68 74 20 63 6f 72 6e 65 72 16 er-right corner. |
| 81 |
| 4080: 02 05 00 09 2f 00 75 70 70 65 72 2d 6c 65 66 74 ..../.upper-left |
| 82 |
| page 3 offset 8192 |
| 83 |
| 0: 20 63 6f 72 6e 65 72 16 01 05 00 09 2f 01 8c 6f corner...../..o |
| 84 |
| 16: 77 65 72 2d 6c 53 51 4c 69 74 65 20 66 6f 72 6d wer-lSQLite form |
| 85 |
| 32: 61 74 20 33 00 10 00 01 01 00 40 20 20 00 00 00 at 3......@ ... |
| 86 |
| 48: 00 00 00 00 2f 00 00 0d eb 13 00 00 00 03 00 00 ..../........... |
| 87 |
| 64: 00 04 00 00 00 00 00 00 00 06 00 00 00 01 00 00 ................ |
| 88 |
| 80: 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 00 ................ |
| 89 |
| page 6 offset 20480 |
| 90 |
| 128: 00 00 00 00 00 00 00 00 97 3d 04 ae 7c 01 00 00 .........=..|... |
| 91 |
| 624: 00 00 00 00 00 00 21 97 3d 04 ae 7c 01 00 00 00 ......!.=..|.... |
| 92 |
| 1120: 00 00 00 00 00 20 97 3d 04 ae 7c 01 00 00 00 00 ..... .=..|..... |
| 93 |
| 1616: 00 00 00 00 1f 97 3d 04 ae 7c 01 00 00 00 00 00 ......=..|...... |
| 94 |
| 2112: 00 00 00 1e 97 3d 04 ae 7c 01 00 00 00 00 00 00 .....=..|....... |
| 95 |
| 2608: 00 00 1d 97 d3 d0 4a e7 c0 00 00 00 00 00 00 00 ......J......... |
| 96 |
| 3088: 00 00 00 00 00 00 00 00 00 00 00 00 01 f3 00 00 ................ |
| 97 |
| 3600: 23 97 3d 04 ae 7c 01 00 00 00 00 00 00 00 00 00 #.=..|.......... |
| 98 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 26 ...............& |
| 99 |
| page 8 offset 28672 |
| 100 |
| 0: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 101 |
| 1072: 97 4d 1e 14 00 ae 7c 00 00 00 00 00 00 00 00 00 .M....|......... |
| 102 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 103 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 03 ................ |
| 104 |
| page 10 offset 36864 |
| 105 |
| 0: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 106 |
| 1072: 9a ee c1 80 fd 78 1f ce 1b ae eb b4 00 00 00 00 .....x.......... |
| 107 |
| 1088: 13 20 ff 20 00 70 00 00 00 60 50 00 00 00 11 e0 . . .p...`P..... |
| 108 |
| 1104: 00 00 00 70 00 00 00 60 50 05 35 14 c6 97 46 52 ...p...`P.5...FR |
| 109 |
| 1120: 06 66 f7 26 d6 17 42 03 30 01 00 00 10 10 04 02 .f.&..B.0....... |
| 110 |
| 1136: 02 00 00 00 00 00 00 00 00 40 00 00 00 00 00 00 .........@...... |
| 111 |
| 1152: 00 00 00 00 00 40 00 00 00 40 00 00 00 00 00 00 .....@...@...... |
| 112 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 05 ................ |
| 113 |
| page 12 offset 45056 |
| 114 |
| 0: 0d 00 00 00 01 04 30 00 04 30 e1 b4 30 97 4d 46 ......0..0..0.MF |
| 115 |
| 16: 14 00 ae 7c 00 00 00 00 00 00 00 03 00 00 43 00 ...|..........C. |
| 116 |
| page 47 offset 188416 |
| 117 |
| 2512: 00 00 00 00 00 00 00 00 be 00 00 00 00 00 00 00 ................ |
| 118 |
| page 87 offset 352256 |
| 119 |
| 2512: 00 00 00 00 00 00 00 00 aa 00 00 00 00 00 00 00 ................ |
| 120 |
| end crash-acaae0347204ae.db |
| 121 |
}]} {} |
| 122 |
|
| 123 |
do_catchsql_test 1.1 { |
| 124 |
PRAGMA cell_size_check = off; |
| 125 |
DROP INDEX t1x1; |
| 126 |
} {1 {database disk image is malformed}} |
| 127 |
|
| 128 |
do_catchsql_test 1.2 { |
| 129 |
SELECT sum(s+length(b)) FROM t1 WHERE a IN (110,10,150) AND q IS NULL; |
| 130 |
} {1 {database disk image is malformed}} |
| 131 |
|
| 132 |
do_catchsql_test 1.3 { |
| 133 |
REINDEX t1; |
| 134 |
} {1 {database disk image is malformed}} |
| 135 |
|
| 136 |
do_catchsql_test 1.4 { |
| 137 |
PRAGMA integrity_check |
| 138 |
} {1 {database disk image is malformed}} |
| 139 |
|
| 140 |
|
| 141 |
#------------------------------------------------------------------------- |
| 142 |
reset_db |
| 143 |
do_test 2.0 { |
| 144 |
sqlite3 db {} |
| 145 |
db deserialize [decode_hexdb { |
| 146 |
| size 20480 pagesize 4096 filename crash.txt.db |
| 147 |
| page 1 offset 0 |
| 148 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 149 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 05 .....@ ........ |
| 150 |
| 32: 00 00 00 00 00 00 00 00 00 00 00 05 00 00 00 04 ................ |
| 151 |
| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ |
| 152 |
| 96: 00 00 00 00 0d 00 00 00 05 0e 55 00 0f 74 0f 3c ..........U..t.< |
| 153 |
| 112: 0e f9 0e d1 0e 55 00 00 00 00 00 00 00 00 00 00 .....U.......... |
| 154 |
| 3664: 00 00 00 00 00 7a 05 07 15 11 11 08 81 63 76 69 .....z.......cvi |
| 155 |
| 3680: 65 77 76 31 76 31 43 52 45 41 54 45 20 56 49 45 ewv1v1CREATE VIE |
| 156 |
| 3696: 57 20 76 31 28 78 2c 79 29 20 41 53 0a 53 45 4c W v1(x,y) AS.SEL |
| 157 |
| 3712: 45 43 54 20 74 31 2e 62 2c 74 32 2e 62 20 46 52 ECT t1.b,t2.b FR |
| 158 |
| 3728: 4f 4d 20 74 31 2c 74 32 20 57 48 45 52 45 20 74 OM t1,t2 WHERE t |
| 159 |
| 3744: 31 2e 61 3d 74 32 2e 61 20 47 52 4f 55 50 20 42 1.a=t2.a GROUP B |
| 160 |
| 3760: 59 20 31 20 48 41 56 49 4e 47 20 74 32 2e 63 20 Y 1 HAVING t2.c |
| 161 |
| 3776: 4e 4f 54 20 4e 55 4c 4c 0a 4c 49 4d 49 54 20 31 NOT NULL.LIMIT 1 |
| 162 |
| 3792: 30 26 04 06 17 11 11 01 39 74 61 62 6c 65 74 32 0&......9tablet2 |
| 163 |
| 3808: 74 32 05 43 52 45 41 54 45 20 54 41 42 4c 45 20 t2.CREATE TABLE |
| 164 |
| 3824: 74 32 28 61 2c 62 2c 63 29 41 03 06 17 15 11 01 t2(a,b,c)A...... |
| 165 |
| 3840: 6b 69 6e 64 65 78 74 31 78 31 74 31 04 43 52 45 kindext1x1t1.CRE |
| 166 |
| 3856: 41 54 45 20 49 4e 44 45 58 20 73 31 78 31 20 4f ATE INDEX s1x1 O |
| 167 |
| 3872: 4e 20 74 31 28 64 29 20 57 48 45 52 45 20 65 65 N t1(d) WHERE ee |
| 168 |
| 3888: 20 49 53 20 4e 4f 54 20 4e 55 4c 4c 36 02 06 17 IS NOT NULL6... |
| 169 |
| 3904: 17 11 01 53 69 6e 64 65 78 74 31 61 62 63 74 31 ...Sindext1abct1 |
| 170 |
| 3920: 03 43 52 45 41 54 45 20 49 4e 44 45 58 20 74 31 .CREATE INDEX t1 |
| 171 |
| 3936: 61 62 63 20 4f 4e 20 74 31 28 61 2c 62 2c 63 2b abc ON t1(a,b,c+ |
| 172 |
| 3952: 64 2b 65 29 81 09 01 07 17 11 11 01 81 7d 74 61 d+e)..........ta |
| 173 |
| 3968: 62 6c 65 74 31 74 31 02 43 52 45 41 54 45 20 54 blet1t1.CREATE T |
| 174 |
| 3984: 41 42 4c 45 20 74 31 28 61 2c 62 2c 63 2c 64 2c ABLE t1(a,b,c,d, |
| 175 |
| 4000: 65 2c 66 2c 67 2c 68 2c 6a 2c 6a 6a 2c 6a 6a 6a e,f,g,h,j,jj,jjj |
| 176 |
| 4016: 2c 6b 2c 61 61 2c 62 62 2c 63 63 2c 64 64 2c 65 ,k,aa,bb,cc,dd,e |
| 177 |
| 4032: 65 20 44 45 46 41 55 4c 54 20 33 2e 31 34 2c 0a e DEFAULT 3.14,. |
| 178 |
| 4048: 66 66 20 44 45 46 41 55 4c 54 28 27 68 69 63 63 ff DEFAULT('hicc |
| 179 |
| 4064: 75 70 27 29 2c 67 67 20 4e 4f 54 20 4e 55 4c 4c up'),gg NOT NULL |
| 180 |
| 4080: 20 44 45 46 41 55 4c 54 28 66 61 6c 73 65 29 29 DEFAULT(false)) |
| 181 |
| page 2 offset 4096 |
| 182 |
| 0: 0d 00 00 00 0a 0e 7b 00 0f dc 0f b6 0f 8f 0f 68 ...............h |
| 183 |
| 16: 0f 41 0f 1a 0e f3 0e cb 0e a3 0e 7b 00 00 00 00 .A.............. |
| 184 |
| 3696: 00 00 00 00 00 00 00 00 00 00 00 26 0a 14 01 01 ...........&.... |
| 185 |
| 3712: 02 08 00 00 00 00 00 00 00 00 00 00 00 00 07 19 ................ |
| 186 |
| 3728: 08 09 5a 00 b4 40 09 1e b8 51 eb 85 1f 68 69 63 [email protected] |
| 187 |
| 3744: 63 75 70 26 09 14 01 01 02 08 00 00 00 00 00 00 cup&............ |
| 188 |
| 3760: 00 00 00 00 00 00 07 19 08 08 50 00 a0 40 09 1e ..........P..@.. |
| 189 |
| 3776: b8 51 eb 85 1f 68 69 63 63 75 70 26 08 14 01 01 .Q...hiccup&.... |
| 190 |
| 3792: 02 08 00 00 00 00 00 00 00 00 00 00 00 00 07 19 ................ |
| 191 |
| 3808: 08 07 46 00 8c 40 09 1e b8 51 eb 85 1f 68 69 63 [email protected] |
| 192 |
| 3824: 63 75 70 25 07 14 01 01 01 08 00 00 00 00 00 00 cup%............ |
| 193 |
| 3840: 00 00 00 00 00 00 07 b9 08 06 3c 78 40 09 1e b8 ..........<x@... |
| 194 |
| 3856: 51 eb 85 1f 68 69 63 63 75 70 25 06 14 01 00 01 Q...hiccup%..... |
| 195 |
| 3872: 08 00 00 00 00 00 00 00 00 00 00 00 00 07 19 08 ................ |
| 196 |
| 3888: 05 32 64 40 09 1e b8 51 eb 85 1f 68 69 63 63 75 [email protected] |
| 197 |
| 3904: 70 25 05 14 01 01 01 08 00 00 00 00 00 00 00 00 p%.............. |
| 198 |
| 3920: 00 00 00 00 07 19 08 04 28 50 40 09 1e b8 51 eb ........([email protected]. |
| 199 |
| 3936: 85 1f 68 69 63 63 75 70 25 04 14 01 01 01 08 00 ..hiccup%....... |
| 200 |
| 3952: 00 00 00 00 00 00 00 00 00 00 00 07 19 08 03 1e ................ |
| 201 |
| 3968: 3c 40 09 1e b8 51 eb 85 1f 68 69 63 63 75 70 25 <@...Q...hiccup% |
| 202 |
| 3984: 03 14 01 01 01 08 00 00 00 00 00 00 00 00 00 00 ................ |
| 203 |
| 4000: 00 00 07 19 08 02 14 28 40 09 1e b8 51 eb 85 1f .......(@...Q... |
| 204 |
| 4016: 68 69 63 63 75 70 24 02 14 09 01 01 08 00 00 00 hiccup$......... |
| 205 |
| 4032: 00 00 00 00 00 00 00 00 00 07 19 08 0a 14 40 09 ..............@. |
| 206 |
| 4048: 1e b8 51 eb 85 1f 68 69 63 63 75 70 22 01 14 08 ..Q...hiccup.... |
| 207 |
| 4064: 08 08 07 ff ff ff ff ff ff 00 00 00 00 00 00 07 ................ |
| 208 |
| 4080: 19 08 40 09 1e b8 51 eb 85 1f 68 69 63 63 75 70 [email protected] |
| 209 |
| page 3 offset 8192 |
| 210 |
| 0: 0a 00 00 00 0a 0f aa 00 0f fa 0f f2 0f e9 0f e0 ................ |
| 211 |
| 16: 0f d7 0f ce 0f c5 0f bc 0e b3 0f aa 00 00 00 00 ................ |
| 212 |
| 4000: 00 00 00 00 00 00 00 00 00 00 08 05 01 01 00 01 ................ |
| 213 |
| 4016: 09 5a 0a 08 05 01 01 00 01 08 50 09 08 05 01 01 .Z........P..... |
| 214 |
| 4032: 00 01 07 46 08 08 05 01 01 00 01 06 3c 07 08 05 ...F........<... |
| 215 |
| 4048: 01 01 00 01 05 32 06 08 05 01 01 00 01 04 28 05 .....2........(. |
| 216 |
| 4064: 08 05 01 01 00 01 03 1e 04 08 05 01 01 00 01 02 ................ |
| 217 |
| 4080: 14 03 07 05 09 01 00 01 0a 02 05 05 08 08 00 09 ................ |
| 218 |
| page 4 offset 12288 |
| 219 |
| 0: 0a 00 00 00 0a 0f cf 00 0f fc 0f f7 0f f2 0f ed ................ |
| 220 |
| 16: 0f e8 0f e3 0f de 0f d9 0f d4 0f cf 00 00 00 00 ................ |
| 221 |
| 4032: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 04 ................ |
| 222 |
| 4048: 03 08 01 0a 04 03 08 01 09 04 03 08 01 08 04 03 ................ |
| 223 |
| 4064: 08 01 07 04 03 08 01 06 04 03 08 01 05 04 03 08 ................ |
| 224 |
| 4080: 01 04 04 03 08 01 13 04 03 08 01 02 03 03 08 09 ................ |
| 225 |
| page 5 offset 16384 |
| 226 |
| 0: 0d 00 00 00 00 10 00 00 00 00 00 00 00 00 00 00 ................ |
| 227 |
| end crash.txt.db |
| 228 |
}]} {} |
| 229 |
|
| 230 |
do_execsql_test 2.1 { |
| 231 |
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking |
| 232 |
INSERT INTO t1(b) VALUES(X'a0fee3669f9fddefc5cba913e4225d4b6ce2b04f26b87fad3ee6f9b7d90a1ea62a169bf41e5d32707a6ca5c3d05e4bde05c9d89eaaa8c50e74333d2e9fcd7dfe95528a3a016aac1102d825c5cd70cf99d8a88e0ea7f798d4334386518b7ad359beb168b93aba059a2a3bd93112d65b44c12b9904ea786b204d80531cdf0504bf9b203dbe927061974caf7b9f30cbc3397b61f802e732012a6663d41c3607d6f1c0dbcfd489adac05ca500c0b04439d894cd93a840159225ef73b627e178b9f84b3ffe66cf22a963a8368813ff7961fc47f573211ccec95e0220dcbb3bf429f4a50ba54d7a53784ac51bfef346e6ac8ae0d0e7c3175946e62ba2b'); |
| 233 |
} |
| 234 |
|
| 235 |
do_catchsql_test 2.2 { |
| 236 |
SELECT b,c FROM t1 ORDER BY a; |
| 237 |
} {1 {out of memory}} |
| 238 |
|
| 239 |
#------------------------------------------------------------------------- |
| 240 |
reset_db |
| 241 |
do_execsql_test 3.0 { |
| 242 |
CREATE TABLE t1(a, b, c, d INTEGER PRIMARY KEY); |
| 243 |
CREATE TABLE t2(a, b, c, d INTEGER PRIMARY KEY); |
| 244 |
|
| 245 |
INSERT INTO t1(a, b, c, d) VALUES (1, 2, 3, 100), (4, 5, 6, 101); |
| 246 |
INSERT INTO t2(a, b, c, d) VALUES (1, 100, 3, 1000), (4, 101, 6, 1001); |
| 247 |
|
| 248 |
CREATE INDEX t1a ON t1(a); |
| 249 |
CREATE INDEX t2a ON t2(a, b, c); |
| 250 |
|
| 251 |
PRAGMA writable_schema = 1; |
| 252 |
UPDATE sqlite_master SET sql = 'CREATE INDEX t2a ON t2(a)' WHERE name='t2a'; |
| 253 |
} |
| 254 |
|
| 255 |
db close |
| 256 |
sqlite3 db test.db |
| 257 |
|
| 258 |
do_catchsql_test 3.1 { |
| 259 |
INSERT INTO t1 SELECT * FROM t2; |
| 260 |
} {1 {database disk image is malformed}} |
| 261 |
|
| 262 |
#------------------------------------------------------------------------- |
| 263 |
reset_db |
| 264 |
do_test 4.0 { |
| 265 |
sqlite3 db {} |
| 266 |
db deserialize [decode_hexdb { |
| 267 |
| size 4096 pagesize 512 filename crash-6b48ba69806134.db |
| 268 |
| page 1 offset 0 |
| 269 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 270 |
| 16: 02 00 01 01 00 40 20 20 00 ff ff ff ff 00 00 07 .....@ ........ |
| 271 |
| 32: 00 00 00 00 00 00 00 00 00 00 00 08 00 00 00 04 ................ |
| 272 |
| 48: 00 00 00 00 00 00 00 05 00 eb 00 01 00 00 00 00 ................ |
| 273 |
| 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0c ................ |
| 274 |
| 96: 00 2e 2c 50 0d 00 00 00 06 01 06 00 01 da 01 b0 ..,P............ |
| 275 |
| 112: 05 56 01 86 01 2a 01 06 00 00 00 00 00 00 00 00 .V...*.......... |
| 276 |
| 128: 00 ff 00 00 ff ff ff e1 00 00 00 00 00 00 00 00 ................ |
| 277 |
| 144: 00 00 00 00 00 00 00 00 00 01 00 00 00 00 00 00 ................ |
| 278 |
| 160: 00 00 00 00 00 00 00 00 f2 00 00 00 00 00 00 00 ................ |
| 279 |
| 176: 00 00 f9 ff ff ff ff ff ff ff 00 00 00 00 00 fb ................ |
| 280 |
| 208: 00 00 00 00 00 00 00 00 1e 00 00 00 fe 00 00 00 ................ |
| 281 |
| 224: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ca 00 ................ |
| 282 |
| 256: 00 00 00 00 ef ff 22 07 06 17 11 11 01 31 74 61 .............1ta |
| 283 |
| 272: 62 6c 65 74 38 38 74 04 43 52 45 41 54 45 20 54 blet88t.CREATE T |
| 284 |
| 288: 41 42 4c 45 20 74 34 28 87 29 2a 06 06 17 13 11 ABLE t4(.)*..... |
| 285 |
| 304: 01 3f 69 4f 64 65 78 74 33 78 74 33 05 43 52 45 .?iOdext3xt3.CRE |
| 286 |
| 320: 41 54 45 20 49 6e 44 45 58 20 74 33 78 20 4f 4e ATE InDEX t3x ON |
| 287 |
| 336: 20 74 33 28 78 29 2e 04 06 17 15 11 01 45 69 6e t3(x).......Ein |
| 288 |
| 352: 64 65 2e 74 32 63 64 74 3d 05 43 52 45 41 54 45 de.t2cdt=.CREATE |
| 289 |
| 368: 20 49 4e 44 45 58 20 74 32 63 64 20 4f 4e 20 74 INDEX t2cd ON t |
| 290 |
| 384: 32 28 0a 0c 44 29 28 05 06 17 11 11 01 3d 74 61 2(..D)(......=ta |
| 291 |
| 400: 62 6c 65 d4 33 74 33 04 43 52 45 41 54 45 20 54 ble.3t3.CREATE T |
| 292 |
| 416: 41 42 4c 45 20 74 33 28 63 2c 78 2c 65 2c 66 29 ABLE t3(c,x,e,f) |
| 293 |
| 432: 28 02 06 17 11 11 01 3d 74 61 62 6c 65 74 32 74 (......=tablet2t |
| 294 |
| 448: 32 03 43 52 45 41 54 45 20 54 41 42 4c 45 20 74 2.CREATE TABLE t |
| 295 |
| 464: 32 28 63 2c 64 2c 65 2c 66 29 24 01 06 17 11 11 2(c,d,e,f)$..... |
| 296 |
| 480: 01 35 74 60 62 6c 65 74 31 74 31 02 43 52 45 41 .5t`blet1t1.CREA |
| 297 |
| 496: 54 45 20 54 41 42 4c 45 20 74 30 28 61 2c 62 29 TE TABLE t0(a,b) |
| 298 |
| page 2 offset 512 |
| 299 |
| 0: 0d 00 ff 11 04 01 cf 00 01 fa 01 f3 01 de 01 cf ................ |
| 300 |
| 32: 00 00 08 00 00 00 00 00 00 00 00 00 00 00 00 13 ................ |
| 301 |
| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 20 00 00 ............. .. |
| 302 |
| 64: 00 00 00 00 00 00 f8 ff ff ff 00 00 00 00 00 00 ................ |
| 303 |
| 160: 01 64 00 00 00 00 00 80 ff ff ff 00 00 00 00 00 .d.............. |
| 304 |
| 176: 00 00 00 00 00 00 00 00 1f 00 00 00 00 00 00 03 ................ |
| 305 |
| 192: 00 00 40 00 00 00 00 00 00 00 00 00 00 00 00 00 ..@............. |
| 306 |
| 288: 00 00 00 00 00 00 ff ff ff e9 00 00 00 00 00 00 ................ |
| 307 |
| 336: 01 00 00 ff ff 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 308 |
| 368: 20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ............... |
| 309 |
| 384: 00 de ff 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 310 |
| 464: 00 00 00 00 00 13 76 65 6e 65 69 67 68 74 13 03 ......veneight.. |
| 311 |
| 480: 03 40 07 07 14 00 54 45 20 49 4e 44 45 58 20 74 [email protected] INDEX t |
| 312 |
| 496: 32 63 64 20 4f 4e 20 74 32 28 0a 0c 44 09 01 02 2cd ON t2(..D... |
| 313 |
| page 3 offset 1024 |
| 314 |
| 0: 0d 00 00 00 48 01 54 00 01 f7 01 ec 01 c5 01 aa ....H.T......... |
| 315 |
| 16: 30 34 28 87 29 2a 06 06 17 13 11 01 3f 69 4f 64 04(.)*......?iOd |
| 316 |
| 32: 65 79 74 33 78 74 33 6d 6d 6d 6d 6d 6d 7d 6d 6d eyt3xt3mmmmmm.mm |
| 317 |
| 48: 6d 41 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d mAmmmmmmmmmmmmmm |
| 318 |
| 64: 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 66 6d 6d 6d 6d mmmmmmmmmmmfmmmm |
| 319 |
| 80: 6d 4e 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d mNmmmmmmmmmmmmmm |
| 320 |
| 96: 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d mmmmmmmmmmmmmmmm |
| 321 |
| 112: 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d 6d mmmmmmmmmmmmmmmm |
| 322 |
| 128: 6d 6d 6d 6d 6d 00 00 00 00 00 00 00 00 00 00 00 mmmmm........... |
| 323 |
| 160: 80 00 00 00 00 00 00 03 00 00 00 ff e4 00 00 00 ................ |
| 324 |
| 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 c5 00 00 ................ |
| 325 |
| 240: 14 00 00 00 00 00 00 00 00 00 00 00 08 00 00 00 ................ |
| 326 |
| 256: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0f ec ................ |
| 327 |
| 304: 00 00 00 00 19 08 05 17 17 17 17 65 69 67 68 74 ...........eight |
| 328 |
| 320: 65 69 67 68 74 73 65 00 00 00 00 00 00 00 00 00 eightse......... |
| 329 |
| 336: 00 00 00 00 19 08 05 17 17 17 17 65 69 67 68 74 ...........eight |
| 330 |
| 352: 65 69 67 68 74 73 65 01 65 6e 00 00 00 10 25 07 eightse.en....%. |
| 331 |
| 368: 07 6e 25 07 07 07 40 18 00 00 00 00 00 00 40 18 .n%...@.......@. |
| 332 |
| 384: 00 00 00 00 00 00 40 14 00 00 00 00 00 00 40 14 ......@.......@. |
| 333 |
| 400: 00 00 00 00 00 00 09 06 05 01 01 01 01 04 04 03 ................ |
| 334 |
| 416: 03 07 05 05 01 01 09 09 02 02 19 04 05 17 17 17 ................ |
| 335 |
| 432: 17 10 65 76 65 6e 65 69 67 68 74 65 69 67 68 74 ..eveneighteight |
| 336 |
| 448: 73 65 76 65 6e 25 03 05 07 07 07 07 40 14 00 00 seven%......@... |
| 337 |
| 464: 00 00 00 00 40 18 00 00 00 00 00 00 40 18 00 00 ....@.......@... |
| 338 |
| 480: 00 00 00 00 40 14 00 00 00 00 e8 f6 09 02 00 00 ....@........... |
| 339 |
| 496: 00 00 00 00 00 00 00 00 00 00 64 00 00 00 00 02 ..........d..... |
| 340 |
| page 4 offset 1536 |
| 341 |
| 0: 0d 00 00 00 00 02 00 00 00 00 00 00 00 00 00 fa ................ |
| 342 |
| 16: 1f a1 07 00 00 00 00 00 01 00 00 00 00 00 00 00 ................ |
| 343 |
| 32: 00 00 00 00 00 00 00 00 00 00 00 00 00 73 69 6d .............sim |
| 344 |
| 48: 70 6c 65 00 00 00 00 00 00 00 00 00 00 00 00 00 ple............. |
| 345 |
| 80: 00 00 00 00 00 10 00 00 00 00 00 00 01 00 00 00 ................ |
| 346 |
| 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 fe ff ff ................ |
| 347 |
| 112: ff 00 00 00 00 00 00 00 00 00 00 00 4a 00 00 00 ............J... |
| 348 |
| 144: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ |
| 349 |
| 176: e5 ff ff ff 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 350 |
| 208: 00 00 00 00 00 00 00 00 00 00 36 36 00 00 00 00 ..........66.... |
| 351 |
| 240: 00 00 00 6c 00 00 00 00 00 00 00 00 00 00 00 00 ...l............ |
| 352 |
| 256: 00 80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 353 |
| 320: 00 00 00 00 00 00 00 00 01 00 00 02 00 80 00 00 ................ |
| 354 |
| 336: 00 00 00 00 00 19 08 05 17 17 17 17 65 69 67 68 ............eigh |
| 355 |
| 352: 74 65 69 67 68 74 73 65 76 65 6e 73 65 76 65 6e teightsevenseven |
| 356 |
| 368: 25 07 05 07 07 07 07 40 18 00 00 00 00 00 00 40 %......@.......@ |
| 357 |
| 384: 18 00 20 00 00 00 40 00 14 00 00 00 00 00 00 40 .. ...@........@ |
| 358 |
| 400: 14 00 00 00 00 00 1c 09 06 05 01 01 01 01 04 04 ................ |
| 359 |
| 416: 03 03 07 05 05 01 01 00 00 00 00 00 00 00 00 00 ................ |
| 360 |
| 448: 74 73 65 76 65 6e 00 80 ff ff 00 00 00 00 00 aa tseven.......... |
| 361 |
| 464: 00 9e 00 00 00 00 00 00 00 00 00 00 00 70 6f 72 .............por |
| 362 |
| 480: 74 65 72 00 00 00 00 00 00 00 00 00 00 00 00 00 ter............. |
| 363 |
| 496: 00 00 00 00 00 00 29 00 00 00 00 00 00 00 00 00 ......)......... |
| 364 |
| page 5 offset 2048 |
| 365 |
| 0: 0a 00 00 00 08 01 96 00 01 fa 01 c5 01 f2 01 bc ................ |
| 366 |
| 16: 01 dc 01 a6 01 96 01 cc 00 00 00 00 00 00 00 00 ................ |
| 367 |
| 112: 00 00 00 09 00 00 00 00 01 00 00 00 00 00 00 00 ................ |
| 368 |
| 160: 74 72 69 67 62 ff ff ff ff fc 00 00 00 00 00 00 trigb........... |
| 369 |
| 240: 00 00 00 00 00 00 00 00 00 00 ff 00 00 00 00 00 ................ |
| 370 |
| 256: e5 ff ff ff 00 00 54 00 00 00 00 00 00 00 00 00 ......T......... |
| 371 |
| 304: 00 00 00 00 00 00 09 00 00 00 00 00 00 00 00 00 ................ |
| 372 |
| 400: 00 00 00 00 00 09 00 00 00 00 01 00 00 00 00 00 ................ |
| 373 |
| 448: 00 00 74 72 69 67 62 ff ff ff ff fc 00 00 07 05 ..trigb......... |
| 374 |
| 464: 05 01 01 09 09 02 02 19 04 05 17 17 17 17 10 65 ...............e |
| 375 |
| 480: 76 65 6e 65 69 67 68 74 65 40 18 00 00 00 00 01 veneighte@...... |
| 376 |
| 496: 02 03 07 04 01 01 01 03 04 02 05 04 09 01 ff fd ................ |
| 377 |
| end crash-6b48ba69806134.db |
| 378 |
}]} {} |
| 379 |
|
| 380 |
set res {1 {database disk image is malformed}} |
| 381 |
ifcapable oversize_cell_check { |
| 382 |
set res {1 {no such table: t3}} |
| 383 |
} |
| 384 |
do_catchsql_test 4.1 { |
| 385 |
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking |
| 386 |
INSERT INTO t3 SELECT * FROM t2; |
| 387 |
} $res |
| 388 |
|
| 389 |
#------------------------------------------------------------------------- |
| 390 |
reset_db |
| 391 |
do_test 5.0 { |
| 392 |
sqlite3 db {} |
| 393 |
db deserialize [decode_hexdb { |
| 394 |
| size 192512 pagesize 4096 filename crash-9ae5502296c949.db |
| 395 |
| page 1 offset 0 |
| 396 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 397 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 2f .....@ ......./ |
| 398 |
| 32: 00 00 00 1b 00 00 00 13 00 00 00 03 00 00 00 04 ................ |
| 399 |
| 48: 00 00 00 00 00 00 00 06 00 00 00 01 00 00 00 00 ................ |
| 400 |
| 64: 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 401 |
| 96: 00 00 00 00 0d 00 00 00 04 0e e2 00 0f 96 0f 44 ...............D |
| 402 |
| 112: 0f 10 0e e2 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 403 |
| 3808: 00 00 2c 04 06 17 15 11 01 41 69 6e 64 65 78 74 ..,......Aindext |
| 404 |
| 3824: 31 78 32 74 31 06 43 52 45 41 54 45 20 49 4e 44 1x2t1.CREATE IND |
| 405 |
| 3840: 45 58 20 74 31 78 32 20 4f 4e 20 74 31 28 62 29 EX t1x2 ON t1(b) |
| 406 |
| 3856: 32 03 06 17 15 11 01 4d 69 6e 64 65 78 74 31 78 2......Mindext1x |
| 407 |
| 3872: 31 74 31 05 43 52 45 41 54 45 20 49 4e 44 45 58 1t1.CREATE INDEX |
| 408 |
| 3888: 20 74 31 78 31 20 4f 4e 20 74 31 28 67 2b 68 2c t1x1 ON t1(g+h, |
| 409 |
| 3904: 6a 2c 6b 29 50 02 06 17 2b 2b 01 59 74 61 62 6c j,k)P...++.Ytabl |
| 410 |
| 3920: 65 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 esqlite_sequence |
| 411 |
| 3936: 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 04 sqlite_sequence. |
| 412 |
| 3952: 43 52 45 41 54 45 20 54 41 42 4c 45 20 73 71 6c CREATE TABLE sql |
| 413 |
| 3968: 69 74 65 5f 73 65 71 75 65 6e 63 65 28 6e 61 6d ite_sequence(nam |
| 414 |
| 3984: 65 2c 73 65 71 29 68 01 07 17 11 11 01 81 3b 74 e,seq)h.......;t |
| 415 |
| 4000: 61 62 6c 65 74 31 74 31 03 43 52 45 41 54 45 20 ablet1t1.CREATE |
| 416 |
| 4016: 54 41 42 4c 45 20 74 31 28 61 20 49 4e 54 45 47 TABLE t1(a INTEG |
| 417 |
| 4032: 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 41 ER PRIMARY KEY A |
| 418 |
| 4048: 55 54 4f 49 4e 43 52 45 4d 45 4e 54 2c 0a 62 2c UTOINCREMENT,.b, |
| 419 |
| 4064: 63 2c 64 2c 65 2c 66 2c 67 2c 68 2c 6a 2c 6b 2c c,d,e,f,g,h,j,k, |
| 420 |
| 4080: 6c 2c 6d 2c 6e 2c 6f 2c 70 2c 71 2c 72 2c 73 29 l,m,n,o,p,q,r,s) |
| 421 |
| page 2 offset 4096 |
| 422 |
| 0: 01 00 00 00 00 01 00 00 00 00 01 00 00 00 00 01 ................ |
| 423 |
| 16: 00 00 00 00 02 10 00 00 00 05 00 00 00 03 02 00 ................ |
| 424 |
| 32: 00 00 00 05 00 00 00 03 02 00 00 00 00 05 00 00 ................ |
| 425 |
| 48: 00 03 02 00 00 00 00 05 00 00 00 03 02 00 00 00 ................ |
| 426 |
| 64: 00 05 00 00 00 03 02 00 00 00 00 05 00 00 00 03 ................ |
| 427 |
| 80: 02 00 00 00 00 05 00 00 00 03 02 00 00 00 00 05 ................ |
| 428 |
| 96: 00 00 00 03 02 00 00 00 00 05 00 00 00 03 05 00 ................ |
| 429 |
| 112: 00 00 03 03 00 00 00 23 02 00 00 00 00 03 00 00 .......#........ |
| 430 |
| 128: 00 23 02 00 00 00 00 03 00 00 00 23 02 00 00 00 .#.........#.... |
| 431 |
| 144: 00 03 00 00 00 23 02 00 00 00 00 03 00 00 00 23 .....#.........# |
| 432 |
| 160: 05 00 00 00 06 05 00 00 00 06 02 00 00 00 00 03 ................ |
| 433 |
| 176: 00 00 00 06 02 00 00 00 00 03 00 00 00 24 02 00 .............$.. |
| 434 |
| 192: 00 00 00 03 00 00 00 24 02 00 00 00 00 03 00 00 .......$........ |
| 435 |
| 208: 00 24 02 00 00 00 00 02 00 00 00 00 03 00 00 00 .$.............. |
| 436 |
| 224: 24 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 $............... |
| 437 |
| page 3 offset 8192 |
| 438 |
| 0: 05 00 00 00 09 0f d0 00 00 00 00 19 0f fb 0f f6 ................ |
| 439 |
| 16: 0f f1 0f ec 0f e7 0f e2 0f dc 0f d6 0f d0 0f a0 ................ |
| 440 |
| 32: 0f a0 0f a0 0f a0 0f a0 0f a0 0f a0 0f a0 0f a0 ................ |
| 441 |
| 1072: 00 97 4c 0a 14 00 ae 7c 00 00 00 00 00 00 00 00 ..L....|........ |
| 442 |
| 1088: 00 00 00 00 00 00 00 09 00 00 00 00 00 00 00 00 ................ |
| 443 |
| 4000: 0f ac 00 06 00 00 00 00 00 30 00 00 00 00 00 00 .........0...... |
| 444 |
| 4048: 00 00 00 16 81 2a 00 00 00 14 81 16 00 00 00 12 .....*.......... |
| 445 |
| 4064: 81 02 00 00 00 10 6e 00 00 00 0e 5a 00 00 00 0c ......n....Z.... |
| 446 |
| 4080: 46 00 00 00 0a 32 00 00 00 08 1e 00 00 00 18 0a F....2.......... |
| 447 |
| page 4 offset 12288 |
| 448 |
| 0: 0d 00 00 00 01 0f f7 00 0f f7 00 00 00 00 00 00 ................ |
| 449 |
| 4080: 00 00 00 00 00 00 00 07 01 03 11 02 74 31 00 be ............t1.. |
| 450 |
| page 5 offset 16384 |
| 451 |
| 0: 0a 0f 7c 00 0a 0f 74 00 0f f9 0f eb 0f dd 0f cf ..|...t......... |
| 452 |
| 16: 0f c1 0f b3 0f a4 0f 94 0f 84 0f 74 0f 74 0f 74 ...........t.t.t |
| 453 |
| 32: 0f 74 0f 74 0f 74 0f 74 0f 74 0f 74 0f 74 00 00 .t.t.t.t.t.t.t.. |
| 454 |
| 3952: 00 00 00 00 07 05 00 00 00 02 00 be 0f 8c 00 08 ................ |
| 455 |
| 3968: 00 00 00 00 07 05 00 00 00 02 00 aa 0f 9c 00 08 ................ |
| 456 |
| 3984: 00 00 00 00 07 05 00 00 00 02 00 96 0f ac 00 08 ................ |
| 457 |
| 4000: 00 00 00 00 07 05 00 00 00 02 00 82 0f ba 00 07 ................ |
| 458 |
| 4016: 00 00 00 06 05 00 00 00 01 6e 0f c8 00 07 00 00 .........n...... |
| 459 |
| 4032: 00 06 05 00 00 00 01 5a 0f d6 00 07 00 00 00 06 .......Z........ |
| 460 |
| 4048: 05 00 00 00 01 46 0f e4 00 07 00 00 00 06 05 00 .....F.......... |
| 461 |
| 4064: 00 00 01 32 0f f2 00 07 00 00 00 06 05 00 00 00 ...2............ |
| 462 |
| 4080: 01 1e 00 00 00 07 00 00 00 06 05 00 00 00 01 0a ................ |
| 463 |
| page 6 offset 20480 |
| 464 |
| 0: 02 00 00 00 01 0e 0d 00 00 00 00 24 0e 0d 0c 1a ...........$.... |
| 465 |
| 16: 06 55 04 66 02 77 00 88 00 00 00 00 00 00 00 00 .U.f.w.......... |
| 466 |
| 128: 00 00 00 00 00 00 00 00 97 3d 04 ae 7c 01 00 00 .........=..|... |
| 467 |
| 624: 00 00 00 00 00 00 21 97 3d 04 ae 7c 01 00 00 00 ......!.=..|.... |
| 468 |
| 1120: 00 00 00 00 00 20 97 3d 04 ae 7c 01 00 00 00 00 ..... .=..|..... |
| 469 |
| 1616: 00 00 00 00 1f 97 3d 04 ae 7c 01 00 00 00 00 00 ......=..|...... |
| 470 |
| 2112: 00 00 00 1e 97 3d 04 ae 7c 01 00 00 00 00 00 00 .....=..|....... |
| 471 |
| 2608: 00 00 1d 97 3d 04 ae 7c 01 00 00 00 00 00 00 00 ....=..|........ |
| 472 |
| 3088: 00 00 00 00 00 00 00 00 00 00 00 00 01 f3 00 00 ................ |
| 473 |
| 3600: 23 97 3d 04 ae 7c 01 00 00 00 00 00 00 00 00 00 #.=..|.......... |
| 474 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 26 ...............& |
| 475 |
| page 8 offset 28672 |
| 476 |
| 0: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 477 |
| 1072: 97 4d 1e 14 00 ae 7c 00 00 00 00 00 00 00 00 00 .M....|......... |
| 478 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 479 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 03 ................ |
| 480 |
| page 10 offset 36864 |
| 481 |
| 256: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 482 |
| 1072: 97 4d 32 14 00 ae 7c 00 00 00 00 00 00 00 00 00 .M2...|......... |
| 483 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 484 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 05 ................ |
| 485 |
| page 12 offset 45056 |
| 486 |
| 0: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 487 |
| 1072: 97 4d 46 14 00 ae 7c 00 00 00 00 00 00 00 00 00 .MF...|......... |
| 488 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 489 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 07 ................ |
| 490 |
| page 14 offset 53248 |
| 491 |
| 0: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 492 |
| 1072: 97 4d 5a 14 00 ae 7c 00 00 00 00 00 00 00 00 00 .MZ...|......... |
| 493 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 494 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 09 ................ |
| 495 |
| page 16 offset 61440 |
| 496 |
| 0: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 497 |
| 1072: 97 4d 6e 14 00 ae 7c 00 00 00 00 00 00 00 00 00 .Mn...|......... |
| 498 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 499 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0b ................ |
| 500 |
| page 18 offset 69632 |
| 501 |
| 0: 0d 00 00 00 01 04 2f 00 04 2f 00 00 00 00 00 00 ....../../...... |
| 502 |
| 1056: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 97 ................ |
| 503 |
| 1072: 4d 81 02 14 00 ae 7c 00 00 00 00 00 00 00 00 00 M.....|......... |
| 504 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 505 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0d ................ |
| 506 |
| page 20 offset 77824 |
| 507 |
| 0: 0d 00 00 00 01 04 2f 00 04 2f 00 00 00 00 00 00 ....../../...... |
| 508 |
| 1056: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 97 ................ |
| 509 |
| 1072: 4d 81 16 14 00 ae 7c 00 00 00 00 00 00 00 00 00 M.....|......... |
| 510 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 511 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0f ................ |
| 512 |
| page 22 offset 86016 |
| 513 |
| 0: 0d 00 00 00 01 04 2f 00 04 2f 00 00 00 00 00 00 ....../../...... |
| 514 |
| 1056: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 97 ................ |
| 515 |
| 1072: 4d 81 2a 14 00 ae 7c 00 00 00 00 00 00 00 00 00 M.*...|......... |
| 516 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 517 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 11 ................ |
| 518 |
| page 24 offset 94208 |
| 519 |
| 0: 0d 00 00 00 01 04 31 00 04 31 00 00 00 00 00 00 ......1..1...... |
| 520 |
| 1072: 00 97 4c 0a 14 00 ae 7c 00 00 00 00 00 00 00 00 ..L....|........ |
| 521 |
| 1088: 00 00 00 00 00 00 00 09 00 00 00 00 00 00 00 00 ................ |
| 522 |
| page 25 offset 98304 |
| 523 |
| 0: 0d 00 00 00 01 04 2f 00 04 2f 00 00 00 00 00 00 ....../../...... |
| 524 |
| 1056: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 97 ................ |
| 525 |
| 1072: 4d 81 3e 14 00 ae 7c 00 00 00 00 00 00 00 00 00 M.>...|......... |
| 526 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 527 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 13 ................ |
| 528 |
| page 26 offset 102400 |
| 529 |
| 2512: 00 00 00 00 00 00 00 0a 00 00 00 00 00 00 00 00 ................ |
| 530 |
| page 27 offset 106496 |
| 531 |
| 0: 00 00 00 00 00 00 00 12 00 00 00 07 00 00 00 1d ................ |
| 532 |
| 16: 00 00 00 09 00 00 00 1f 00 00 00 0b 00 00 00 21 ...............! |
| 533 |
| 32: 00 00 00 0d 00 00 00 25 00 00 00 0f 00 00 00 19 .......%........ |
| 534 |
| 48: 00 00 00 11 00 00 00 29 00 00 00 13 00 00 00 2b .......).......+ |
| 535 |
| 64: 00 00 00 15 00 00 00 2d 00 00 00 2e 00 00 00 17 .......-........ |
| 536 |
| page 28 offset 110592 |
| 537 |
| 2512: 00 00 00 00 00 00 00 1e 00 00 00 00 00 00 00 00 ................ |
| 538 |
| page 30 offset 118784 |
| 539 |
| 2512: 00 00 00 00 00 00 00 32 00 00 00 00 00 00 00 00 .......2........ |
| 540 |
| page 32 offset 126976 |
| 541 |
| 2512: 00 00 00 00 00 00 00 46 00 00 00 00 00 00 00 00 .......F........ |
| 542 |
| page 34 offset 135168 |
| 543 |
| 2512: 00 00 00 00 00 00 00 5a 00 00 00 00 00 00 00 00 .......Z........ |
| 544 |
| page 35 offset 139264 |
| 545 |
| 0: 0a 08 44 00 05 02 77 00 0e 11 0a 33 06 55 02 77 ..D...w....3.U.w |
| 546 |
| 16: 04 66 00 88 00 88 00 88 00 00 00 00 00 00 00 00 .f.............. |
| 547 |
| 128: 00 00 00 00 00 00 00 00 04 66 01 ef 00 00 00 00 .........f...... |
| 548 |
| 624: 00 00 00 00 00 00 00 97 3d 04 ae 7c 01 00 00 00 ........=..|.... |
| 549 |
| 1120: 00 00 00 00 00 20 97 3d 04 ae 7c 01 00 00 00 00 ..... .=..|..... |
| 550 |
| 1616: 00 00 00 00 22 97 3d 04 ae 7c 01 00 00 00 00 00 ......=..|...... |
| 551 |
| 2112: 00 00 00 1e 0c 22 01 ef 00 00 00 00 00 00 00 00 ................ |
| 552 |
| 2608: 00 00 00 97 3d 04 ae 7c 01 00 00 00 00 00 00 00 ....=..|........ |
| 553 |
| 3104: 00 1c 00 00 01 ef 00 00 00 00 00 00 00 00 00 00 ................ |
| 554 |
| 3600: 00 97 3d 04 ae 7c 01 00 00 00 00 00 00 00 00 00 ..=..|.......... |
| 555 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 1a ................ |
| 556 |
| page 36 offset 143360 |
| 557 |
| 0: 0a 08 44 00 04 02 77 00 06 55 02 77 04 66 0e 11 ..D...w..U.w.f.. |
| 558 |
| 16: 00 88 00 88 00 88 0e 11 00 00 00 00 00 00 00 00 ................ |
| 559 |
| 128: 00 00 00 00 00 00 00 00 04 76 01 ef 00 00 00 00 .........v...... |
| 560 |
| 624: 00 00 00 00 00 00 00 97 3e 04 ae 7c 02 00 00 00 ........>..|.... |
| 561 |
| 1120: 00 00 00 00 00 2a 97 3e 04 ae 7c 02 00 00 00 00 .....*.>..|..... |
| 562 |
| 1616: 00 00 00 00 2c 97 3e 04 ae 7c 02 00 00 00 00 00 ....,.>..|...... |
| 563 |
| 2112: 00 00 00 28 00 00 05 cd 00 00 00 00 00 00 00 00 ...(............ |
| 564 |
| 3600: 00 97 3e 04 ae 7c 02 00 00 00 00 00 00 00 00 00 ..>..|.......... |
| 565 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 2f .............../ |
| 566 |
| page 38 offset 151552 |
| 567 |
| 2512: 00 00 00 00 00 00 00 6e 00 00 00 00 00 00 00 00 .......n........ |
| 568 |
| page 40 offset 159744 |
| 569 |
| 2512: 00 00 00 00 00 00 00 00 82 00 00 00 00 00 00 00 ................ |
| 570 |
| page 42 offset 167936 |
| 571 |
| 2512: 00 00 00 00 00 00 00 00 96 00 00 00 00 00 00 00 ................ |
| 572 |
| page 44 offset 176128 |
| 573 |
| 2512: 00 00 00 00 00 00 00 00 aa 00 00 00 00 00 00 00 ................ |
| 574 |
| page 47 offset 188416 |
| 575 |
| 2512: 00 00 00 00 00 00 00 00 be 00 00 00 00 00 00 00 ................ |
| 576 |
| end crash-9ae5502296c949.db |
| 577 |
}]} {} |
| 578 |
|
| 579 |
do_catchsql_test 5.1 { |
| 580 |
INSERT INTO t1(b) VALUES(zeroblob(40000)); |
| 581 |
} {1 {database disk image is malformed}} |
| 582 |
|
| 583 |
do_catchsql_test 5.2 { |
| 584 |
DROP INDEX t1x2; |
| 585 |
} {0 {}} |
| 586 |
|
| 587 |
do_catchsql_test 5.3 { |
| 588 |
INSERT INTO t1(b) VALUES(zeroblob(40000)); |
| 589 |
} {1 {database disk image is malformed}} |
| 590 |
|
| 591 |
#------------------------------------------------------------------------- |
| 592 |
reset_db |
| 593 |
do_test 6.0 { |
| 594 |
sqlite3 db {} |
| 595 |
db deserialize [decode_hexdb { |
| 596 |
| size 20480 pagesize 4096 filename crash-d260f001fa015c.db |
| 597 |
| page 1 offset 0 |
| 598 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 599 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 05 .....@ ........ |
| 600 |
| 32: 00 00 00 00 00 ff ff f0 00 00 00 02 00 00 00 04 ................ |
| 601 |
| 48: 00 00 00 00 00 00 00 64 00 00 00 01 00 00 00 00 .......d........ |
| 602 |
| 96: 00 00 00 00 0d 0f f8 00 04 0e ce 00 0f 4c 0f d3 .............L.. |
| 603 |
| 112: 0e fa 0e ce 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 604 |
| 3776: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 2a 04 ..............*. |
| 605 |
| 3792: 06 17 13 11 01 3f 69 6e 64 65 78 74 31 62 74 31 .....?indext1bt1 |
| 606 |
| 3808: 05 43 52 45 41 54 45 20 49 4e 44 45 58 20 74 31 .CREATE INDEX t1 |
| 607 |
| 3824: 62 20 4f 4e 20 74 31 28 62 29 50 03 06 17 2b 2b b ON t1(b)P...++ |
| 608 |
| 3840: 01 59 74 61 62 6c 65 73 71 6c 69 74 65 5f 73 65 .Ytablesqlite_se |
| 609 |
| 3856: 71 75 65 6e 63 65 73 71 6c 69 74 65 5f 73 65 71 quencesqlite_seq |
| 610 |
| 3872: 75 65 6e 63 65 04 43 52 45 41 54 45 20 54 41 42 uence.CREATE TAB |
| 611 |
| 3888: 4c 45 20 73 71 6c 69 74 65 5f 73 65 71 75 65 6e LE sqlite_sequen |
| 612 |
| 3904: 63 65 28 6e 61 6d 65 2c 73 65 71 29 81 04 01 07 ce(name,seq).... |
| 613 |
| 3920: 17 11 11 01 81 73 74 61 62 6c 65 74 31 74 31 02 .....stablet1t1. |
| 614 |
| 3936: 43 52 45 41 54 45 20 54 41 42 4c 45 20 74 31 28 CREATE TABLE t1( |
| 615 |
| 3952: 61 20 52 45 41 4c 20 4e 4f 54 20 4e 55 4c 4c 20 a REAL NOT NULL |
| 616 |
| 3968: 44 45 46 41 55 4c 54 28 32 35 2b 33 32 29 2c 62 DEFAULT(25+32),b |
| 617 |
| 3984: 20 46 4c 4f 41 54 2c 63 20 44 4f 55 42 4c 45 20 FLOAT,c DOUBLE |
| 618 |
| 4000: 55 4e 49 51 55 45 2c 0a 64 20 43 4c 4f 42 2c 65 UNIQUE,.d CLOB,e |
| 619 |
| 4016: 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 INTEGER PRIMARY |
| 620 |
| 4032: 20 4b 45 59 20 41 55 54 4f 49 4e 43 52 45 4d 45 KEY AUTOINCREME |
| 621 |
| 4048: 4e 54 29 23 02 06 17 37 11 01 00 69 6e 64 65 78 NT)#...7...index |
| 622 |
| 4064: 73 71 6c 69 74 65 5f 61 75 74 6f 69 6e 64 65 78 sqlite_autoindex |
| 623 |
| 4080: 5f 74 31 5f 31 74 31 05 00 00 00 08 00 00 00 00 _t1_1t1......... |
| 624 |
| page 2 offset 4096 |
| 625 |
| 0: 0d 00 00 00 00 10 00 00 00 00 00 00 00 00 00 00 ................ |
| 626 |
| page 3 offset 8192 |
| 627 |
| 0: 0a 00 00 00 00 10 00 00 00 00 00 00 00 00 00 00 ................ |
| 628 |
| page 4 offset 12288 |
| 629 |
| 0: 0d 00 00 00 00 10 00 00 00 00 00 00 00 00 00 00 ................ |
| 630 |
| page 5 offset 16384 |
| 631 |
| 0: 0a 00 00 00 00 10 00 00 00 00 00 00 00 00 00 00 ................ |
| 632 |
| end crash-d260f001fa015c.db |
| 633 |
}]} {} |
| 634 |
|
| 635 |
do_catchsql_test 6.1 { |
| 636 |
BEGIN; |
| 637 |
INSERT INTO t1(b) VALUES(1); |
| 638 |
INSERT INTO t1(b) VALUES(2); |
| 639 |
COMMIT; |
| 640 |
} {1 {malformed database schema (t1b) - invalid rootpage}} |
| 641 |
|
| 642 |
#------------------------------------------------------------------------- |
| 643 |
reset_db |
| 644 |
do_test 7.0 { |
| 645 |
sqlite3 db {} |
| 646 |
db deserialize [decode_hexdb { |
| 647 |
| size 20480 pagesize 4096 filename crash-8391315d75edff.db |
| 648 |
| page 1 offset 0 |
| 649 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 650 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 05 .....@ ........ |
| 651 |
| 32: 00 00 00 00 00 00 00 00 00 00 00 05 00 00 00 04 ................ |
| 652 |
| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ |
| 653 |
| 96: 00 00 00 00 0d 00 00 00 05 0e 55 00 0f 74 0f 3c ..........U..t.< |
| 654 |
| 112: 0e f9 0e d1 0e 55 00 00 00 00 00 00 00 00 00 00 .....U.......... |
| 655 |
| 3664: 00 00 00 00 00 7a 05 07 15 11 11 08 81 63 76 69 .....z.......cvi |
| 656 |
| 3680: 65 77 76 31 76 31 43 52 45 41 54 45 20 56 49 45 ewv1v1CREATE VIE |
| 657 |
| 3696: 57 20 76 31 28 78 2c 69 29 20 41 53 0a 53 45 4c W v1(x,i) AS.SEL |
| 658 |
| 3712: 45 43 54 20 74 31 2e 62 2c 74 32 2e 62 20 46 52 ECT t1.b,t2.b FR |
| 659 |
| 3728: 4f 4d 20 74 31 2c 74 32 20 57 48 45 52 45 20 74 OM t1,t2 WHERE t |
| 660 |
| 3744: 31 2e 61 3d 74 32 2e 61 20 47 52 4f 55 50 20 42 1.a=t2.a GROUP B |
| 661 |
| 3760: 59 20 31 20 48 41 56 49 4e 47 20 74 32 2e 63 20 Y 1 HAVING t2.c |
| 662 |
| 3776: 4e 4f 54 20 4e 55 4c 4c 0a 4c 49 4d 49 54 20 31 NOT NULL.LIMIT 1 |
| 663 |
| 3792: 30 26 04 06 17 11 11 01 39 74 61 62 6c 65 74 32 0&......9tablet2 |
| 664 |
| 3808: 74 32 05 43 52 45 41 54 45 20 54 41 42 4c 45 20 t2.CREATE TABLE |
| 665 |
| 3824: 74 32 28 61 2c 62 2c 63 29 41 03 06 17 15 11 01 t2(a,b,c)A...... |
| 666 |
| 3840: 6b 69 6e 64 65 78 74 31 78 31 74 31 03 43 52 45 kindext1x1t1.CRE |
| 667 |
| 3856: 41 54 45 20 49 4e 44 45 58 20 74 31 78 31 20 4f ATE INDEX t1x1 O |
| 668 |
| 3872: 4e 20 74 31 28 64 29 20 57 48 45 52 45 20 65 65 N t1(d) WHERE ee |
| 669 |
| 3888: 20 49 53 20 4e 4f 54 20 4e 55 4c 4c 36 02 06 17 IS NOT NULL6... |
| 670 |
| 3904: 17 11 01 53 69 6e 64 65 78 74 31 61 62 63 74 31 ...Sindext1abct1 |
| 671 |
| 3920: 03 43 52 45 41 54 45 20 49 4e 44 45 58 20 74 31 .CREATE INDEX t1 |
| 672 |
| 3936: 61 62 63 20 4f 4e 20 74 31 28 61 2c 62 2c 63 2b abc ON t1(a,b,c+ |
| 673 |
| 3952: 64 2b 65 29 81 09 01 07 17 11 11 01 81 7d 74 61 d+e)..........ta |
| 674 |
| 3968: 62 6c 65 74 31 74 31 02 43 52 45 41 54 45 20 54 blet1t1.CREATE T |
| 675 |
| 3984: 41 42 4c 45 20 74 31 28 61 2c 62 2c 63 2c 64 2c ABLE t1(a,b,c,d, |
| 676 |
| 4000: 65 2c 66 2c 67 2c 68 2c 6a 2c 6a 6a 2c 6a 6a 6a e,f,g,h,j,jj,jjj |
| 677 |
| 4016: 2c 6b 2c 61 61 2c 62 69 8c 63 63 2c 64 64 2c 65 ,k,aa,bi.cc,dd,e |
| 678 |
| 4032: 65 20 44 45 46 41 55 4c 54 20 33 2e 31 34 2c 0a e DEFAULT 3.14,. |
| 679 |
| 4048: 66 66 20 44 45 46 41 55 4c 54 28 27 68 69 63 63 ff DEFAULT('hicc |
| 680 |
| 4064: 75 70 27 29 2c 67 67 20 4e 4f 54 20 4e 55 4c 4c up'),gg NOT NULL |
| 681 |
| 4080: 20 44 45 46 41 55 4c 54 28 66 61 6c 73 65 29 29 DEFAULT(false)) |
| 682 |
| page 2 offset 4096 |
| 683 |
| 0: 0d 00 00 00 0a 0e 7b 00 0f dc 0f b6 0f 8f 0f 68 ...............h |
| 684 |
| 16: 0f 41 0f 1a 0e f3 0e cb 0e a3 0e 22 00 00 00 00 .A.............. |
| 685 |
| 3696: 00 00 00 00 00 00 00 00 00 00 00 26 0a 14 01 01 ...........&.... |
| 686 |
| 3712: 02 08 00 00 00 00 00 00 00 00 00 00 00 00 07 19 ................ |
| 687 |
| 3728: 08 09 5a 00 b4 40 09 1e b8 51 eb 95 1f 68 69 63 [email protected] |
| 688 |
| 3744: 63 75 70 26 09 14 01 01 02 08 00 00 00 00 00 00 cup&............ |
| 689 |
| 3760: 00 00 00 00 00 00 07 19 08 08 50 00 a0 40 09 1e ..........P..@.. |
| 690 |
| 3776: b8 51 eb 85 1f 68 69 63 63 74 70 26 08 14 01 01 .Q...hicctp&.... |
| 691 |
| 3792: 03 08 00 00 00 00 00 00 00 00 00 00 00 00 07 19 ................ |
| 692 |
| 3808: 08 07 46 00 8c 40 09 1e b8 51 eb 85 1f 68 69 63 [email protected] |
| 693 |
| 3824: 63 75 70 25 07 14 01 01 01 08 00 00 00 00 00 00 cup%............ |
| 694 |
| 3840: 00 00 00 00 00 10 07 19 08 06 3c 78 40 09 1e b8 ..........<x@... |
| 695 |
| 3856: 51 eb 85 1f 68 69 63 63 75 70 25 06 14 01 01 01 Q...hiccup%..... |
| 696 |
| 3872: 08 00 00 00 00 00 00 00 00 00 00 00 00 07 19 08 ................ |
| 697 |
| 3888: 05 32 64 40 09 1e b8 51 eb 85 1f 68 69 63 63 75 [email protected] |
| 698 |
| 3904: 70 25 05 14 01 01 01 08 00 00 00 00 00 00 00 00 p%.............. |
| 699 |
| 3920: 00 00 00 00 07 19 08 04 28 50 40 09 1e b8 51 eb ........([email protected]. |
| 700 |
| 3936: 85 1f 68 69 63 63 75 70 25 04 14 01 00 f1 08 00 ..hiccup%....... |
| 701 |
| 3952: 00 00 00 00 00 00 00 00 00 00 00 07 19 08 03 1e ................ |
| 702 |
| 3968: 3c 40 09 1e b8 51 eb 85 1f 68 69 63 63 75 70 25 <@...Q...hiccup% |
| 703 |
| 3984: 03 14 01 01 01 08 00 00 00 00 00 00 00 00 00 00 ................ |
| 704 |
| 4000: 00 00 07 19 08 02 14 28 40 09 1e b8 51 eb 85 1f .......(@...Q... |
| 705 |
| 4016: 68 69 63 63 75 70 24 02 14 09 01 01 08 00 00 00 hiccup$......... |
| 706 |
| 4032: 00 00 00 00 00 00 00 00 00 07 19 08 0a 14 40 09 ..............@. |
| 707 |
| 4048: 1e b8 51 eb 85 1f 68 69 63 63 75 70 22 01 14 08 ..Q...hiccup.... |
| 708 |
| 4064: 08 08 08 00 00 00 00 00 00 00 00 00 00 00 00 07 ................ |
| 709 |
| 4080: 19 08 40 09 1e b8 51 eb 85 1f 68 69 63 63 75 70 [email protected] |
| 710 |
| page 3 offset 8192 |
| 711 |
| 0: 0a 00 00 00 0a 0f aa 00 0f fa 0f f2 0f e9 0f e0 ................ |
| 712 |
| 16: 0f d7 0f ce 0f c5 0f bc 0f b3 0f aa 00 00 00 00 ................ |
| 713 |
| 4000: 00 00 00 00 00 00 00 00 00 00 08 05 01 01 00 01 ................ |
| 714 |
| 4016: 09 5a 0a d8 05 01 01 00 01 08 50 09 08 05 01 01 .Z........P..... |
| 715 |
| 4032: 00 01 07 46 08 08 05 01 01 00 01 06 3c 07 08 05 ...F........<... |
| 716 |
| 4048: 01 01 00 01 05 32 06 08 05 01 01 00 01 04 28 05 .....2........(. |
| 717 |
| 4064: 08 05 01 02 60 01 03 1e 04 08 05 01 01 00 01 02 ....`........... |
| 718 |
| 4080: 14 03 07 05 09 01 00 01 0a 02 05 05 08 08 00 09 ................ |
| 719 |
| page 4 offset 12288 |
| 720 |
| 0: 0a 00 00 00 0a 0f cf 00 0f fc 0f f7 0f f2 0f ed ................ |
| 721 |
| 16: 0f e8 0f e3 0f de 0f d9 0f d4 0f cf 00 00 00 00 ................ |
| 722 |
| 4032: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 04 ................ |
| 723 |
| 4048: 03 08 01 0a 04 03 08 01 09 04 03 08 01 08 04 03 ................ |
| 724 |
| 4064: 08 01 07 04 03 08 01 06 04 03 08 01 05 04 03 08 ................ |
| 725 |
| 4080: 01 04 04 03 08 01 03 04 03 08 01 02 03 03 08 09 ................ |
| 726 |
| page 5 offset 16384 |
| 727 |
| 0: 0d 00 00 00 00 10 00 00 00 00 00 00 00 00 00 00 ................ |
| 728 |
| end crash-8391315d75edff.db |
| 729 |
}]} {} |
| 730 |
|
| 731 |
do_catchsql_test 7.1 { |
| 732 |
SELECT * FROM sqlite_master; |
| 733 |
} {1 {malformed database schema (t1x1) - invalid rootpage}} |
| 734 |
|
| 735 |
#------------------------------------------------------------------------- |
| 736 |
reset_db |
| 737 |
do_test 8.0 { |
| 738 |
sqlite3 db {} |
| 739 |
db deserialize [decode_hexdb { |
| 740 |
| size 2048 pagesize 512 filename a.db |
| 741 |
| page 1 offset 0 |
| 742 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 743 |
| 16: 02 00 01 01 00 40 20 20 ff ff 00 0c 00 00 00 07 .....@ ........ |
| 744 |
| 32: 0b 00 00 00 00 00 00 00 00 00 00 08 9c 00 00 04 ................ |
| 745 |
| 48: 00 00 00 e0 09 00 00 01 00 00 00 01 00 00 00 00 ................ |
| 746 |
| 64: 00 00 00 00 f2 ff 00 00 00 00 00 00 00 00 00 00 ................ |
| 747 |
| 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0c ................ |
| 748 |
| 96: 00 2e 2c 50 0d 00 00 00 06 01 06 00 01 da 01 b0 ..,P............ |
| 749 |
| 112: 05 56 01 86 01 2a 01 06 00 00 00 00 00 06 00 00 .V...*.......... |
| 750 |
| 128: 00 ff 00 00 ff ff ff e1 00 00 00 00 00 00 00 00 ................ |
| 751 |
| 144: 00 00 00 00 00 00 00 00 00 01 00 00 00 00 00 00 ................ |
| 752 |
| 160: 00 00 00 00 00 00 00 00 f2 00 00 00 00 00 00 00 ................ |
| 753 |
| 176: 00 00 f9 ff ff ff ff ff ff ff 00 00 00 5f 00 fb ............._.. |
| 754 |
| 192: 00 00 00 00 00 00 00 00 00 e1 ff 00 00 00 00 00 ................ |
| 755 |
| 208: 00 00 10 00 00 00 00 00 1e 00 00 00 fe 00 00 00 ................ |
| 756 |
| 224: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ca 00 ................ |
| 757 |
| 240: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 35 ...............5 |
| 758 |
| 256: 00 00 00 00 ef ff 22 07 06 17 11 11 01 30 39 38 .............098 |
| 759 |
| 272: 62 6c 65 74 38 38 74 04 43 52 45 41 54 45 20 54 blet88t.CREATE T |
| 760 |
| 288: 41 42 4c 45 20 74 34 28 87 29 2a 06 06 17 13 11 ABLE t4(.)*..... |
| 761 |
| 304: 01 3f 69 4f 64 65 78 74 33 78 74 40 05 43 52 45 [email protected] |
| 762 |
| 320: 41 54 45 20 49 6e 44 45 58 20 74 33 78 20 4f 4e ATE InDEX t3x ON |
| 763 |
| 336: 20 74 33 28 78 29 2e 04 06 17 15 11 01 45 69 6e t3(x).......Ein |
| 764 |
| 352: 00 04 00 00 34 63 64 74 3d 05 43 52 45 41 54 45 ....4cdt=.CREATE |
| 765 |
| 368: 20 49 4e 44 45 58 20 63 74 64 32 20 4f 4e 20 74 INDEX ctd2 ON t |
| 766 |
| 384: 32 28 0a 0c 44 29 28 05 06 17 11 11 01 3d 74 6c 2(..D)(......=tl |
| 767 |
| 400: 62 61 d4 65 33 74 33 04 43 52 45 41 54 45 20 54 ba.e3t3.CREATE T |
| 768 |
| 416: 41 42 4c 45 20 74 33 28 63 2c 78 2c 65 2c 66 29 ABLE t3(c,x,e,f) |
| 769 |
| 432: 28 02 06 17 11 11 01 3d 74 61 62 6c 65 74 32 74 (......=tablet2t |
| 770 |
| 448: 32 03 43 52 45 41 54 45 20 54 41 42 4c 45 20 74 2.CREATE TABLE t |
| 771 |
| 464: 32 28 63 2c 64 2c 65 2c 66 29 24 01 06 17 11 11 2(c,d,e,f)$..... |
| 772 |
| 480: 01 35 74 60 62 6c 65 74 31 74 31 02 43 52 45 41 .5t`blet1t1.CREA |
| 773 |
| 496: 54 45 20 54 41 42 4c 45 20 74 30 28 61 2c 62 29 TE TABLE t0(a,b) |
| 774 |
| page 2 offset 512 |
| 775 |
| 0: 0d 00 ff 11 04 01 cf 80 01 fa 01 09 00 de 01 cf ................ |
| 776 |
| 16: 00 00 00 00 00 00 00 00 00 01 00 00 00 00 00 00 ................ |
| 777 |
| 32: 00 00 08 00 00 00 00 00 00 11 00 00 00 00 00 13 ................ |
| 778 |
| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 e0 ff ff ................ |
| 779 |
| 64: ff d2 ff ff ff 00 f8 ff ff ff 00 00 00 00 00 00 ................ |
| 780 |
| 80: 00 ff ff 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 781 |
| 96: 00 00 00 00 ff de 00 00 00 00 00 00 00 00 00 00 ................ |
| 782 |
| 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 40 00 00 .............@.. |
| 783 |
| 128: 2a 00 00 00 00 00 00 00 00 f7 00 00 00 00 00 00 *............... |
| 784 |
| 144: 00 00 00 00 00 21 00 00 00 00 00 00 00 00 00 00 .....!.......... |
| 785 |
| 160: 01 64 00 00 00 00 04 80 ff ff ff 00 00 00 00 00 .d.............. |
| 786 |
| 176: 00 00 00 00 00 00 00 00 1f 00 00 00 00 00 00 00 ................ |
| 787 |
| 192: 00 00 40 00 00 00 00 00 00 00 00 00 00 00 00 00 ..@............. |
| 788 |
| 208: b5 00 00 00 00 00 00 40 00 00 00 00 00 00 00 00 .......@........ |
| 789 |
| 224: 00 00 00 f6 00 ee ff ff ff 00 00 00 00 00 00 00 ................ |
| 790 |
| 272: f2 00 00 00 00 00 00 00 00 00 f9 ff ff ff ff ff ................ |
| 791 |
| 288: ff ff 00 00 00 5f 00 fb 00 00 00 00 00 00 00 00 ....._.......... |
| 792 |
| 320: 1e 00 00 00 fe 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 793 |
| 336: 00 00 00 00 00 00 ca 00 00 00 00 00 00 00 ff ec ................ |
| 794 |
| 352: 00 00 00 00 00 00 00 32 00 00 00 00 ef ff 22 07 .......2........ |
| 795 |
| 368: 06 17 11 11 01 30 74 61 62 6c 65 74 38 38 74 04 .....0tablet88t. |
| 796 |
| 384: 43 52 45 41 54 45 20 54 41 42 4c 45 20 8c cb d7 CREATE TABLE ... |
| 797 |
| 400: 78 d6 d5 f9 f9 17 13 11 01 3f 69 4f 64 65 78 74 x........?iOdext |
| 798 |
| 416: 33 78 74 33 05 43 52 45 41 54 45 26 49 6e 44 45 3xt3.CREATE&InDE |
| 799 |
| 432: 58 20 74 33 78 00 00 00 00 00 00 00 00 00 00 00 X t3x........... |
| 800 |
| 464: 00 00 00 00 00 13 76 65 6e 65 69 67 68 74 13 03 ......veneight.. |
| 801 |
| 480: 03 40 07 07 15 00 54 45 20 49 4e 44 45 58 20 74 [email protected] INDEX t |
| 802 |
| 496: 31 63 64 20 4f 4e 20 74 ce d7 f5 f0 44 09 01 02 1cd ON t....D... |
| 803 |
| page 3 offset 1024 |
| 804 |
| 0: 0d 00 00 00 48 01 54 00 01 f6 e2 ec 01 c5 01 aa ....H.T......... |
| 805 |
| 16: 30 34 28 87 29 32 06 f5 16 13 11 01 8e 61 24 64 04(.)2.......a$d |
| 806 |
| 32: 65 78 74 37 78 1f 33 6d 6d 6d 6d 6d 00 00 04 06 ext7x.3mmmmm.... |
| 807 |
| 48: 6d 41 6d 6d 6e 6d 6d 00 00 02 00 6d 6d 6d 6d 6d mAmmnmm....mmmmm |
| 808 |
| 64: 15 11 01 45 45 45 45 45 45 45 45 45 45 45 45 45 ...EEEEEEEEEEEEE |
| 809 |
| 80: 45 45 45 45 45 45 45 45 45 45 45 00 45 63 74 64 EEEEEEEEEEE.Ectd |
| 810 |
| 96: 34 20 4f 4e 20 61 62 6c 5d 74 38 38 74 04 43 52 4 ON abl]t88t.CR |
| 811 |
| 112: 45 41 54 45 20 54 41 42 4c 45 20 74 34 28 87 29 EATE TABLE t4(.) |
| 812 |
| 128: 2a 06 06 13 13 01 00 00 00 4f 64 6e 78 74 33 44 *........Odnxt3D |
| 813 |
| 144: 74 13 05 43 52 45 41 54 45 20 49 6e 44 45 00 00 t..CREATE InDE.. |
| 814 |
| 160: 00 00 00 00 00 00 00 f9 ff ff ff ff ff ff ff 00 ................ |
| 815 |
| 176: 00 00 5f 00 fb 00 00 2d 00 00 00 00 00 00 00 00 .._....-........ |
| 816 |
| 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 1e 00 00 ................ |
| 817 |
| 208: 00 fe 00 00 00 00 17 15 11 01 45 69 6e 64 65 2e ..........Einde. |
| 818 |
| 224: 5b 38 63 64 74 3d 05 43 52 45 41 54 45 20 49 4e [8cdt=.CREATE IN |
| 819 |
| 240: 44 45 58 20 63 20 64 32 20 4f 4e 20 74 32 28 0a DEX c d2 ON t2(. |
| 820 |
| 256: 0c 44 32 05 00 10 00 00 11 11 3d 74 6c 62 61 d4 .D2.......=tlba. |
| 821 |
| 272: 65 33 74 33 04 43 52 45 41 54 45 20 54 41 42 4c e3t3.CREATE TABL |
| 822 |
| 288: 45 20 74 36 ff ff 7f ff 43 52 45 41 54 45 20 49 E t6....CREATE I |
| 823 |
| 304: 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 28 sqlite_sequence( |
| 824 |
| 320: 0a 0c 44 29 28 05 06 17 11 11 01 3d 74 6c 62 61 ..D)(......=tlba |
| 825 |
| 336: 20 00 00 00 33 04 43 52 45 41 54 45 20 54 41 42 ...3.CREATE TAB |
| 826 |
| 352: 4c 45 20 74 33 28 63 2c 78 2c 65 2c 66 29 28 02 LE t3(c,x,e,f)(. |
| 827 |
| 368: 06 00 00 7f ff 40 41 54 45 20 49 6e 44 45 58 20 .....@ATE InDEX |
| 828 |
| 384: 74 33 78 20 4f 4e 20 74 31 28 78 29 2e 04 06 17 t3x ON t1(x).... |
| 829 |
| 400: 15 11 01 45 69 6e 64 65 2e 74 34 63 64 74 3d 05 ...Einde.t4cdt=. |
| 830 |
| 416: 00 00 00 00 00 00 00 00 00 00 00 4d 00 00 00 00 ...........M.... |
| 831 |
| 432: 01 00 00 00 00 00 00 05 00 00 10 00 00 00 00 00 ................ |
| 832 |
| 448: 00 01 00 00 00 00 01 00 00 00 00 07 40 14 00 00 ............@... |
| 833 |
| 464: 00 00 21 00 40 18 00 00 00 00 00 00 40 1c 00 00 ..!.@.......@... |
| 834 |
| 480: 00 00 ff ff ff 00 00 00 5f 00 fb 00 00 2d 00 00 ........_....-.. |
| 835 |
| 496: 00 00 00 1e 00 00 00 fe 00 00 64 00 00 ff fb 02 ..........d..... |
| 836 |
| page 4 offset 1536 |
| 837 |
| 0: 0d 00 39 00 00 02 00 00 00 00 00 00 00 00 00 00 ..9............. |
| 838 |
| end a.db |
| 839 |
}]} {} |
| 840 |
|
| 841 |
set res {1 {database disk image is malformed}} |
| 842 |
ifcapable oversize_cell_check { |
| 843 |
set res {1 {no such table: t3}} |
| 844 |
} |
| 845 |
do_catchsql_test 8.1 { |
| 846 |
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking |
| 847 |
INSERT INTO t3 SELECT * FROM t2; |
| 848 |
} $res |
| 849 |
|
| 850 |
#------------------------------------------------------------------------- |
| 851 |
reset_db |
| 852 |
do_test 9.0 { |
| 853 |
sqlite3 db {} |
| 854 |
db deserialize [decode_hexdb { |
| 855 |
| size 8192 pagesize 4096 filename crash-ab10597e4e1c32.db |
| 856 |
| page 1 offset 0 |
| 857 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 858 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 00 .....@ ........ |
| 859 |
| 96: 00 00 00 00 0d 00 00 00 01 0f d6 00 0f d6 00 00 ................ |
| 860 |
| 4048: 00 00 00 00 00 00 28 01 06 17 11 11 01 3d 74 61 ......(......=ta |
| 861 |
| 4064: 62 6c 65 74 31 74 31 02 43 52 45 41 54 45 20 54 blet1t1.CREATE T |
| 862 |
| 4080: 41 42 4c 45 20 74 31 28 61 2c 62 2c 63 2c 64 29 ABLE t1(a,b,c,d) |
| 863 |
| page 2 offset 4096 |
| 864 |
| 0: 0d 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 865 |
| end crash-ab10597e4e1c32.db |
| 866 |
}]} {} |
| 867 |
|
| 868 |
do_execsql_test 9.1 { |
| 869 |
SAVEPOINT one; |
| 870 |
} |
| 871 |
do_catchsql_test 9.3 { |
| 872 |
INSERT INTO t1(b,c) VALUES(5,6); |
| 873 |
} {1 {database disk image is malformed}} |
| 874 |
do_execsql_test 9.3 { |
| 875 |
ROLLBACK TO one; |
| 876 |
} |
| 877 |
|
| 878 |
#------------------------------------------------------------------------- |
| 879 |
reset_db |
| 880 |
do_test 10.0 { |
| 881 |
sqlite3 db {} |
| 882 |
db deserialize [decode_hexdb { |
| 883 |
| size 180224 pagesize 4096 filename crash-41390d95d613b6.db |
| 884 |
| page 1 offset 0 |
| 885 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 886 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 00 .....@ ........ |
| 887 |
| 96: 00 00 00 00 0d 00 00 00 04 0e e2 00 0f 96 0f 44 ...............D |
| 888 |
| 112: 0f 10 0e e2 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 889 |
| 3808: 00 00 2c 14 06 17 15 11 01 41 69 6e 64 65 78 74 ..,......Aindext |
| 890 |
| 3824: 41 78 33 74 31 06 43 52 45 41 54 45 20 49 4e 44 Ax3t1.CREATE IND |
| 891 |
| 3840: 45 58 20 74 31 78 32 20 4f 4e 20 74 31 28 62 29 EX t1x2 ON t1(b) |
| 892 |
| 3856: 32 03 06 17 15 11 01 4d 69 6e 64 65 78 74 31 88 2......Mindext1. |
| 893 |
| 3872: 31 74 31 05 43 52 45 41 54 45 20 49 4e 44 45 58 1t1.CREATE INDEX |
| 894 |
| 3888: 20 74 31 78 31 20 4f 4e 20 74 31 28 67 2b 68 2c t1x1 ON t1(g+h, |
| 895 |
| 3904: 6a 2d 6b 29 50 02 06 17 2b 2b 01 59 74 61 62 6c j-k)P...++.Ytabl |
| 896 |
| 3920: 65 73 71 6c 69 74 65 5e 73 65 71 74 65 6e 63 65 esqlite^seqtence |
| 897 |
| 3936: 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 04 sqlite_sequence. |
| 898 |
| 3952: 43 52 45 41 54 45 20 54 41 42 4c 45 20 73 71 6c CREATE TABLE sql |
| 899 |
| 3968: 69 74 65 5f 73 65 71 75 65 6e 63 65 28 6e 61 6d ite_sequence(nam |
| 900 |
| 3984: 65 2c 73 65 71 29 68 00 07 17 11 11 01 81 3b 74 e,seq)h.......;t |
| 901 |
| 4000: 61 62 6c 65 74 31 74 31 03 43 52 45 41 54 45 20 ablet1t1.CREATE |
| 902 |
| 4016: 54 41 42 4c 45 20 74 31 28 61 20 49 4e 54 45 47 TABLE t1(a INTEG |
| 903 |
| 4032: 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 41 ER PRIMARY KEY A |
| 904 |
| 4048: 55 54 4f 49 4e 43 52 45 4d 45 4e 54 2c 0a 62 2c UTOINCREMENT,.b, |
| 905 |
| 4064: 63 2c 64 2c 65 2c 66 2c 67 2c 68 2c 6a 2c 6b 2c c,d,e,f,g,h,j,k, |
| 906 |
| 4080: 6c 2c 6d 2c 6e 2c 6f 2c 70 2c 71 2c 72 2c 73 29 l,m,n,o,p,q,r,s) |
| 907 |
| page 2 offset 4096 |
| 908 |
| 0: 01 00 00 00 00 01 00 00 10 00 01 00 00 00 00 01 ................ |
| 909 |
| 16: 00 00 00 00 02 00 0f f0 00 15 00 00 00 03 02 00 ................ |
| 910 |
| 32: 00 00 d9 05 00 00 00 03 02 00 00 00 00 05 00 00 ................ |
| 911 |
| 48: 10 03 02 00 00 00 00 05 00 00 00 03 02 00 00 00 ................ |
| 912 |
| 64: 00 05 00 00 00 02 62 00 00 00 00 05 00 00 00 03 ......b......... |
| 913 |
| 80: 02 00 00 00 00 05 00 00 00 03 02 00 00 00 00 05 ................ |
| 914 |
| 96: 00 00 00 03 02 00 00 00 00 05 00 00 00 03 05 00 ................ |
| 915 |
| 112: 00 00 03 03 01 00 00 23 02 00 00 4f 00 02 00 00 .......#...O.... |
| 916 |
| 128: 10 25 02 00 00 00 00 03 00 00 00 23 02 00 00 00 .%.........#.... |
| 917 |
| 144: 00 03 00 00 00 23 02 00 00 00 00 03 00 00 00 23 .....#.........# |
| 918 |
| 160: 05 00 08 90 06 05 00 00 00 06 01 ff 00 00 00 03 ................ |
| 919 |
| 176: 00 00 00 06 02 00 00 00 00 02 ff 00 00 00 00 00 ................ |
| 920 |
| page 3 offset 8192 |
| 921 |
| 0: 05 00 00 00 09 0f d0 00 00 00 00 19 0f fb 0f f6 ................ |
| 922 |
| 16: 0f f1 10 ec ec e7 0f e2 0f dc 0f d6 0f 00 00 00 ................ |
| 923 |
| 1072: 00 97 4c 0a 24 00 ae 00 00 00 00 00 00 00 00 00 ..L.$........... |
| 924 |
| 4048: 00 00 00 16 83 39 ff ff ff 14 81 16 00 00 00 12 .....9.......... |
| 925 |
| 4064: 81 02 00 00 00 10 6e 00 00 00 0e 5a 00 00 00 0c ......n....Z.... |
| 926 |
| 4080: 46 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 F............... |
| 927 |
| page 4 offset 12288 |
| 928 |
| 1072: 97 4d 32 14 00 ae 00 00 00 00 00 00 00 00 00 00 .M2............. |
| 929 |
| 4080: 00 00 00 00 00 00 00 07 01 03 11 02 74 31 00 bd ............t1.. |
| 930 |
| page 5 offset 16384 |
| 931 |
| 0: fa 0f 7c 00 0a 0f 74 00 0f f9 0f eb 0f dd 0f cf ..|...t......... |
| 932 |
| 16: 0f c1 0f b3 0f a4 0e 94 0f 84 0f 74 0f 74 0f 74 ...........t.t.t |
| 933 |
| 32: 0f 74 0f 64 0f 00 00 00 00 00 00 00 00 00 00 00 .t.d............ |
| 934 |
| 3952: 00 00 00 00 07 05 00 00 00 02 00 be 0f 8c 10 07 ................ |
| 935 |
| 3968: ff ff 00 00 07 05 00 00 00 02 00 aa 0f 9b f0 08 ................ |
| 936 |
| 3984: c8 00 00 00 37 06 00 00 00 01 00 96 0f ac 00 08 ....7........... |
| 937 |
| 4000: 00 00 00 b3 07 15 00 10 00 02 00 82 0f ba 00 07 ................ |
| 938 |
| 4016: 00 00 00 06 05 00 00 00 01 6e 0f c8 00 07 00 00 .........n...... |
| 939 |
| 4032: 00 06 05 00 00 00 01 5a 03 f6 00 07 00 00 00 06 .......Z........ |
| 940 |
| 4048: 05 00 00 00 01 46 0f e4 00 07 00 00 10 06 05 00 .....F.......... |
| 941 |
| 4064: 00 00 01 32 10 02 00 07 00 00 00 07 05 00 00 00 ...2............ |
| 942 |
| 4080: 01 1d ff ff ff 07 10 00 00 06 05 00 00 00 01 0a ................ |
| 943 |
| page 6 offset 20480 |
| 944 |
| 624: 00 00 00 00 00 21 97 00 00 00 00 00 00 00 00 00 .....!.......... |
| 945 |
| 1120: 00 00 00 00 00 24 57 3e 00 00 00 00 00 00 00 00 .....$W>........ |
| 946 |
| 1616: 00 00 00 00 1f 97 00 00 00 00 00 00 00 00 00 00 ................ |
| 947 |
| 2112: 00 00 00 1e 97 3d 00 00 00 00 00 00 00 00 00 00 .....=.......... |
| 948 |
| 2608: 00 1d 97 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 949 |
| page 8 offset 28672 |
| 950 |
| 1184: 00 00 00 00 00 00 00 00 00 97 4d 1e 13 ff ae 7c ..........M....| |
| 951 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 90 ................ |
| 952 |
| page 9 offset 32768 |
| 953 |
| 256: 0d 01 c0 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 954 |
| page 10 offset 36864 |
| 955 |
| 0: 0d 00 22 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 956 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 05 ................ |
| 957 |
| page 12 offset 45056 |
| 958 |
| 0: 0d 00 00 00 01 04 30 00 00 00 00 00 00 00 00 00 ......0......... |
| 959 |
| page 14 offset 53248 |
| 960 |
| 0: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 961 |
| 1072: 96 4d 5a 14 00 00 00 00 00 00 00 00 00 00 00 00 .MZ............. |
| 962 |
| page 16 offset 61440 |
| 963 |
| 0: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 964 |
| 1072: 97 4d 6e 14 00 ae 7b ff ff ff ff 00 00 00 00 00 .Mn............. |
| 965 |
| page 18 offset 69632 |
| 966 |
| 1056: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 97 ................ |
| 967 |
| 1072: 4d 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 M............... |
| 968 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0d ................ |
| 969 |
| page 20 offset 77824 |
| 970 |
| 1056: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 97 ................ |
| 971 |
| 1072: 4d 81 16 14 00 ae 00 00 00 00 00 00 00 00 00 00 M............... |
| 972 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0f ................ |
| 973 |
| page 22 offset 86016 |
| 974 |
| 0: 0d 00 00 00 01 04 2f 00 04 2f 01 00 00 00 00 00 ....../../...... |
| 975 |
| 1056: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 97 ................ |
| 976 |
| 1072: 4d 81 2a 14 00 00 00 00 00 00 00 00 00 00 00 00 M.*............. |
| 977 |
| page 24 offset 94208 |
| 978 |
| 1072: 00 97 4c 0a 14 00 ae 7c 00 00 00 00 00 00 00 00 ..L....|........ |
| 979 |
| page 25 offset 98304 |
| 980 |
| 1056: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 97 ................ |
| 981 |
| 1072: 4d 81 3e 14 00 ae 7c 00 00 18 ff 00 00 00 00 00 M.>...|......... |
| 982 |
| page 27 offset 106496 |
| 983 |
| 0: 00 00 00 00 00 00 00 12 00 00 00 07 00 00 00 1d ................ |
| 984 |
| 16: 00 00 00 09 00 00 00 1f 00 00 00 0b 00 00 00 21 ...............! |
| 985 |
| 32: 00 00 00 0d 00 10 00 25 00 00 00 0f 00 00 00 27 .......%.......' |
| 986 |
| 48: 00 00 00 11 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 987 |
| page 32 offset 126976 |
| 988 |
| 2512: 00 00 00 00 00 00 00 45 21 00 00 00 00 00 00 00 .......E!....... |
| 989 |
| page 35 offset 139264 |
| 990 |
| 0: 00 0a 08 44 00 05 02 77 00 0e 11 0a 92 00 00 00 ...D...w........ |
| 991 |
| 1120: 00 00 00 00 00 20 97 00 00 00 00 00 00 00 00 00 ..... .......... |
| 992 |
| 1616: 00 00 00 00 22 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 993 |
| 2608: 00 00 00 97 3d 04 00 00 00 00 00 00 00 00 00 00 ....=........... |
| 994 |
| 3104: 00 1c 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 995 |
| 3600: 00 97 3d 04 ae 7c 00 00 00 00 00 00 00 00 00 00 ..=..|.......... |
| 996 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 1a ................ |
| 997 |
| page 36 offset 143360 |
| 998 |
| 0: 0a 08 44 00 04 02 00 00 00 00 00 00 00 00 00 00 ..D............. |
| 999 |
| 1120: 00 00 00 00 00 2a 97 3e 04 00 00 00 00 00 00 00 .....*.>........ |
| 1000 |
| 1616: 00 00 00 00 2c 97 3e 00 00 00 00 00 00 00 00 00 ....,.>......... |
| 1001 |
| 2112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 38 ...............8 |
| 1002 |
| 2128: 00 00 05 cd 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 1003 |
| 3600: 00 97 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 1004 |
| page 38 offset 151552 |
| 1005 |
| 2464: 00 00 00 00 00 00 00 00 00 6e 00 00 00 00 00 00 .........n...... |
| 1006 |
| page 40 offset 159744 |
| 1007 |
| 2512: 00 00 00 00 00 00 00 00 82 00 00 00 00 00 00 00 ................ |
| 1008 |
| page 42 offset 167936 |
| 1009 |
| 2512: 00 00 00 00 00 00 00 96 00 00 00 00 00 00 00 00 ................ |
| 1010 |
| page 44 offset 176128 |
| 1011 |
| 2512: 00 00 00 00 00 00 00 00 aa 00 00 00 00 00 00 00 ................ |
| 1012 |
| end crash-41390d95d613b6.db |
| 1013 |
}]} {} |
| 1014 |
|
| 1015 |
do_catchsql_test 10.1 { |
| 1016 |
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking |
| 1017 |
SELECT * FROM t1 WHERE a<='2019-05-09' ORDER BY a DESC; |
| 1018 |
} {1 {database disk image is malformed}} |
| 1019 |
|
| 1020 |
|
| 1021 |
#------------------------------------------------------------------------- |
| 1022 |
reset_db |
| 1023 |
do_test 11.0 { |
| 1024 |
sqlite3 db {} |
| 1025 |
db deserialize [decode_hexdb { |
| 1026 |
| size 595 pagesize 512 filename x.db |
| 1027 |
| page 1 offset 0 |
| 1028 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 1029 |
| 16: 02 00 00 01 00 40 20 20 00 01 00 0c 00 00 00 07 .....@ ........ |
| 1030 |
| 32: 00 00 00 05 07 a1 1f fa 00 00 00 08 00 00 00 04 ................ |
| 1031 |
| 48: 00 00 01 00 00 49 00 00 00 00 00 05 00 00 00 00 .....I.......... |
| 1032 |
| 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 1c ................ |
| 1033 |
| 96: 00 2e 2c 50 0d 00 00 00 06 01 06 00 01 da 01 b0 ..,P............ |
| 1034 |
| 112: 01 56 01 86 01 2a 01 06 00 00 62 00 00 00 00 00 .V...*....b..... |
| 1035 |
| 128: 00 ed e2 78 74 64 33 ff 43 52 45 41 54 45 20 49 ...xtd3.CREATE I |
| 1036 |
| 144: 4e 44 45 58 20 74 33 78 20 4f 4e 20 74 33 28 38 NDEX t3x ON t3(8 |
| 1037 |
| 160: 29 2e 04 06 17 15 11 01 45 69 6e 64 65 68 74 32 ).......Eindeht2 |
| 1038 |
| 176: 63 64 74 31 e5 43 52 45 41 54 45 20 49 4e 44 45 cdt1.CREATE INDE |
| 1039 |
| 192: 58 20 74 32 63 c4 20 4f 4e 20 74 32 28 63 2c 64 X t2c. ON t2(c,d |
| 1040 |
| 208: 29 28 05 06 17 01 11 11 3d 74 61 6c 36 74 62 74 )(......=tal6tbt |
| 1041 |
| 224: 65 32 04 43 52 45 41 54 45 20 54 41 42 4c 45 20 e2.CREATE TABLE |
| 1042 |
| 240: 74 00 04 00 00 00 00 00 00 00 00 00 00 00 00 00 t............... |
| 1043 |
| 256: 00 00 00 00 00 00 22 07 06 17 11 11 01 30 e8 03 .............0.. |
| 1044 |
| 272: 62 6c 65 74 34 74 35 02 43 52 45 41 54 45 20 54 blet4t5.CREATE T |
| 1045 |
| 288: 41 42 4c 45 20 74 34 28 94 29 2a 06 06 17 13 11 ABLE t4(.)*..... |
| 1046 |
| 304: 01 3f 69 33 74 6e 65 78 78 74 64 33 ff 43 52 45 .?i3tnexxtd3.CRE |
| 1047 |
| 320: 41 54 45 20 49 4e 44 45 58 20 74 33 78 20 4f 4e ATE INDEX t3x ON |
| 1048 |
| 336: 20 74 31 28 38 29 2e 04 06 17 15 11 01 45 69 6e t1(8).......Ein |
| 1049 |
| 352: 64 65 68 74 32 63 64 74 31 e5 43 52 45 41 54 45 deht2cdt1.CREATE |
| 1050 |
| 368: 20 49 4e 44 45 58 20 74 32 63 c4 20 4f 4e 20 74 INDEX t2c. ON t |
| 1051 |
| 384: 32 28 63 2c 64 29 28 05 06 17 01 11 11 3d 74 61 2(c,d)(......=ta |
| 1052 |
| 400: 6c 32 74 62 74 65 32 04 43 52 45 41 54 45 20 54 l2tbte2.CREATE T |
| 1053 |
| 416: 41 42 4c 45 20 74 33 28 63 2c 78 2c 65 2c 66 29 ABLE t3(c,x,e,f) |
| 1054 |
| 432: 28 02 06 17 11 11 01 3d 74 61 9e 93 65 74 32 74 (......=ta..et2t |
| 1055 |
| 448: 32 03 43 52 45 41 54 45 20 54 41 42 4c 45 20 74 2.CREATE TABLE t |
| 1056 |
| 464: 32 28 63 2c 64 2c 65 2c 66 29 24 01 06 17 11 11 2(c,d,e,f)$..... |
| 1057 |
| 480: 01 35 55 61 62 6c 88 74 31 74 31 02 43 52 45 41 .5Uabl.t1t1.CREA |
| 1058 |
| 496: 54 45 20 54 41 42 4c 45 20 74 31 28 61 2c 62 29 TE TABLE t1(a,b) |
| 1059 |
| page 2 offset 512 |
| 1060 |
| 0: 0d 00 00 00 0d 25 00 01 cf 00 01 fa 01 f3 01 de .....%.......... |
| 1061 |
| 16: 01 00 00 00 fd 00 00 0d 00 00 00 00 45 20 54 41 ............E TA |
| 1062 |
| 32: 42 4c 45 20 74 34 28 94 29 2a 06 06 17 13 11 01 BLE t4(.)*...... |
| 1063 |
| 48: 3f 69 33 74 6e 65 78 78 74 64 33 ff 43 52 45 a0 ?i3tnexxtd3.CRE. |
| 1064 |
| 64: a0 a0 a0 a0 a0 a0 a0 a0 a0 a0 a0 a0 74 13 11 01 ............t... |
| 1065 |
| 80: 49 45 74 00 00 00 00 00 00 00 00 00 00 00 00 00 IEt............. |
| 1066 |
| end x.db |
| 1067 |
}]} {} |
| 1068 |
|
| 1069 |
do_catchsql_test 11.1 { |
| 1070 |
PRAGMA writable_schema=ON; -- bypass improved sqlite_master consistency checking |
| 1071 |
DELETE FROM t3 WHERE x IN (SELECT x FROM t4); |
| 1072 |
} {1 {database disk image is malformed}} |
| 1073 |
|
| 1074 |
#------------------------------------------------------------------------- |
| 1075 |
reset_db |
| 1076 |
do_test 12.0 { |
| 1077 |
sqlite3 db {} |
| 1078 |
db deserialize [decode_hexdb { |
| 1079 |
| size 12288 pagesize 4096 filename crash-e6d070858a3a85.db |
| 1080 |
| page 1 offset 0 |
| 1081 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 1082 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 00 .....@ ........ |
| 1083 |
| 96: 00 00 00 00 0d 00 00 00 02 0f 8f 00 0f bf 0f 8f ................ |
| 1084 |
| 3968: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 2e ................ |
| 1085 |
| 3984: 02 06 17 15 11 01 45 69 6e 64 65 78 74 31 63 62 ......Eindext1cb |
| 1086 |
| 4000: 74 31 03 43 52 45 41 54 45 20 49 4e 44 45 58 20 t1.CREATE INDEX |
| 1087 |
| 4016: 74 31 63 62 20 4f 4e 20 74 31 28 63 2c 62 29 3f t1cb ON t1(c,b)? |
| 1088 |
| 4032: 01 06 17 11 11 01 6b 74 61 62 6c 65 74 31 74 31 ......ktablet1t1 |
| 1089 |
| 4048: 02 43 52 45 41 54 45 20 54 41 42 4c 45 20 74 31 .CREATE TABLE t1 |
| 1090 |
| 4064: 28 61 20 49 4e 54 2c 20 62 20 49 4e 54 2c 20 43 (a INT, b INT, C |
| 1091 |
| 4080: 20 49 4e 54 20 44 45 46 41 55 4c 54 20 31 36 29 INT DEFAULT 16) |
| 1092 |
| page 2 offset 4096 |
| 1093 |
| 0: 0d 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 1094 |
| 4000: 00 00 00 00 00 00 00 00 07 0b 04 01 01 01 63 63 ..............cc |
| 1095 |
| 4016: 11 05 0a 04 00 00 01 11 05 09 04 08 08 01 0f 05 ................ |
| 1096 |
| 4032: 08 04 00 00 01 01 56 07 04 01 08 01 07 10 07 06 ......V......... |
| 1097 |
| 4048: 14 01 01 01 06 08 10 06 05 04 f5 00 01 05 10 07 ................ |
| 1098 |
| 4064: 04 04 01 01 01 04 03 10 06 03 04 01 09 01 03 10 ................ |
| 1099 |
| 4080: 06 02 04 01 00 01 02 10 06 01 04 09 01 01 02 10 ................ |
| 1100 |
| page 3 offset 8192 |
| 1101 |
| 0: 0a 00 00 00 0b 0f b0 00 0f f9 0f f2 0f eb 0f e4 ................ |
| 1102 |
| 16: 0f dd 0f d6 0f 9f 0f c7 0f be 00 00 00 00 00 00 ................ |
| 1103 |
| 4016: 07 04 01 01 01 11 e2 0b 06 04 91 00 01 11 0a 07 ................ |
| 1104 |
| 4032: 04 01 01 01 10 08 06 07 04 01 01 01 10 04 04 06 ................ |
| 1105 |
| 4048: 04 01 01 09 10 02 06 04 01 0a 01 10 00 00 00 00 ................ |
| 1106 |
| end crash-e6d070858a3a85.db |
| 1107 |
}]} {} |
| 1108 |
|
| 1109 |
do_catchsql_test 12.1 { |
| 1110 |
SELECT CAST((SELECT b FROM t1 WHERE 16=c) AS int) FROM t1 WHERE 16=c; |
| 1111 |
} {1 {database disk image is malformed}} |
| 1112 |
|
| 1113 |
#------------------------------------------------------------------------- |
| 1114 |
reset_db |
| 1115 |
do_test 13.0 { |
| 1116 |
sqlite3 db {} |
| 1117 |
db deserialize [decode_hexdb { |
| 1118 |
| size 8192 pagesize 4096 filename crash-81dd2952aef34f.db |
| 1119 |
| page 1 offset 0 |
| 1120 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 1121 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 02 .....@ ........ |
| 1122 |
| 32: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 04 ................ |
| 1123 |
| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ |
| 1124 |
| 96: 00 00 00 00 0d 00 00 00 01 0f c4 00 0f c4 00 00 ................ |
| 1125 |
| 4032: 00 00 00 00 3a 11 06 17 11 11 01 61 74 61 62 6c ....:......atabl |
| 1126 |
| 4048: 65 74 31 74 31 02 43 52 45 41 54 45 20 54 41 42 et1t1.CREATE TAB |
| 1127 |
| 4064: 4c 45 20 74 31 28 61 20 49 4e 54 45 47 45 52 20 LE t1(a INTEGER |
| 1128 |
| 4080: 50 52 49 4d 41 52 59 20 4b 45 59 2c 62 2c 63 29 PRIMARY KEY,b,c) |
| 1129 |
| page 2 offset 4096 |
| 1130 |
| 0: 0d 07 70 00 02 0f eb 00 0f fa 00 00 00 00 00 00 ..p............. |
| 1131 |
| 4064: 00 00 00 00 00 00 00 00 00 00 00 05 bf ff ff ff ................ |
| 1132 |
| 4080: ff ff ff ff ff 04 00 01 00 02 04 01 00 00 00 00 ................ |
| 1133 |
| end crash-81dd2952aef34f.db |
| 1134 |
}]} {} |
| 1135 |
|
| 1136 |
do_catchsql_test 13.1 { |
| 1137 |
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x-2019 FROM c WHERE x<2) |
| 1138 |
INSERT INTO t1(b,c) SELECT last_insert_rowid(), x FROM c; |
| 1139 |
} {1 {database disk image is malformed}} |
| 1140 |
|
| 1141 |
#------------------------------------------------------------------------- |
| 1142 |
reset_db |
| 1143 |
do_test 14.0 { |
| 1144 |
sqlite3 db {} |
| 1145 |
db deserialize [decode_hexdb { |
| 1146 |
| size 512 pagesize 65536 filename clusterfuzz-testcase-minimized-sqlite3_dbfuzz2_fuzzer-4806406219825152 |
| 1147 |
| page 1 offset 0 |
| 1148 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 1149 |
| 16: 00 01 02 01 00 40 20 20 00 63 2e 78 00 00 00 07 .....@ .c.x.... |
| 1150 |
| 32: 00 00 00 00 00 00 00 00 00 00 00 08 00 00 00 04 ................ |
| 1151 |
| 48: 00 00 00 00 00 00 01 00 35 05 43 00 04 00 00 00 ........5.C..... |
| 1152 |
| 80: 00 00 00 00 00 00 00 00 08 00 00 00 00 00 00 0c ................ |
| 1153 |
| 96: 00 2e 2c 50 0d 00 00 00 03 00 00 00 01 da 01 b0 ..,P............ |
| 1154 |
| 112: 01 56 01 86 01 2a 01 02 00 00 00 00 00 00 00 1c .V...*.......... |
| 1155 |
| 128: 00 38 80 b2 e6 0e 00 00 00 00 00 00 00 00 00 10 .8.............. |
| 1156 |
| 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 ................ |
| 1157 |
| 160: 00 00 00 00 00 00 00 00 00 00 00 00 45 20 54 41 ............E TA |
| 1158 |
| 256: 00 00 00 00 00 00 22 07 06 17 11 11 01 35 74 61 .............5ta |
| 1159 |
| 272: 62 6c 00 10 00 00 34 07 43 52 54 45 20 54 41 42 bl....4.CRTE TAB |
| 1160 |
| 288: 4c 45 20 74 33 28 63 2e 78 2c 65 2c 66 15 28 3a LE t3(c.x,e,f.(: |
| 1161 |
| 304: 06 17 11 11 01 65 78 8c cc 87 85 35 05 43 72 45 .....ex....5.CrE |
| 1162 |
| 320: 41 54 48 20 49 4e 44 45 58 20 74 33 78 20 4f 4e ATH INDEX t3x ON |
| 1163 |
| 336: 20 74 33 28 78 39 2e 04 06 17 15 11 01 45 69 6e t3(x9.......Ein |
| 1164 |
| 352: 64 65 78 74 32 63 64 74 32 05 43 52 45 41 54 45 dext2cdt2.CREATE |
| 1165 |
| 368: 20 49 4e 44 45 58 20 74 32 63 64 20 4f 4e 20 74 INDEX t2cd ON t |
| 1166 |
| 384: 32 28 63 2a 44 29 28 05 fa e8 ee ed 01 3d 74 63 2(c*D)(......=tc |
| 1167 |
| 400: 62 6c 65 74 33 74 33 07 43 52 45 41 54 45 20 54 blet3t3.CREATE T |
| 1168 |
| 416: 41 42 4c 45 20 74 33 28 63 2e 78 2c 65 2c 66 15 ABLE t3(c.x,e,f. |
| 1169 |
| 432: 28 3a 06 17 11 11 01 3d 74 61 62 6c 65 74 32 74 (:.....=tablet2t |
| 1170 |
| 448: 32 03 43 52 45 41 54 45 20 54 41 42 4c 45 20 74 2.CREATE TABLE t |
| 1171 |
| 464: 32 28 63 2c 64 2c 65 2c 66 29 24 01 06 17 11 11 2(c,d,e,f)$..... |
| 1172 |
| 480: 01 35 74 61 62 6c 65 74 31 74 31 02 43 52 45 41 .5tablet1t1.CREA |
| 1173 |
| 496: 54 45 20 54 41 42 4c 45 20 74 31 28 61 2c 63 29 TE TABLE t1(a,c) |
| 1174 |
| end clusterfuzz-testcase-minimized-sqlite3_dbfuzz2_fuzzer-4806406219825152 |
| 1175 |
}]} {} |
| 1176 |
|
| 1177 |
extra_schema_checks 0 |
| 1178 |
do_catchsql_test 14.1 { |
| 1179 |
PRAGMA integrity_check; |
| 1180 |
} {1 {database disk image is malformed}} |
| 1181 |
|
| 1182 |
# If SQLITE_OMIT_ALTERTABLE is defined, omit this file. |
| 1183 |
ifcapable altertable { |
| 1184 |
do_catchsql_test 14.2 { |
| 1185 |
ALTER TABLE t1 RENAME TO alkjalkjdfiiiwuer987lkjwer82mx97sf98788s9789s; |
| 1186 |
} {1 {database disk image is malformed}} |
| 1187 |
} |
| 1188 |
extra_schema_checks 1 |
| 1189 |
|
| 1190 |
#------------------------------------------------------------------------- |
| 1191 |
reset_db |
| 1192 |
do_test 15.0 { |
| 1193 |
sqlite3 db {} |
| 1194 |
db deserialize [decode_hexdb { |
| 1195 |
| size 28672 pagesize 4096 filename crash-3afa1ca9e9c1bd.db |
| 1196 |
| page 1 offset 0 |
| 1197 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 1198 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 07 .....@ ........ |
| 1199 |
| 32: 00 00 00 00 00 00 00 00 00 00 00 06 00 00 00 04 ................ |
| 1200 |
| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ |
| 1201 |
| 96: 00 00 00 00 0d 00 00 00 06 0e 88 00 0f b8 0f 6d ...............m |
| 1202 |
| 112: 0f 3a 0f 0b 0e d5 0e 88 01 00 00 00 00 00 00 00 .:.............. |
| 1203 |
| 3712: 00 00 00 00 00 00 00 00 4b 06 06 17 25 25 01 5b ........K...%%.[ |
| 1204 |
| 3728: 74 61 62 6c 65 73 71 6c 69 74 65 5f 73 74 61 74 tablesqlite_stat |
| 1205 |
| 3744: 31 73 71 6c 69 74 65 5f 73 74 61 74 31 07 43 52 1sqlite_stat1.CR |
| 1206 |
| 3760: 45 41 54 45 20 54 41 42 4c 45 20 73 71 6c 69 74 EATE TABLE sqlit |
| 1207 |
| 3776: 65 5f 73 74 61 74 31 28 74 62 6c 2c 69 64 78 2c e_stat1(tbl,idx, |
| 1208 |
| 3792: 73 74 61 74 29 34 05 06 17 13 11 01 53 69 6e 64 stat)4......Sind |
| 1209 |
| 3808: 65 78 63 31 63 63 31 06 43 52 45 41 54 45 20 55 exc1cc1.CREATE U |
| 1210 |
| 3824: 4e 49 51 55 45 20 49 4e 44 45 58 20 63 31 63 20 NIQUE INDEX c1c |
| 1211 |
| 3840: 4f 4e 20 63 31 28 63 2c 20 62 29 2d 04 06 17 13 ON c1(c, b)-.... |
| 1212 |
| 3856: 11 01 45 69 6e 64 65 78 63 31 64 63 31 05 43 52 ..Eindexc1dc1.CR |
| 1213 |
| 3872: 45 41 54 45 20 49 4e 44 45 58 20 63 31 64 20 4f EATE INDEX c1d O |
| 1214 |
| 3888: 4e 20 63 31 28 64 2c 20 62 29 31 03 06 17 13 11 N c1(d, b)1..... |
| 1215 |
| 3904: 01 4d 69 6e 64 65 78 62 31 63 62 31 05 43 52 45 .Mindexb1cb1.CRE |
| 1216 |
| 3920: 41 54 45 20 55 4e 49 51 55 45 20 49 4e 44 45 58 ATE UNIQUE INDEX |
| 1217 |
| 3936: 20 62 31 63 20 4f 4e 20 62 31 28 63 29 49 02 06 b1c ON b1(c)I.. |
| 1218 |
| 3952: 17 11 11 0f 7f 74 61 62 6c 65 63 31 63 31 03 43 .....tablec1c1.C |
| 1219 |
| 3968: 52 45 41 54 45 20 54 41 42 4c 45 20 63 31 28 61 REATE TABLE c1(a |
| 1220 |
| 3984: 20 49 4e 54 20 50 52 49 4d 41 52 59 20 4b 45 59 INT PRIMARY KEY |
| 1221 |
| 4000: 2c 20 62 2c 20 63 2c 20 64 29 20 57 49 54 48 4f , b, c, d) WITHO |
| 1222 |
| 4016: 55 54 20 52 4f 57 49 44 46 01 06 17 11 11 01 79 UT ROWIDF......y |
| 1223 |
| 4032: 74 61 62 6c 65 62 31 62 31 02 43 52 45 41 54 45 tableb1b1.CREATE |
| 1224 |
| 4048: 20 54 41 42 4c 45 20 62 31 28 61 20 49 4e 54 20 TABLE b1(a INT |
| 1225 |
| 4064: 50 52 49 4d 41 52 59 20 4b 45 59 2c 20 62 2c 20 PRIMARY KEY, b, |
| 1226 |
| 4080: 63 29 20 57 49 54 48 4f 55 54 20 52 4f 57 49 44 c) WITHOUT ROWID |
| 1227 |
| page 2 offset 4096 |
| 1228 |
| 0: 0a 00 00 00 07 0f ca 00 0f fa 0f f2 0f ea 0f e2 ................ |
| 1229 |
| 16: 0f da 00 00 00 01 00 00 00 00 00 00 00 00 00 00 ................ |
| 1230 |
| 4032: 00 00 00 00 00 00 00 00 00 00 07 04 01 0f 01 06 ................ |
| 1231 |
| 4048: 67 07 07 04 01 0f 01 06 66 06 07 04 01 0f 01 05 g.......f....... |
| 1232 |
| 4064: 65 05 07 04 01 0f 01 04 64 04 07 04 01 0f 01 03 e.......d....... |
| 1233 |
| 4080: 63 03 07 04 01 0f 01 02 62 0f 05 04 09 0f 09 61 c.......b......a |
| 1234 |
| page 3 offset 8192 |
| 1235 |
| 0: 0a 00 00 00 07 0f bd 00 0f f9 0f ef 0f e5 0f db ................ |
| 1236 |
| 16: 0f d1 0f c7 0f bd 00 00 00 00 01 00 00 00 00 00 ................ |
| 1237 |
| 4016: 00 00 00 00 00 00 00 00 00 00 00 00 00 09 05 01 ................ |
| 1238 |
| 4032: 0f 01 01 07 61 07 07 09 05 01 0f 01 01 06 61 06 ....a.........a. |
| 1239 |
| 4048: 06 09 05 01 0f 01 01 05 61 05 05 09 05 01 0f 01 ........a....... |
| 1240 |
| 4064: 01 04 61 04 04 09 05 01 0f 01 01 03 61 03 03 09 ..a.........a... |
| 1241 |
| 4080: 05 01 0f 01 01 02 61 0f 02 06 05 09 0f 09 09 61 ......a........a |
| 1242 |
| page 4 offset 12288 |
| 1243 |
| 0: 0a 00 00 00 07 0f d8 00 0f fc 0f f0 0f ea 0f e4 ................ |
| 1244 |
| 16: 0f de 0f d8 0f f6 00 00 00 00 00 00 00 00 00 00 ................ |
| 1245 |
| 4048: 00 00 00 00 00 00 00 00 05 03 01 01 07 07 05 03 ................ |
| 1246 |
| 4064: 01 01 06 06 05 03 01 01 05 05 05 03 01 01 04 04 ................ |
| 1247 |
| 4080: 05 03 01 01 03 03 05 03 01 01 0f 02 03 03 09 09 ................ |
| 1248 |
| page 5 offset 16384 |
| 1249 |
| 0: 0a 00 00 00 07 0f ca 00 0f fa 0f f2 0f ea 0f 00 ................ |
| 1250 |
| 4032: 00 00 00 00 00 00 00 00 00 00 07 04 01 0f 01 07 ................ |
| 1251 |
| 4048: 61 07 07 04 01 0f 01 06 61 06 07 04 01 0f 01 05 a.......a....... |
| 1252 |
| 4064: 61 05 07 04 01 1f 01 04 61 04 07 04 01 0f 01 03 a.......a....... |
| 1253 |
| 4080: 61 03 07 04 01 0f 01 02 61 02 05 04 09 0f 09 61 a.......a......a |
| 1254 |
| page 6 offset 20480 |
| 1255 |
| 0: 0a 00 00 00 07 0f ca 00 0f fa 0f ea 0f e2 00 00 ................ |
| 1256 |
| 4032: 00 00 00 00 00 00 00 00 00 00 07 04 01 0f 01 07 ................ |
| 1257 |
| 4048: 61 07 07 04 01 0f 01 06 61 06 07 04 01 0f 01 05 a.......a....... |
| 1258 |
| 4064: 61 05 07 04 01 0f 01 04 61 04 07 04 01 0f 01 03 a.......a....... |
| 1259 |
| 4080: 61 03 07 04 01 0f 01 0f 61 02 05 04 09 0f 09 61 a.......a......a |
| 1260 |
| page 7 offset 24576 |
| 1261 |
| 0: 0d 00 00 00 05 0f 1c 00 0f f0 0f e0 0f d3 0f c5 ................ |
| 1262 |
| 16: 0f b8 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 1263 |
| 4016: 00 00 00 00 00 00 00 00 0b 05 04 11 11 13 62 31 ..............b1 |
| 1264 |
| 4032: 62 31 37 20 31 0c 04 04 11 13 13 62 31 62 31 63 b17 1......b1b1c |
| 1265 |
| 4048: 37 20 31 0b 03 04 11 11 13 63 31 63 31 37 20 31 7 1......c1c17 1 |
| 1266 |
| 4064: 0e 02 04 11 13 07 63 31 63 31 64 37 20 31 20 31 ......c1c1d7 1 1 |
| 1267 |
| 4080: 0e 01 04 11 13 17 63 31 63 31 63 37 20 31 00 00 ......c1c1c7 1.. |
| 1268 |
| end crash-3afa1ca9e9c1bd.db |
| 1269 |
}]} {} |
| 1270 |
|
| 1271 |
extra_schema_checks 0 |
| 1272 |
optimization_control db one-pass off |
| 1273 |
do_catchsql_test 15.1 { |
| 1274 |
PRAGMA cell_size_check = 0; |
| 1275 |
UPDATE c1 SET c= NOT EXISTS(SELECT 1 FROM c1 ORDER BY (SELECT 1 FROM c1 ORDER BY a)) +10 WHERE d BETWEEN 4 AND 7; |
| 1276 |
} {1 {database disk image is malformed}} |
| 1277 |
extra_schema_checks 1 |
| 1278 |
do_execsql_test 15.2 { |
| 1279 |
PRAGMA integrity_check; |
| 1280 |
} {/in database main/} |
| 1281 |
|
| 1282 |
#------------------------------------------------------------------------- |
| 1283 |
reset_db |
| 1284 |
do_execsql_test 16.0 { |
| 1285 |
CREATE TABLE t1(w, x, y, z, UNIQUE(w, x), UNIQUE(y, z)); |
| 1286 |
INSERT INTO t1 VALUES(1, 1, 1, 1); |
| 1287 |
|
| 1288 |
CREATE TABLE t1idx(x, y, i INTEGER, PRIMARY KEY(x)) WITHOUT ROWID; |
| 1289 |
INSERT INTO t1idx VALUES(10, NULL, 5); |
| 1290 |
|
| 1291 |
PRAGMA writable_schema = 1; |
| 1292 |
UPDATE sqlite_master SET rootpage = ( |
| 1293 |
SELECT rootpage FROM sqlite_master WHERE name='t1idx' |
| 1294 |
) WHERE type = 'index'; |
| 1295 |
} |
| 1296 |
|
| 1297 |
extra_schema_checks 0 |
| 1298 |
db close |
| 1299 |
sqlite3 db test.db |
| 1300 |
extra_schema_checks 1 |
| 1301 |
|
| 1302 |
do_catchsql_test 16.1 { |
| 1303 |
PRAGMA writable_schema = ON; |
| 1304 |
INSERT INTO t1(rowid, w, x, y, z) VALUES(5, 10, 11, 10, NULL); |
| 1305 |
} {1 {database disk image is malformed}} |
| 1306 |
|
| 1307 |
#------------------------------------------------------------------------- |
| 1308 |
# Test that corruption is reported from within a checkpoint if the |
| 1309 |
# expected final size of the database (according to the last commit |
| 1310 |
# frame in the wal file) is greater than the combined initial sizes |
| 1311 |
# of the database and wal file. |
| 1312 |
# |
| 1313 |
if {[wal_is_capable]} { |
| 1314 |
reset_db |
| 1315 |
do_execsql_test 17.0 { |
| 1316 |
CREATE TABLE t1(o INTEGER PRIMARY KEY, t UNIQUE); |
| 1317 |
INSERT INTO t1(t) VALUES(randomblob(123)); |
| 1318 |
INSERT INTO t1(t) SELECT randomblob(123) FROM t1; |
| 1319 |
INSERT INTO t1(t) SELECT randomblob(123) FROM t1; |
| 1320 |
INSERT INTO t1(t) SELECT randomblob(123) FROM t1; |
| 1321 |
INSERT INTO t1(t) SELECT randomblob(123) FROM t1; |
| 1322 |
INSERT INTO t1(t) SELECT randomblob(123) FROM t1; |
| 1323 |
INSERT INTO t1(t) SELECT randomblob(123) FROM t1; |
| 1324 |
INSERT INTO t1(t) SELECT randomblob(123) FROM t1; |
| 1325 |
INSERT INTO t1(t) SELECT randomblob(123) FROM t1; |
| 1326 |
INSERT INTO t1(t) SELECT randomblob(123) FROM t1; |
| 1327 |
|
| 1328 |
PRAGMA journal_mode = wal; |
| 1329 |
INSERT INTO t1 VALUES(-1, 'b'); |
| 1330 |
} {wal} |
| 1331 |
|
| 1332 |
do_test 17.1 { |
| 1333 |
set fd [open test.db r+] |
| 1334 |
chan truncate $fd 2048 |
| 1335 |
file size test.db |
| 1336 |
} {2048} |
| 1337 |
|
| 1338 |
do_catchsql_test 17.2 { |
| 1339 |
PRAGMA wal_checkpoint |
| 1340 |
} {1 {database disk image is malformed}} |
| 1341 |
|
| 1342 |
do_test 17.3 { |
| 1343 |
close $fd |
| 1344 |
} {} |
| 1345 |
} |
| 1346 |
|
| 1347 |
#------------------------------------------------------------------------- |
| 1348 |
reset_db |
| 1349 |
do_test 18.0 { |
| 1350 |
sqlite3 db {} |
| 1351 |
db deserialize [decode_hexdb { |
| 1352 |
.open --hexdb |
| 1353 |
| size 12288 pagesize 4096 filename crash-40d5739835cbdb.db |
| 1354 |
| page 1 offset 0 |
| 1355 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 1356 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 00 .....@ ........ |
| 1357 |
| 96: 00 00 00 00 0d 00 00 00 02 0f 4e 00 0f a2 0f 4e ..........N....N |
| 1358 |
| 3904: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 52 02 ..............R. |
| 1359 |
| 3920: 07 17 11 11 01 81 0f 74 61 62 6c 65 74 32 74 32 .......tablet2t2 |
| 1360 |
| 3936: 03 43 52 45 41 54 45 20 54 41 42 4c 45 20 74 32 .CREATE TABLE t2 |
| 1361 |
| 3952: 28 61 20 49 4e 54 2c 20 62 20 49 4e 54 45 47 45 (a INT, b INTEGE |
| 1362 |
| 3968: 52 2c 20 50 52 49 4d 41 52 59 20 4b 45 59 28 61 R, PRIMARY KEY(a |
| 1363 |
| 3984: 2c 62 29 29 20 57 49 54 48 4f 55 54 20 52 4f 57 ,b)) WITHOUT ROW |
| 1364 |
| 4000: 49 44 5c 01 07 16 11 11 01 81 23 74 61 62 6c 65 ID........#table |
| 1365 |
| 4016: 74 31 74 31 02 43 52 45 41 54 45 20 54 41 42 4c t1t1.CREATE TABL |
| 1366 |
| 4032: 45 20 74 31 28 61 20 49 4e 54 20 50 52 49 4d 41 E t1(a INT PRIMA |
| 1367 |
| 4048: 52 59 20 4b 45 59 2c 20 62 20 54 45 58 54 2c 20 RY KEY, b TEXT, |
| 1368 |
| 4064: 63 20 54 45 58 54 2c 20 64 20 49 4e 54 45 47 45 c TEXT, d INTEGE |
| 1369 |
| 4080: 52 29 20 57 49 54 48 4f 55 54 20 52 4f 57 49 44 R) WITHOUT ROWID |
| 1370 |
| page 2 offset 4096 |
| 1371 |
| 0: 0a 00 00 00 06 0f a7 00 0f f4 0f e5 0f d5 0f c5 ................ |
| 1372 |
| 16: 0f b6 0f 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 1373 |
| 4000: 00 00 00 00 00 00 00 0f 05 01 15 13 01 06 65 7f ..............e. |
| 1374 |
| 4016: 25 6e 73 69 78 06 0e 05 01 13 15 03 b5 6f 64 64 %nsix........odd |
| 1375 |
| 4032: 66 69 76 65 05 0f 05 01 15 15 01 04 65 76 65 61 five........evea |
| 1376 |
| 4048: e6 6f 75 82 04 0f 05 01 13 17 01 03 6f 64 64 74 .ou.........oddt |
| 1377 |
| 4064: 68 72 61 15 03 0e 05 01 15 12 01 02 64 76 64 6e hra.........dvdn |
| 1378 |
| 4080: 74 77 6f 02 00 00 00 00 00 00 00 00 00 00 00 00 two............. |
| 1379 |
| page 3 offset 8192 |
| 1380 |
| 2816: 00 00 00 00 00 00 00 00 00 00 00 06 03 02 01 00 ................ |
| 1381 |
| 2832: c8 07 06 03 02 01 00 c7 11 06 03 02 01 02 a6 52 ...............R |
| 1382 |
| 2848: 06 d5 02 01 10 c5 1b 06 03 02 00 ef c4 53 06 03 .............S.. |
| 1383 |
| 2864: 02 01 00 c3 22 06 04 02 01 00 c2 26 06 03 02 01 ...........&.... |
| 1384 |
| 2880: 00 c2 1e 02 b3 02 01 00 c0 3a 06 03 3c 01 00 bf .........:..<... |
| 1385 |
| 2896: 2c 06 03 02 01 00 be 27 00 83 02 01 01 bd 15 06 ,......'........ |
| 1386 |
| 2912: 03 02 01 00 bc 21 06 03 02 01 00 bb 54 16 13 02 .....!......T... |
| 1387 |
| 2928: 01 09 9a 0a 06 03 02 01 00 b9 53 06 03 02 01 00 ..........S..... |
| 1388 |
| 2944: b8 52 06 13 02 01 00 b7 1e 06 03 02 01 00 b6 34 .R.............4 |
| 1389 |
| 2960: 06 13 02 01 00 b5 3a 05 f3 12 01 00 b4 45 05 03 ......:......E.. |
| 1390 |
| 2976: 02 00 00 b4 6f 06 03 02 01 00 b2 03 06 03 02 01 ....o........... |
| 1391 |
| 2992: 00 b1 63 06 03 02 01 00 b0 24 06 03 02 01 00 9f ..c......$...... |
| 1392 |
| 3008: ac 06 03 02 01 00 a2 2f 07 03 02 01 01 ad 21 06 ......./......!. |
| 1393 |
| 3024: 03 02 01 fb cd 5b 06 c0 01 f1 00 ab 23 06 03 02 .....[......#... |
| 1394 |
| 3040: 01 00 aa 5b 06 03 02 01 00 a3 ce 06 02 03 01 00 ...[............ |
| 1395 |
| 3056: a8 0e 06 03 02 01 00 a7 0c 06 02 f1 01 00 a6 0d ................ |
| 1396 |
| 3072: 06 03 02 01 00 95 25 06 03 02 01 00 a4 17 06 03 ......%......... |
| 1397 |
| 3088: 02 01 00 a3 09 06 03 02 01 00 a2 51 06 03 02 02 ...........Q.... |
| 1398 |
| 3104: 00 a1 40 06 01 e2 00 00 a0 4b 06 13 02 00 00 9e [email protected]...... |
| 1399 |
| 3120: 5d 06 03 02 01 10 9e 81 06 03 02 01 00 9d 42 06 ].............B. |
| 1400 |
| 3136: 03 69 01 00 9c 48 06 03 02 01 00 9b 48 06 03 01 .i...H......H... |
| 1401 |
| 3152: 01 00 9a 09 06 03 02 01 00 99 2f 06 03 02 01 00 ........../..... |
| 1402 |
| 3168: 98 3a 06 03 02 01 00 97 24 06 03 02 01 00 96 4a .:......$......J |
| 1403 |
| 3184: 06 03 02 11 00 f9 50 02 93 02 01 00 94 2f 06 03 ......P....../.. |
| 1404 |
| 3200: 02 11 04 93 1a 06 03 01 04 e0 92 1a 06 03 02 01 ................ |
| 1405 |
| 3216: 00 91 27 06 03 02 01 00 90 23 06 03 02 01 00 8f ..'......#...... |
| 1406 |
| 3232: 3b 06 03 02 01 00 8e 46 06 16 02 01 00 8d 1d 07 ;......F........ |
| 1407 |
| 3248: 23 12 01 00 8c 5a 06 03 02 01 00 8a 39 06 03 02 #....Z......9... |
| 1408 |
| 3264: 00 ff 84 b5 06 03 02 01 00 89 07 06 03 02 11 00 ................ |
| 1409 |
| 3280: 88 02 06 03 02 01 00 87 19 06 03 02 01 00 86 4d ...............M |
| 1410 |
| 3296: 06 13 12 00 00 85 4b 06 03 02 01 00 84 37 06 13 ......K......7.. |
| 1411 |
| 3312: 02 01 00 83 2c 06 03 02 01 00 81 60 06 13 02 11 ....,......`.... |
| 1412 |
| 3328: 00 81 3b 06 03 02 01 0a b0 5a 06 03 01 01 7f 22 ..;......Z...... |
| 1413 |
| 3344: 05 03 01 01 7e 21 05 03 01 01 7d 0b 15 03 01 02 ....~!.......... |
| 1414 |
| 3360: 7b 08 05 03 06 91 7b 22 05 03 01 01 7a 58 05 03 ............zX.. |
| 1415 |
| 3376: 01 01 7a 4f 05 03 01 01 78 49 05 03 01 01 77 16 ..zO....xI....w. |
| 1416 |
| 3392: 05 03 01 01 76 5f 05 03 01 01 75 0f 05 03 01 01 ....v_....u..... |
| 1417 |
| 3408: 74 2f 05 03 01 01 3f 1f 05 03 01 02 72 14 05 03 t/....?.....r... |
| 1418 |
| 3424: 00 f1 71 08 05 03 01 01 70 0c 05 03 01 47 7f 29 ..q.....p....G.) |
| 1419 |
| 3440: 05 03 01 01 6e 57 05 03 01 01 6d 33 05 13 00 f1 ....nW....m3.... |
| 1420 |
| 3456: 6c 0b 05 03 01 01 6b 49 05 03 01 01 69 05 05 03 l.....kI....i... |
| 1421 |
| 3472: 01 02 ed 23 00 00 01 00 00 00 00 00 00 00 00 00 ...#............ |
| 1422 |
| end crash-40d5739835cbdb.db |
| 1423 |
}]} {} |
| 1424 |
|
| 1425 |
ifcapable json1 { |
| 1426 |
do_catchsql_test 18.1 { |
| 1427 |
SELECT |
| 1428 |
json_group_array(c) OVER win4 |
| 1429 |
FROM t1 |
| 1430 |
WINDOW win4 AS ( |
| 1431 |
ORDER BY a COLLATE nocase RANGE BETWEEN 1.0 PRECEDING AND CURRENT ROW |
| 1432 |
) |
| 1433 |
} {1 {JSON cannot hold BLOB values}} |
| 1434 |
} ;# ifcapable json1 |
| 1435 |
|
| 1436 |
#------------------------------------------------------------------------- |
| 1437 |
reset_db |
| 1438 |
do_test 19.0 { |
| 1439 |
sqlite3 db {} |
| 1440 |
db deserialize [decode_hexdb { |
| 1441 |
.open --hexdb |
| 1442 |
| size 20480 pagesize 4096 filename crash-f022eb0ce64d27.db |
| 1443 |
| page 1 offset 0 |
| 1444 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 1445 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 05 .....@ ........ |
| 1446 |
| 32: 00 00 00 00 00 00 00 00 00 00 00 02 00 00 00 04 ................ |
| 1447 |
| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ |
| 1448 |
| 96: 00 00 00 00 0d 0f f8 00 04 0e d2 00 0f 08 0f d3 ................ |
| 1449 |
| 112: 0f ae 0e d2 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 1450 |
| 3792: 00 00 34 04 06 17 0f 11 01 57 69 6e 64 65 78 61 ..4......Windexa |
| 1451 |
| 3808: 74 31 05 43 52 45 41 54 45 20 55 4e 49 51 55 45 t1.CREATE UNIQUE |
| 1452 |
| 3824: 20 49 4e 44 45 58 20 61 20 4f 4e 20 74 31 28 61 INDEX a ON t1(a |
| 1453 |
| 3840: 2c 20 30 20 7c 20 61 29 81 23 01 07 17 11 11 01 , 0 | a).#...... |
| 1454 |
| 3856: 82 31 74 61 62 6c 65 74 31 74 31 02 43 52 45 41 .1tablet1t1.CREA |
| 1455 |
| 3872: 54 45 20 54 41 42 4c 45 20 74 31 28 0a 20 20 20 TE TABLE t1(. |
| 1456 |
| 3888: 20 67 63 62 20 41 53 20 28 62 2a 31 29 2c 0a 20 gcb AS (b*1),. |
| 1457 |
| 3904: 20 20 20 61 20 49 34 54 45 47 45 52 20 50 52 49 a I4TEGER PRI |
| 1458 |
| 3920: 4d 41 52 59 20 4b 45 59 2c 0a 20 20 20 20 67 63 MARY KEY,. gc |
| 1459 |
| 3936: 63 20 41 53 20 28 74 32 2b 30 29 2c 0a 20 20 20 c AS (t2+0),. |
| 1460 |
| 3952: 20 62 20 55 4e 49 51 55 45 2c 0a 20 20 20 20 67 b UNIQUE,. g |
| 1461 |
| 3968: 63 61 20 41 53 20 28 31 2a 61 2b 30 29 2c 0a 20 ca AS (1*a+0),. |
| 1462 |
| 3984: 20 20 20 74 32 20 55 4e 49 51 55 45 0a 20 20 29 t2 UNIQUE. ) |
| 1463 |
| 4000: 20 57 49 54 48 4f 55 54 20 52 4f 57 49 44 23 03 WITHOUT ROWID#. |
| 1464 |
| 4016: 06 17 37 11 01 00 69 6e 64 65 78 73 71 6c 69 74 ..7...indexsqlit |
| 1465 |
| 4032: 65 5f 61 75 74 6f 69 6e 64 65 78 5f 74 31 5f 33 e_autoindex_t1_3 |
| 1466 |
| 4048: 74 31 02 23 02 06 17 37 11 01 00 69 6e 64 65 78 t1.#...7...index |
| 1467 |
| 4064: 73 71 6c 69 74 65 5f 61 75 74 6f 69 6e 64 65 78 sqlite_autoindex |
| 1468 |
| 4080: 5f 74 31 5f 32 74 31 02 00 00 00 08 00 00 00 00 _t1_2t1......... |
| 1469 |
| page 2 offset 4096 |
| 1470 |
| 0: 0a 00 00 00 05 0f d8 00 0f f8 0f f8 9f e8 0f e0 ................ |
| 1471 |
| 16: 0f d8 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 1472 |
| 4048: 00 00 00 00 00 00 00 00 07 04 01 02 00 0f 13 88 ................ |
| 1473 |
| 4064: 07 04 01 02 00 0e 0f a0 07 04 01 02 00 0d 0b b8 ................ |
| 1474 |
| 4080: 07 04 01 02 00 0c 07 d0 07 04 01 02 00 0b 03 e8 ................ |
| 1475 |
| page 5 offset 16384 |
| 1476 |
| 0: 0a 00 00 00 05 0f e2 00 0f fa 0f f4 0f ee 0f e8 ................ |
| 1477 |
| 16: 0f e2 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 1478 |
| 4064: 00 00 05 03 01 01 0f 0f 05 03 01 01 0e 0e 05 03 ................ |
| 1479 |
| 4080: 01 01 0d 0d 05 03 01 01 0c 0c 05 03 01 01 0b 0b ................ |
| 1480 |
| end crash-f022eb0ce64d27.db |
| 1481 |
}]} {} |
| 1482 |
|
| 1483 |
do_execsql_test 19.1 { |
| 1484 |
PRAGMA writable_schema=ON; |
| 1485 |
} |
| 1486 |
do_catchsql_test 19.2 { |
| 1487 |
UPDATE t1 SET a=1; |
| 1488 |
} {1 {database disk image is malformed}} |
| 1489 |
|
| 1490 |
reset_db |
| 1491 |
do_execsql_test 19.3 { |
| 1492 |
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INTEGER, d TEXT); |
| 1493 |
CREATE INDEX i1 ON t1((NULL)); |
| 1494 |
INSERT INTO t1 VALUES(1, NULL, 1, 'text value'); |
| 1495 |
PRAGMA writable_schema = on; |
| 1496 |
UPDATE sqlite_schema SET |
| 1497 |
sql = 'CREATE INDEX i1 ON t1(b, c, d)', |
| 1498 |
tbl_name = 't1', |
| 1499 |
type='index' |
| 1500 |
WHERE name='i1'; |
| 1501 |
} |
| 1502 |
db close |
| 1503 |
sqlite3 db test.db |
| 1504 |
do_catchsql_test 19.4 { |
| 1505 |
PRAGMA integrity_check; |
| 1506 |
} {1 {database disk image is malformed}} |
| 1507 |
|
| 1508 |
#------------------------------------------------------------------------- |
| 1509 |
reset_db |
| 1510 |
do_test 18.0 { |
| 1511 |
sqlite3 db {} |
| 1512 |
db deserialize [decode_hexdb { |
| 1513 |
.open --hexdb |
| 1514 |
| size 20480 pagesize 4096 filename crash-a4150b729051e4.db |
| 1515 |
| page 1 offset 0 |
| 1516 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 1517 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 05 .....@ ........ |
| 1518 |
| 32: 00 00 00 00 00 00 00 00 00 00 00 04 00 00 00 04 ................ |
| 1519 |
| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ |
| 1520 |
| 64: 00 00 00 00 00 00 00 00 00 00 ff f0 00 00 00 00 ................ |
| 1521 |
| 96: 00 00 00 00 0d 00 00 00 04 0e e5 00 0f c2 0f 75 ...............u |
| 1522 |
| 112: 0f 19 0e e5 00 00 00 00 00 00 00 01 00 00 00 00 ................ |
| 1523 |
| 3808: 00 00 00 00 00 32 04 06 17 17 11 01 4b 69 6e 64 .....2......Kind |
| 1524 |
| 3824: 65 78 74 31 61 62 63 74 31 05 43 52 45 41 54 45 ext1abct1.CREATE |
| 1525 |
| 3840: 20 49 4e 44 45 58 20 74 31 61 62 63 20 4f 4e 20 INDEX t1abc ON |
| 1526 |
| 3856: 74 31 28 61 2c 62 2c 63 29 5a 03 06 17 25 25 01 t1(a,b,c)Z...%%. |
| 1527 |
| 3872: 79 74 61 62 6c 65 73 71 6c 69 74 65 5f 73 74 61 ytablesqlite_sta |
| 1528 |
| 3888: 74 34 73 71 6c 69 74 65 5f 73 74 61 74 34 04 43 t4sqlite_stat4.C |
| 1529 |
| 3904: 52 45 41 54 45 20 54 41 42 4c 45 20 73 71 6c 69 REATE TABLE sqli |
| 1530 |
| 3920: 74 65 5f 73 74 61 74 34 28 74 62 6c 2c 69 64 78 te_stat4(tbl,idx |
| 1531 |
| 3936: 2c 6e 65 71 2c 6e 6c 74 2c 6e 64 6c 74 2c 73 61 ,neq,nlt,ndlt,sa |
| 1532 |
| 3952: 6d 70 6c 65 29 4b 02 06 17 25 25 01 5b 74 61 62 mple)K...%%.[tab |
| 1533 |
| 3968: 6c 65 73 71 6c 69 74 65 5f 73 74 61 74 31 73 71 lesqlite_stat1sq |
| 1534 |
| 3984: 6c 69 74 65 5f 73 74 61 74 31 03 43 52 45 41 54 lite_stat1.CREAT |
| 1535 |
| 4000: 45 20 54 41 42 4c 45 20 73 71 6c 69 74 65 5f 73 E TABLE sqlite_s |
| 1536 |
| 4016: 74 61 74 31 28 74 62 6c 2c 69 64 78 2c 73 74 61 tat1(tbl,idx,sta |
| 1537 |
| 4032: 74 29 3c 01 06 17 11 11 01 65 74 61 62 6c 65 74 t)<......etablet |
| 1538 |
| 4048: 31 74 31 02 43 52 45 41 54 45 20 54 41 42 4c 45 1t1.CREATE TABLE |
| 1539 |
| 4064: 20 74 31 28 61 20 54 45 58 54 2c 20 62 20 49 4e t1(a TEXT, b IN |
| 1540 |
| 4080: 54 2c 20 63 20 49 4e 54 2c 20 64 20 49 4e 54 29 T, c INT, d INT) |
| 1541 |
| page 2 offset 4096 |
| 1542 |
| 0: 0d 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 1543 |
| 4000: 0b 07 05 13 01 01 01 62 63 64 64 06 0b 0c 06 05 .......bcdd..... |
| 1544 |
| 4016: 13 02 01 01 64 65 66 01 59 09 0a 0c 05 05 13 03 ....def.Y....... |
| 1545 |
| 4032: 01 01 64 65 66 02 6f 08 09 0c 04 05 13 02 01 01 ..def.o......... |
| 1546 |
| 4048: 61 62 63 01 59 07 08 0c 03 05 13 02 01 01 87 62 abc.Y..........b |
| 1547 |
| 4064: 63 00 ea 06 07 0c 02 05 13 02 01 01 61 62 63 00 c...........abc. |
| 1548 |
| 4080: ea 06 06 0b 01 05 13 01 01 01 61 62 63 7b 04 04 ..........abc... |
| 1549 |
| page 3 offset 8192 |
| 1550 |
| 0: 0d 00 00 00 01 0f e0 00 0f e1 00 00 00 00 00 00 ................ |
| 1551 |
| 4064: 00 1d 01 04 11 17 31 74 31 74 31 61 62 63 31 30 ......1t1t1abc10 |
| 1552 |
| 4080: 30 30 30 20 35 30 30 30 20 32 30 30 30 20 31 30 000 5000 2000 10 |
| 1553 |
| page 4 offset 12288 |
| 1554 |
| 0: 0d 00 00 00 07 0e ac 00 0f d1 0f a0 0f 6f 0f 3e .............o.> |
| 1555 |
| 16: 0f 0e 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 1556 |
| 3744: 00 00 00 00 00 00 00 00 00 00 00 00 2f 07 07 11 ............/... |
| 1557 |
| 3760: 17 1b 1b 1b 24 74 31 74 31 61 62 63 32 20 31 20 ....$t1t1abc2 1 |
| 1558 |
| 3776: 31 20 31 35 20 36 20 36 20 36 32 20 35 20 36 20 1 15 6 6 62 5 6 |
| 1559 |
| 3792: 36 05 13 02 01 01 64 65 66 02 37 08 05 2f 06 07 6.....def.7../.. |
| 1560 |
| 3808: 11 17 1b 1b 1b 24 74 41 74 31 61 62 63 32 20 31 .....$tAt1abc2 1 |
| 1561 |
| 3824: 20 31 20 31 35 20 35 20 55 20 35 32 20 34 20 35 1 15 5 U 52 4 5 |
| 1562 |
| 3840: 20 35 05 13 02 01 01 64 65 66 01 59 09 06 2e 05 5.....def.Y.... |
| 1563 |
| 3856: 07 11 17 1b 1b 1b 22 74 31 74 31 61 62 63 31 20 .......t1t1abc1 |
| 1564 |
| 3872: 31 20 31 20 31 34 20 34 20 34 20 34 31 20 33 20 1 1 14 4 4 41 3 |
| 1565 |
| 3888: 34 20 34 08 b3 cd f0 f1 62 63 64 64 06 07 2f 05 4 4.....bcdd../. |
| 1566 |
| 3904: 07 11 17 1b 1b 1b 24 74 37 74 31 61 62 63 34 20 ......$t7t1abc4 |
| 1567 |
| 3920: 31 20 31 20 31 30 20 33 20 33 20 33 30 20 32 20 1 1 10 3 3 30 2 |
| 1568 |
| 3936: 33 20 33 05 13 02 01 01 61 62 63 01 59 07 04 2f 3 3.....abc.Y../ |
| 1569 |
| 3952: 03 07 11 17 1b 1b 1b 24 74 31 74 31 61 62 63 34 .......$t1t1abc4 |
| 1570 |
| 3968: 20 32 20 31 20 31 30 20 31 20 32 20 32 30 20 31 2 1 10 1 2 20 1 |
| 1571 |
| 3984: 20 32 20 32 05 13 02 01 01 61 62 63 00 ea 06 03 2 2.....abc.... |
| 1572 |
| 4000: 2f 02 07 11 17 1b 1b 1b 24 74 31 74 31 61 62 63 /.......$t1t1abc |
| 1573 |
| 4016: 34 20 32 20 31 20 31 30 20 31 20 31 20 31 30 20 4 2 1 10 1 1 10 |
| 1574 |
| 4032: 31 20 31 20 31 05 13 02 01 01 61 62 63 00 ea 05 1 1 1.....abc... |
| 1575 |
| 4048: 02 2d 01 07 11 17 1b 1b 1b 20 74 31 74 31 61 62 .-....... t1t1ab |
| 1576 |
| 4064: 63 34 20 31 20 31 20 31 30 20 30 20 30 1f 30 30 c4 1 1 10 0 0.00 |
| 1577 |
| 4080: 20 30 20 30 20 30 05 13 01 01 09 61 62 63 7b 04 0 0 0.....abc.. |
| 1578 |
| page 5 offset 16384 |
| 1579 |
| 0: 0a 00 00 00 07 0f a8 00 0f f5 00 00 00 00 00 00 ................ |
| 1580 |
| 4000: 00 00 00 00 00 00 00 00 0c 05 13 02 01 01 64 65 ..............de |
| 1581 |
| 4016: 66 02 37 08 05 0c 05 13 02 01 01 64 65 66 01 59 f.7........def.Y |
| 1582 |
| 4032: 09 06 0b 05 12 01 01 01 62 63 64 64 06 07 0c 05 ........bcdd.... |
| 1583 |
| 4048: 13 02 01 01 61 62 63 01 59 07 01 2c 05 13 02 01 ....abc.Y..,.... |
| 1584 |
| 4064: 01 61 62 63 00 ea 06 03 0c 05 13 02 01 01 61 62 .abc..........ab |
| 1585 |
| 4080: 63 00 ea 05 00 00 00 00 00 00 00 00 00 00 00 00 c............... |
| 1586 |
| end crash-a4150b729051e4.db |
| 1587 |
}]} {} |
| 1588 |
|
| 1589 |
do_catchsql_test 18.1 { |
| 1590 |
SELECT a FROM t1 WHERE b GLOB b AND b GLOB '0^x]␅6␚xz]'; |
| 1591 |
} {1 {database disk image is malformed}} |
| 1592 |
|
| 1593 |
finish_test |