/ Check-in [927cd7b4]
Login

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: 927cd7b4c52fae665e57fb6039c6829e339cff5ad5c405800cac3ee149ef5be1
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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