Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update some corruption test cases to take [724f4df9c] into account. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
927cd7b4c52fae665e57fb6039c6829e |
| User & Date: | dan 2019-08-13 17:27:43 |
Context
|
2019-08-13
| ||
| 17:56 | Update test cases so that they work with ICU enabled. (check-in: 408144a1 user: dan tags: trunk) | |
| 17:27 | Update some corruption test cases to take [724f4df9c] into account. (check-in: 927cd7b4 user: dan tags: trunk) | |
| 15:11 | Fix a problem with RBU function sqlite3rbu_bp_progress() when used during an RBU vacuum. (check-in: 8c44b02f user: dan tags: trunk) | |
Changes
Changes to ext/rtree/rtreefuzz001.test.
461 461 | 3392: 41 10 00 00 41 20 00 00 00 00 00 00 00 00 07 74 A...A .........t 462 462 | 3408: 41 00 00 00 41 10 00 00 41 10 00 00 41 20 00 00 A...A...A...A .. 463 463 | 3424: 00 00 00 00 00 00 07 75 41 10 00 00 41 20 00 00 .......uA...A .. 464 464 | 3440: 41 10 00 00 41 20 00 00 00 00 00 00 00 00 00 00 A...A .......... 465 465 | end c1b.db 466 466 }] 467 467 catchsql { 468 + PRAGMA writable_schema = 1; 468 469 SELECT rtreecheck('t1'); 469 470 } 470 471 } {1 {SQL logic error}} 471 472 472 473 do_test rtreefuzz001-200 { 473 474 sqlite3 db {} 474 475 db deserialize [decode_hexdb { ................................................................................ 1036 1037 | 2720: 00 00 00 03 e9 00 00 00 01 00 00 00 03 00 00 00 ................ 1037 1038 | 2736: 01 00 00 00 03 00 00 00 00 00 00 07 d1 00 00 00 ................ 1038 1039 | 2848: 00 00 00 00 00 00 00 00 00 00 00 00 00 89 50 01 ..............P. 1039 1040 | 2864: 04 00 93 24 00 01 00 02 00 00 00 00 00 00 00 02 ...$............ 1040 1041 | 2880: ff ff ff 06 00 00 00 0c 00 00 00 01 00 00 00 0b ................ 1041 1042 | 2896: 00 00 00 00 00 00 00 02 40 00 00 00 00 00 00 00 ........@....... 1042 1043 | end crash-2e81f5dce5cbd4.db}] 1044 + execsql { PRAGMA writable_schema = 1;} 1043 1045 catchsql {UPDATE t1 SET ex= ex ISNULL} 1044 1046 } {1 {database disk image is malformed}} 1045 1047 1046 1048 1047 1049 finish_test
Changes to test/fts3corrupt4.test.
2143 2143 | page 7 offset 24576 2144 2144 | 0: 0d 00 00 00 01 0f f7 00 0f f7 00 00 00 00 00 00 ................ 2145 2145 | 4080: 00 00 00 00 00 00 00 07 00 03 00 14 08 45 b5 03 .............E.. 2146 2146 | end crash-f7b636a855e1d2.db 2147 2147 }]} {} 2148 2148 2149 2149 do_execsql_test 14.1 { 2150 + PRAGMA writable_schema = 1; 2150 2151 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<10) 2151 2152 INSERT INTO t1(a) SELECT randomblob(3000) FROM c; 2152 2153 } 2153 2154 2154 2155 do_catchsql_test 14.2 { 2155 2156 INSERT INTO t1(t1) VALUES('optimize'); 2156 2157 } {1 {database disk image is malformed}} ................................................................................ 3045 3046 | 4048: 3d 31 30 30 2c 38 11 03 02 2b 69 6e 74 65 67 72 =100,8...+integr 3046 3047 | 4064: 69 74 79 2d 63 68 65 63 6b 09 02 02 1b 72 65 62 ity-check....reb 3047 3048 | 4080: 75 69 6c 64 0a 01 02 1d 6f 70 74 69 6d 69 7a 65 uild....optimize 3048 3049 | end crash-526ea445f41c02.db 3049 3050 }]} {} 3050 3051 3051 3052 do_catchsql_test 19.1 { 3053 + PRAGMA writable_schema = 1; 3052 3054 SELECT rowid,a,c,snippet(t1,85101090932165,-1,10) FROM t1 WHERE a MATCH 'rtree'; 3053 3055 } {1 {database disk image is malformed}} 3054 3056 3055 3057 #------------------------------------------------------------------------- 3056 3058 reset_db 3057 3059 do_test 20.0 { 3058 3060 sqlite3 db {} ................................................................................ 3246 3248 | page 7 offset 24576 3247 3249 | 0: 0d 00 00 00 01 0f f7 00 0f f7 00 00 00 00 00 00 ................ 3248 3250 | 4080: 00 00 00 00 00 00 00 07 00 03 00 14 08 45 b5 03 .............E.. 3249 3251 | end crash-afecd03c862e58.db 3250 3252 }]} {} 3251 3253 3252 3254 do_execsql_test 20.1 { 3255 + PRAGMA writable_schema = 1; 3253 3256 BEGIN; 3254 3257 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<10) 3255 3258 INSERT INTO t1(a) SELECT randomblob(3000) FROM c; 3256 3259 } 3257 3260 3258 3261 do_execsql_test 20.2 { 3259 3262 INSERT INTO t1(t1) VALUES('optimize'); ................................................................................ 3468 3471 | 4032: 6d 65 72 67 65 3d 35 0d 04 02 23 6d 65 72 67 65 merge=5...#merge 3469 3472 | 4048: 3d 31 30 30 2c 38 11 03 02 2b 69 6e 74 65 67 72 =100,8...+integr 3470 3473 | 4064: 69 74 79 2d 63 68 65 63 6b 09 02 02 1b 72 65 62 ity-check....reb 3471 3474 | 4080: 75 69 6c 64 0a 01 02 1d 00 00 00 00 00 00 00 00 uild............ 3472 3475 | end crash-18cc014e42e828.db 3473 3476 }]} {} 3474 3477 3475 -breakpoint 3476 3478 do_catchsql_test 21.1 { 3479 + PRAGMA writable_schema = 1; 3477 3480 SELECT offsets(t1) FROM t1 WHERE t1 MATCH 'R*'; 3478 3481 } {1 {database disk image is malformed}} 3479 3482 3480 3483 #------------------------------------------------------------------------- 3481 3484 reset_db 3482 3485 do_test 22.0 { 3483 3486 sqlite3 db {} ................................................................................ 3690 3693 | 4032: 6d 65 72 67 65 3d 35 0d 04 02 23 6d 65 72 67 65 merge=5...#merge 3691 3694 | 4048: 3d 31 30 30 2c 38 11 03 02 2b 69 6e 74 65 67 72 =100,8...+integr 3692 3695 | 4064: 69 74 79 2d 63 68 65 63 6b 09 02 02 1b 72 65 62 ity-check....reb 3693 3696 | end crash-b794c89d922ac9.db 3694 3697 }]} {} 3695 3698 3696 3699 do_catchsql_test 22.1 { 3700 + PRAGMA writable_schema = 1; 3697 3701 SELECT snippet(t1,'', '', '--',-1,01)==0 3698 3702 FROM t1 WHERE a MATCH 'rtree OR json1rtree OR json1'; 3699 3703 } {0 {0 0 0 0 0 0 0}} 3700 3704 3701 3705 #------------------------------------------------------------------------- 3702 3706 reset_db 3703 3707 do_test 23.0 { ................................................................................ 3909 3913 | 4032: 6d 65 71 97 65 3d 35 0d 04 02 23 6d 65 72 67 65 meq.e=5...#merge 3910 3914 | 4048: 3d 31 30 30 2c 38 11 03 02 2b 69 6e 74 65 67 72 =100,8...+integr 3911 3915 | 4064: 69 74 79 00 00 00 00 00 00 00 00 00 00 00 00 00 ity............. 3912 3916 | end crash-670b15f2955a36.db 3913 3917 }]} {} 3914 3918 3915 3919 do_catchsql_test 23.1 { 3920 + PRAGMA writable_schema = 1; 3916 3921 SELECT 'FyzLy'FROM t1 WHERE t1 MATCH 'j'; 3917 3922 } {1 {database disk image is malformed}} 3918 3923 3919 3924 #------------------------------------------------------------------------- 3920 3925 reset_db 3921 3926 do_test 24.0 { 3922 3927 sqlite3 db {} ................................................................................ 4127 4132 | 4016: 00 00 00 00 00 00 00 00 0d 05 02 23 61 75 74 6f ...........#auto 4128 4133 | 4032: 6d 65 72 67 65 3d 35 0d 04 02 23 6d 65 72 67 65 merge=5...#merge 4129 4134 | 4048: 3d 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00 =1.............. 4130 4135 | end crash-369d042958c29b.db 4131 4136 }]} {} 4132 4137 4133 4138 do_catchsql_test 24.1 { 4139 + PRAGMA writable_schema = 1; 4134 4140 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT '4hE'+x FROM c WHERE x<72) 4135 4141 INSERT INTO t1(a) SELECT randomblob(2829) FROM c; 4136 4142 } {0 {}} 4137 4143 4138 4144 do_catchsql_test 24.2 { 4139 4145 UPDATE t1 SET b=quote((true) ) WHERE t1 MATCH 'h'; 4140 4146 } {0 {}} ................................................................................ 4370 4376 | 4016: 00 00 00 00 00 00 00 00 0d 05 02 23 61 75 74 6f ...........#auto 4371 4377 | 4032: 6d 65 72 67 65 3d 35 0d 04 02 23 6d 65 72 67 65 merge=5...#merge 4372 4378 | 4048: 3d 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00 =1.............. 4373 4379 | end crash-dde9e76ed8ab2d.db 4374 4380 }]} {} 4375 4381 4376 4382 do_catchsql_test 25.1 { 4383 + PRAGMA writable_schema = 1; 4377 4384 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x%1 FROM c WHERE x<599237) 4378 4385 INSERT INTO t1( a ) SELECT randomblob(3000) FROM t2 ; 4379 4386 } {0 {}} 4380 4387 4381 4388 do_catchsql_test 25.2 { 4382 4389 UPDATE t1 SET b=quote((true) ) WHERE t1 MATCH 'h*'; 4383 4390 } {0 {}} ................................................................................ 4604 4611 | page 7 offset 24576 4605 4612 | 0: 0d 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 4606 4613 | 4016: 00 00 00 00 00 00 00 00 0d 05 02 23 61 00 00 00 ...........#a... 4607 4614 | end crash-26682721375870.db 4608 4615 }]} {} 4609 4616 4610 4617 do_execsql_test 26.1 { 4618 + PRAGMA writable_schema = 1; 4611 4619 SELECT count(*) FROM ( 4612 4620 SELECT t1, (t1) FROM t1 WHERE b MATCH 'x' 4613 4621 ) 4614 4622 } 34 4615 4623 4616 4624 #------------------------------------------------------------------------- 4617 4625 reset_db ................................................................................ 4822 4830 | 4016: 00 00 00 00 00 00 00 00 0f 85 02 23 61 75 74 6f ...........#auto 4823 4831 | 4032: 6d 65 72 67 65 3d 35 0d 04 02 23 6d 65 72 67 65 merge=5...#merge 4824 4832 | 4048: 3d 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00 =1.............. 4825 4833 | end crash-23ddd777a03bfd.db 4826 4834 }]} {} 4827 4835 4828 4836 do_catchsql_test 27.2 { 4837 + PRAGMA writable_schema = 1; 4829 4838 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x GLOB 2.16770 FROM x) 4830 4839 INSERT INTO t1(a) SELECT randomblob(3000) FROM t2 ; 4831 4840 } {0 {}} 4832 4841 do_catchsql_test 27.3 { 4833 4842 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT 3+x FROM c WHERE x<2.653) 4834 4843 INSERT INTO t1(a) SELECT randomblob(-current_time) FROM c; 4835 4844 } {0 {}} ................................................................................ 5054 5063 | 4016: 00 00 00 00 00 00 00 00 0d 05 02 23 61 75 74 6f ...........#auto 5055 5064 | 4032: 6d 65 72 67 65 3d 35 0d 04 02 23 6d 65 72 67 65 merge=5...#merge 5056 5065 | 4048: 3d 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00 =1.............. 5057 5066 | end crash-159ac1ca51ed55.db 5058 5067 }]} {} 5059 5068 5060 5069 do_catchsql_test 28.1 { 5070 + PRAGMA writable_schema = 1; 5061 5071 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT 3+x FROM c WHERE x<72) 5062 5072 INSERT INTO t1(a) SELECT randomblob(2829) FROM c; 5063 5073 } {0 {}} 5064 5074 5065 5075 do_catchsql_test 28.1 { 5066 5076 UPDATE t1 SET b=quote((true) ) WHERE t1 MATCH 'h'; 5067 5077 } {0 {}} ................................................................................ 5308 5318 | 4016: 00 00 00 00 00 00 00 00 0d 05 02 23 61 75 74 6f ...........#auto 5309 5319 | 4032: 6d 65 72 67 65 3d 35 0d 04 02 23 6d 65 72 67 65 merge=5...#merge 5310 5320 | 4048: 3d 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00 =1.............. 5311 5321 | end crash-53f41622dd3bf6.db 5312 5322 }]} {} 5313 5323 5314 5324 do_catchsql_test 29.1 { 5325 + PRAGMA writable_schema = 1; 5315 5326 INSERT INTO t1(a) SELECT X'819192E578DE3F'; 5316 5327 UPDATE t1 SET b=quote(zeroblob(current_date)) WHERE t1 MATCH 't*'; 5317 5328 INSERT INTO t1(b) VALUES(x'78'); 5318 5329 INSERT INTO t1(t1) SELECT x FROM t2; 5319 5330 } {1 {database disk image is malformed}} 5320 5331 5321 5332 finish_test