1558ef11aSdrh# 2012-12-21 2558ef11aSdrh# 3558ef11aSdrh# The author disclaims copyright to this source code. In place of 4558ef11aSdrh# a legal notice, here is a blessing: 5558ef11aSdrh# 6558ef11aSdrh# May you do good and not evil. 7558ef11aSdrh# May you find forgiveness for yourself and forgive others. 8558ef11aSdrh# May you share freely, never taking more than you give. 9558ef11aSdrh# 10558ef11aSdrh#*********************************************************************** 11558ef11aSdrh# 12558ef11aSdrh# Test cases for corrupt database files. 13558ef11aSdrh 14558ef11aSdrhif {![info exists testdir]} { 15558ef11aSdrh set testdir [file join [file dirname [info script]] .. .. test] 16558ef11aSdrh} 17558ef11aSdrhsource $testdir/tester.tcl 18558ef11aSdrh 19558ef11aSdrhifcapable !deserialize||!rtree { 20558ef11aSdrh finish_test 21558ef11aSdrh return 22558ef11aSdrh} 23558ef11aSdrhdatabase_may_be_corrupt 24558ef11aSdrh 25558ef11aSdrhdo_test rtreefuzz001-100 { 26558ef11aSdrh sqlite3 db {} 27558ef11aSdrh db deserialize [decode_hexdb { 28558ef11aSdrh| size 24576 pagesize 4096 filename c1b.db 29558ef11aSdrh| page 1 offset 0 30558ef11aSdrh| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. 31558ef11aSdrh| 16: 10 00 01 01 00 40 20 20 00 00 00 03 00 00 00 06 .....@ ........ 32558ef11aSdrh| 32: 00 00 00 00 00 00 00 00 00 00 00 03 00 00 00 04 ................ 33558ef11aSdrh| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ 34558ef11aSdrh| 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 03 ................ 35558ef11aSdrh| 96: 00 2e 30 38 0d 00 00 00 04 0e 9c 00 0f ad 0f 4f ..08...........O 36558ef11aSdrh| 112: 0e fc 0e 9c 00 00 00 00 00 00 00 00 00 00 00 00 ................ 37558ef11aSdrh| 3728: 00 00 00 00 00 00 00 00 00 00 00 00 5e 04 07 17 ............^... 38558ef11aSdrh| 3744: 1f 1f 01 81 0b 74 61 62 6c 65 74 31 5f 70 61 72 .....tablet1_par 39558ef11aSdrh| 3760: 65 6e 74 74 31 5f 70 61 72 65 6e 74 04 43 52 45 entt1_parent.CRE 40558ef11aSdrh| 3776: 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 70 61 ATE TABLE .t1_pa 41558ef11aSdrh| 3792: 72 66 6e 74 22 28 6e 6f 64 65 6e 6f 20 49 4e 54 rfnt.(nodeno INT 42558ef11aSdrh| 3808: 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 EGER PRIMARY KEY 43558ef11aSdrh| 3824: 2c 70 61 72 65 6e 74 6e 6f 64 65 29 51 03 06 17 ,parentnode)Q... 44558ef11aSdrh| 3840: 1b 1b 01 7b 74 61 62 6c 65 74 31 5f 6e 6f 64 65 ....tablet1_node 45558ef11aSdrh| 3856: 74 31 5f 6e 6f 64 65 03 43 52 45 41 54 45 20 54 t1_node.CREATE T 46558ef11aSdrh| 3872: 41 42 4c 45 20 22 74 31 5f 6e 6f 64 65 22 28 6e ABLE .t1_node.(n 47558ef11aSdrh| 3888: 6f 64 65 6e 6f 20 49 4e 54 45 47 45 52 20 50 52 odeno INTEGER PR 48558ef11aSdrh| 3904: 49 4d 41 52 59 20 4b 45 59 2c 64 61 74 61 29 5c IMARY KEY,data). 49558ef11aSdrh| 3920: 02 07 17 1d 1d 01 81 0b 74 61 62 6c 65 74 31 5f ........tablet1_ 50558ef11aSdrh| 3936: 72 6f 77 69 64 74 31 5f 72 6f 77 69 64 02 43 52 rowidt1_rowid.CR 51558ef11aSdrh| 3952: 45 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 72 EATE TABLE .t1_r 52558ef11aSdrh| 3968: 6f 77 69 64 22 28 72 6f 77 69 64 20 49 4e 54 45 owid.(rowid INTE 53558ef11aSdrh| 3984: 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c GER PRIMARY KEY, 54558ef11aSdrh| 4000: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 29 51 01 07 nodeno,a0,a1)Q.. 55558ef11aSdrh| 4016: 17 11 11 08 81 0f 74 61 62 6c 65 74 31 74 31 43 ......tablet1t1C 56558ef11aSdrh| 4032: 52 45 41 54 45 20 56 49 52 54 55 41 4c 20 54 41 REATE VIRTUAL TA 57558ef11aSdrh| 4048: 42 4c 45 20 74 31 20 55 53 49 4e 47 20 72 74 72 BLE t1 USING rtr 58558ef11aSdrh| 4064: 65 65 28 69 64 2c 78 30 2c 78 31 2c 79 30 2c 79 ee(id,x0,x1,y0,y 59558ef11aSdrh| 4080: 31 2c 2b 6c 61 62 65 6c 2c 2b 6f 74 68 65 72 29 1,+label,+other) 60558ef11aSdrh| page 2 offset 4096 61558ef11aSdrh| 0: 0d 0c cd 00 74 08 75 01 0f e8 0c b3 0f d0 0f b7 ....t.u......... 62558ef11aSdrh| 16: 0f 9e 0f 91 0f 81 0f 70 0f 5e 0f 4f 0f 39 0f 29 .......p.^.O.9.) 63558ef11aSdrh| 32: 0f 18 0f 06 0e f7 0c 65 0e 58 0d c2 0d 2c 0c 25 .......e.X...,.% 64558ef11aSdrh| 48: 0b 85 0a e5 0a 45 09 a5 09 05 0c 83 0c 93 0c a3 .....E.......... 65558ef11aSdrh| 64: 0f f0 0c 15 0b 75 0a d5 0a 35 09 95 08 f5 0e d8 .....u...5...... 66558ef11aSdrh| 80: 0e 42 0d ac 0d 16 0c 05 0b 65 0a c5 0a 25 09 85 .B.......e...%.. 67558ef11aSdrh| 96: 08 e5 0e c8 0e 32 0d 9c 0d 06 0b f5 0b 55 0a b5 .....2.......U.. 68558ef11aSdrh| 112: 0a 15 09 75 08 d5 0e b8 0e 22 0d 8c 0c f6 0b e5 ...u............ 69558ef11aSdrh| 128: 0b 45 0a a5 0a 05 09 65 08 c5 0e a8 0e 12 0d 7c .E.....e.......| 70558ef11aSdrh| 144: 0c e6 0b d5 0b 35 0a 95 09 f5 09 55 08 b5 0e 98 .....5.....U.... 71558ef11aSdrh| 160: 0e 02 0d 6c 0c d6 0b c5 0b 25 0a 85 09 e5 09 45 ...l.....%.....E 72558ef11aSdrh| 176: 08 a5 0e 88 0d f2 0d 5c 0c 55 0b b5 0b 15 0a 75 .........U.....u 73558ef11aSdrh| 192: 09 d5 09 35 08 95 0e 78 0d e2 0d 4c 0c 45 0b a5 ...5...x...L.E.. 74558ef11aSdrh| 208: 0b 05 0a 65 09 c5 09 25 08 85 0e 68 0d d2 0d 3c ...e...%...h...< 75558ef11aSdrh| 224: 0c 35 0b 95 0a f5 0a 55 09 b5 09 15 08 75 0c 75 .5.....U.....u.u 76558ef11aSdrh| 2160: 00 00 00 00 00 0d 8e 75 05 00 01 1b 00 04 62 6f .......u......bo 77558ef11aSdrh| 2176: 78 2d 39 2c 39 0d 8e 11 05 00 01 1b 00 02 62 6f x-9,9.........bo 78558ef11aSdrh| 2192: 78 2d 39 2c 38 0d 8d 2d 05 00 01 1b 00 02 62 6f x-9,8..-......bo 79558ef11aSdrh| 2208: 78 2d 39 2c 37 0d 8c 49 05 00 01 1b 00 02 62 6f x-9,7..I......bo 80558ef11aSdrh| 2224: 78 2d 39 2c 36 0d 8b 65 05 00 01 1b 00 02 62 6f x-9,6..e......bo 81558ef11aSdrh| 2240: 78 2d 39 2c 35 0d 8b 01 05 00 01 1b 00 02 62 6f x-9,5.........bo 82558ef11aSdrh| 2256: 78 2d 39 2c 34 0d 8a 1d 05 00 01 1b 00 02 62 6f x-9,4.........bo 83558ef11aSdrh| 2272: 78 2d 39 2c 33 0d 89 39 05 00 01 1b 00 02 62 6f x-9,3..9......bo 84558ef11aSdrh| 2288: 78 2d 39 2c 32 0d 88 55 05 00 01 1b 00 02 62 6f x-9,2..U......bo 85558ef11aSdrh| 2304: 78 2d 39 2c 31 0d 87 71 05 00 01 1b 00 02 62 6f x-9,1..q......bo 86558ef11aSdrh| 2320: 78 2d 39 2c 30 0d 8e 74 05 00 01 1b 00 04 62 6f x-9,0..t......bo 87558ef11aSdrh| 2336: 78 2d 38 2c 39 0d 8e 10 05 00 01 1b 00 02 62 6f x-8,9.........bo 88558ef11aSdrh| 2352: 78 2d 38 2c 38 0d 8d 2c 05 00 01 1b 00 02 62 6f x-8,8..,......bo 89558ef11aSdrh| 2368: 78 2d 38 2c 37 0d 8c 48 05 00 01 1b 00 02 62 6f x-8,7..H......bo 90558ef11aSdrh| 2384: 78 2d 38 2c 36 0d 8b 64 05 00 01 1b 00 02 62 6f x-8,6..d......bo 91558ef11aSdrh| 2400: 78 2d 38 2c 35 0d 8b 00 05 00 01 1b 00 02 62 6f x-8,5.........bo 92558ef11aSdrh| 2416: 78 2d 38 2c 34 0d 8a 1c 05 00 01 1b 00 02 62 6f x-8,4.........bo 93558ef11aSdrh| 2432: 78 2d 38 2c 33 0d 89 38 05 00 01 1b 00 02 62 6f x-8,3..8......bo 94558ef11aSdrh| 2448: 78 2d 38 2c 32 0d 88 54 05 00 01 1b 00 02 62 6f x-8,2..T......bo 95558ef11aSdrh| 2464: 78 2d 38 2c 31 0d 87 70 05 00 01 1b 00 02 62 6f x-8,1..p......bo 96558ef11aSdrh| 2480: 78 2d 38 2c 30 0d 8e 73 05 00 01 1b 00 05 62 6f x-8,0..s......bo 97558ef11aSdrh| 2496: 78 2d 37 2c 39 0d 8e 0f 05 00 01 1b 00 05 62 6f x-7,9.........bo 98558ef11aSdrh| 2512: 78 2d 37 2c 38 0d 8d 2b 05 00 01 1b 00 05 62 6f x-7,8..+......bo 99558ef11aSdrh| 2528: 78 2d 37 2c 37 0d 8c 47 05 00 01 1b 00 05 62 6f x-7,7..G......bo 100558ef11aSdrh| 2544: 78 2d 37 2c 36 0d 8b 63 05 00 01 1b 00 05 62 6f x-7,6..c......bo 101558ef11aSdrh| 2560: 78 2d 37 2c 35 0d 8a 7f 05 00 01 1b 00 05 62 6f x-7,5.........bo 102558ef11aSdrh| 2576: 78 2d 37 2c 34 0d 8a 1b 05 00 01 1b 00 05 62 6f x-7,4.........bo 103558ef11aSdrh| 2592: 78 2d 37 2c 33 0d 89 37 05 00 01 1b 00 05 62 6f x-7,3..7......bo 104558ef11aSdrh| 2608: 78 2d 37 2c 32 0d 88 53 05 00 01 1b 00 05 62 6f x-7,2..S......bo 105558ef11aSdrh| 2624: 78 2d 37 2c 31 0d 87 6f 05 00 01 1b 00 05 62 6f x-7,1..o......bo 106558ef11aSdrh| 2640: 78 2d 37 2c 30 0d 8e 72 05 00 01 1b 00 04 62 6f x-7,0..r......bo 107558ef11aSdrh| 2656: 78 2d 36 2c 39 0d 8e 0e 05 00 01 1b 00 05 62 6f x-6,9.........bo 108558ef11aSdrh| 2672: 78 2d 36 2c 38 0d 8d 2a 05 00 01 1b 00 05 62 6f x-6,8..*......bo 109558ef11aSdrh| 2688: 78 2d 36 2c 37 0d 8c 46 05 00 01 1b 00 05 62 6f x-6,7..F......bo 110558ef11aSdrh| 2704: 78 2d 36 2c 36 0d 8b 62 05 00 01 1b 00 05 62 6f x-6,6..b......bo 111558ef11aSdrh| 2720: 78 2d 36 2c 35 0d 8a 7e 05 00 01 1b 00 05 62 6f x-6,5..~......bo 112558ef11aSdrh| 2736: 78 2d 36 2c 34 0d 8a 1a 05 00 01 1b 00 05 62 6f x-6,4.........bo 113558ef11aSdrh| 2752: 78 2d 36 2c 33 0d 89 36 05 00 01 1b 00 05 62 6f x-6,3..6......bo 114558ef11aSdrh| 2768: 78 2d 36 2c 32 0d 88 52 05 00 01 1b 00 05 62 6f x-6,2..R......bo 115558ef11aSdrh| 2784: 78 2d 36 2c 31 0d 87 6e 05 00 01 1b 00 05 62 6f x-6,1..n......bo 116558ef11aSdrh| 2800: 78 2d 36 2c 30 0d 8e 71 05 00 01 1b 00 04 62 6f x-6,0..q......bo 117558ef11aSdrh| 2816: 78 2d 35 2c 39 0d 8e 0d 05 00 01 1b 00 05 62 6f x-5,9.........bo 118558ef11aSdrh| 2832: 78 2d 35 2c 38 0d 8d 29 05 00 01 1b 00 05 62 6f x-5,8..)......bo 119558ef11aSdrh| 2848: 78 2d 35 2c 37 0d 8c 45 05 00 01 1b 00 05 62 6f x-5,7..E......bo 120558ef11aSdrh| 2864: 78 2d 35 2c 36 0d 8b 61 05 00 01 1b 00 05 62 6f x-5,6..a......bo 121558ef11aSdrh| 2880: 78 2d 35 2c 35 0d 8a 7d 05 00 01 1b 00 05 62 6f x-5,5.........bo 122558ef11aSdrh| 2896: 78 2d 35 2c 34 0d 8a 19 05 00 01 1b 00 05 62 6f x-5,4.........bo 123558ef11aSdrh| 2912: 78 2d 35 2c 33 0d 89 35 05 00 01 1b 00 05 62 6f x-5,3..5......bo 124558ef11aSdrh| 2928: 78 2d 35 2c 32 0d 88 51 05 00 01 1b 00 05 62 6f x-5,2..Q......bo 125558ef11aSdrh| 2944: 78 2d 35 2c 31 0d 87 6d 05 00 01 1b 00 05 62 6f x-5,1..m......bo 126558ef11aSdrh| 2960: 78 2d 35 2c 30 0d 8e 70 05 00 01 1b 00 04 62 6f x-5,0..p......bo 127558ef11aSdrh| 2976: 78 2d 34 2c 39 0d 8e 0c 05 00 01 1b 00 04 62 6f x-4,9.........bo 128558ef11aSdrh| 2992: 78 2d 34 2c 38 0d 8d 28 05 00 01 1b 00 04 62 6f x-4,8..(......bo 129558ef11aSdrh| 3008: 78 2d 34 2c 37 0d 8c 44 05 00 01 1b 00 04 62 6f x-4,7..D......bo 130558ef11aSdrh| 3024: 78 2d 34 2c 36 0d 8b 60 05 00 01 1b 00 02 62 6f x-4,6..`......bo 131558ef11aSdrh| 3040: 78 2d 34 2c 35 0d 8a 7c 05 00 01 1b 00 02 62 6f x-4,5..|......bo 132558ef11aSdrh| 3056: 78 2d 34 2c 34 0d 8a 18 05 00 01 1b 00 02 62 6f x-4,4.........bo 133558ef11aSdrh| 3072: 78 2d 34 2c 33 0d 89 34 05 00 01 1b 00 02 62 6f x-4,3..4......bo 134558ef11aSdrh| 3088: 78 2d 34 2c 32 0d 88 50 05 00 01 1b 00 02 62 6f x-4,2..P......bo 135558ef11aSdrh| 3104: 78 2d 34 2c 31 0d 87 6c 05 00 01 1b 00 02 62 6f x-4,1..l......bo 136558ef11aSdrh| 3120: 78 2d 34 2c 30 0d 8e 6f 05 00 01 1b 00 04 62 6f x-4,0..o......bo 137558ef11aSdrh| 3136: 78 2d 33 2c 39 0d 8e 0b 05 00 01 1b 00 04 62 6f x-3,9.........bo 138558ef11aSdrh| 3152: 78 2d 33 2c 38 0d 8d 27 05 00 01 1b 00 04 62 6f x-3,8..'......bo 139558ef11aSdrh| 3168: 78 2d 33 2c 37 0d 87 68 05 00 01 1b 00 03 62 6f x-3,7..h......bo 140558ef11aSdrh| 3184: 78 2d 30 2c 30 06 90 d9 80 80 81 84 4c 05 00 01 x-0,0.......L... 141558ef11aSdrh| 3200: 00 00 03 0d 88 4c 05 00 01 1b 00 02 62 6f 78 2d .....L......box- 142558ef11aSdrh| 3216: 30 2c 31 0d 88 4d 05 00 01 1b 00 02 62 6f 78 2d 0,1..M......box- 143558ef11aSdrh| 3232: 31 2c 31 0d 88 4e 05 00 01 1b 00 02 62 6f 78 2d 1,1..N......box- 144558ef11aSdrh| 3248: 32 2c 31 17 01 05 00 01 2f 00 02 6c 6f 77 65 72 2,1...../..lower 145558ef11aSdrh| 3264: 2d 6c 65 66 74 20 63 6f 72 6e 65 72 0d 0d 26 00 -left corner..&. 146558ef11aSdrh| 3280: 09 00 01 00 00 04 0d 8c 43 05 00 01 1b 00 04 62 ........C......b 147558ef11aSdrh| 3296: 6f 78 2d 33 2c 36 0d 8b 5f 05 00 01 1b 00 02 62 ox-3,6.._......b 148558ef11aSdrh| 3312: 6f 78 2d 33 2c 35 0d 8a 7b 05 00 01 1b 00 02 62 ox-3,5.........b 149558ef11aSdrh| 3328: 6f 78 2d 33 2c 34 0d 8a 17 05 00 01 1b 00 02 62 ox-3,4.........b 150558ef11aSdrh| 3344: 6f 78 2d 33 2c 33 0d 89 33 05 00 01 1b 00 02 62 ox-3,3..3......b 151558ef11aSdrh| 3360: 6f 78 2d 33 2c 32 0d bc 00 06 00 09 0d 87 6b 05 ox-3,2........k. 152558ef11aSdrh| 3376: 00 01 1b 00 03 62 6f 78 2d 33 2c 30 0d 8e 6e 05 .....box-3,0..n. 153558ef11aSdrh| 3392: 00 01 1b 00 04 62 6f 78 2d 32 2c 39 0d 8e 0a 05 .....box-2,9.... 154558ef11aSdrh| 3408: 00 01 1b 00 04 62 6f 78 2d 32 2c 38 0d 8d 26 05 .....box-2,8..&. 155558ef11aSdrh| 3424: 00 01 1b 00 04 62 6f 78 2d 32 2c 37 0d 8c 42 05 .....box-2,7..B. 156558ef11aSdrh| 3440: 00 01 1b 00 04 62 6f 78 2d 32 2c 36 0d 8b 5e 05 .....box-2,6..^. 157558ef11aSdrh| 3456: 00 01 1b 00 02 62 6f 78 2d 32 2c 35 0d 8a 7a 05 .....box-2,5..z. 158558ef11aSdrh| 3472: 00 01 1b 00 02 62 6f 78 2d 32 2c 34 0d 8a 16 05 .....box-2,4.... 159558ef11aSdrh| 3488: 00 01 1b 00 02 62 6f 78 2d 32 2c 33 0d 89 32 05 .....box-2,3..2. 160558ef11aSdrh| 3504: 00 01 1b 00 02 62 6f 78 2d 32 2c 32 0e 52 00 06 .....box-2,2.R.. 161558ef11aSdrh| 3520: 00 09 0d 87 6a 05 00 01 1b 00 03 62 6f 78 2d 32 ....j......box-2 162558ef11aSdrh| 3536: 2c 30 0d 8e 6d 05 00 01 1b 00 04 62 6f 78 2d 31 ,0..m......box-1 163558ef11aSdrh| 3552: 2c 39 0d 8e 09 05 00 01 1b 00 04 62 6f 78 2d 31 ,9.........box-1 164558ef11aSdrh| 3568: 2c 38 0d 8d 25 05 00 01 1b 00 04 62 6f 78 2d 31 ,8..%......box-1 165558ef11aSdrh| 3584: 2c 37 0d 8c 41 05 00 01 1b 00 04 62 6f 78 2d 31 ,7..A......box-1 166558ef11aSdrh| 3600: 2c 36 0d 8b 5d 05 00 01 1b 00 02 62 6f 78 2d 31 ,6..]......box-1 167558ef11aSdrh| 3616: 2c 35 0d 8a 79 05 00 01 1b 00 02 62 6f 78 2d 31 ,5..y......box-1 168558ef11aSdrh| 3632: 2c 34 0d 8a 15 05 00 01 1b 00 02 62 6f 78 2d 31 ,4.........box-1 169558ef11aSdrh| 3648: 2c 33 0d 89 31 05 00 01 1b 00 02 62 6f 78 2d 31 ,3..1......box-1 170558ef11aSdrh| 3664: 2c 32 0e e8 00 06 00 09 0d 87 69 05 00 01 1b 00 ,2........i..... 171558ef11aSdrh| 3680: 03 62 6f 78 2d 31 2c 30 0d 8e 6c 05 00 01 1b 00 .box-1,0..l..... 172558ef11aSdrh| 3696: 04 62 6f 78 2d 30 2c 39 0d 8e 08 05 00 01 1b 00 .box-0,9........ 173558ef11aSdrh| 3712: 04 62 6f 78 2d 30 2c 38 0d 8d 24 05 00 01 1b 00 .box-0,8..$..... 174558ef11aSdrh| 3728: 04 62 6f 78 2d 30 2c 37 0d 8c 40 05 00 01 1b 00 .box-0,7..@..... 175558ef11aSdrh| 3744: 04 62 6f 78 2d 30 2c 36 0d 8b 5c 05 00 01 1b 00 .box-0,6........ 176558ef11aSdrh| 3760: 02 62 6f 78 2d 30 2c 35 0d 8a 78 05 00 01 1b 00 .box-0,5..x..... 177558ef11aSdrh| 3776: 02 62 6f 78 2d 30 2c 34 0d 8a 14 05 00 01 1b 00 .box-0,4........ 178558ef11aSdrh| 3792: 02 62 6f 78 2d 30 2c 33 0d 89 30 05 00 01 1b 00 .box-0,3..0..... 179558ef11aSdrh| 3808: 02 62 6f 78 2d 30 2c 32 00 00 00 0f 00 09 1b 00 .box-0,2........ 180558ef11aSdrh| 3824: 62 6f 78 2d 30 2c 30 0d 0e 05 00 09 1d 00 74 6f box-0,0.......to 181558ef11aSdrh| 3840: 70 20 68 61 6c 66 10 0d 05 00 09 23 00 62 6f 74 p half.....#.bot 182558ef11aSdrh| 3856: 74 6f 6d 20 68 61 6c 66 0f 0c 02 05 09 01 00 72 tom half.......r 183558ef11aSdrh| 3872: 69 67 68 74 20 68 61 6c 66 0e 0b 05 00 09 1f 00 ight half....... 184558ef11aSdrh| 3888: 6c 65 66 74 20 68 61 6c 66 14 0a 05 00 09 2b 00 left half.....+. 185558ef11aSdrh| 3904: 74 68 65 20 77 68 6f 6c 65 20 74 68 69 6e 67 0d the whole thing. 186558ef11aSdrh| 3920: 09 05 00 09 1d 00 74 6f 70 20 65 64 67 65 10 08 ......top edge.. 187558ef11aSdrh| 3936: 05 00 09 23 00 62 6f 74 74 6f 6d 20 65 64 67 65 ...#.bottom edge 188558ef11aSdrh| 3952: 0f 07 05 00 09 21 00 72 69 67 68 74 20 65 64 67 .....!.right edg 189558ef11aSdrh| 3968: 65 0e 06 05 00 09 1f 00 6c 65 66 74 20 65 64 67 e.......left edg 190558ef11aSdrh| 3984: 65 0b 05 05 00 09 19 00 63 65 6e 74 65 72 17 04 e.......center.. 191558ef11aSdrh| 4000: 05 00 09 31 00 75 70 70 65 72 2d 72 69 67 68 74 ...1.upper-right 192558ef11aSdrh| 4016: 20 63 6f 72 6e 65 72 17 03 05 00 09 31 00 6c 6f corner.....1.lo 193558ef11aSdrh| 4032: 77 65 72 2d 72 69 67 68 74 20 63 6f 72 6e 65 72 wer-right corner 194558ef11aSdrh| 4048: 16 02 05 00 09 2f 00 75 70 70 65 72 2d 6c 65 66 ...../.upper-lef 195558ef11aSdrh| 4064: 74 20 63 6f 72 6e 65 72 06 00 05 00 01 00 00 03 t corner........ 196558ef11aSdrh| 4080: 0d 88 4f 05 00 01 1b 00 02 62 6f 78 2d 33 2c 31 ..O......box-3,1 197558ef11aSdrh| page 3 offset 8192 198558ef11aSdrh| 0: 05 00 00 00 01 0f fb 00 00 00 00 06 0f fb 00 00 ................ 199558ef11aSdrh| 384: 00 00 00 00 00 00 00 89 50 03 04 00 93 24 00 00 ........P....$.. 200558ef11aSdrh| 400: 00 11 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 201558ef11aSdrh| 688: 00 00 00 00 42 c8 00 00 42 4c 00 00 42 00 00 00 ....B...BL..B... 202558ef11aSdrh| 720: 03 eb 40 40 00 00 40 80 00 00 00 00 00 00 3f 80 ..@@..@.......?. 203558ef11aSdrh| 736: 00 00 00 00 00 00 00 00 03 ea 40 00 00 00 40 40 ..........@...@@ 204558ef11aSdrh| 752: 00 00 00 00 00 00 3f 80 00 00 00 00 00 00 00 00 ......?......... 205558ef11aSdrh| 768: 03 e9 3f 80 00 00 40 00 00 00 00 00 00 00 3f 80 ..?...@.......?. 206558ef11aSdrh| 784: 00 00 00 00 00 00 00 00 03 e8 00 00 00 00 3f 80 ..............?. 207558ef11aSdrh| 800: 00 00 00 00 00 00 3f 80 00 00 00 00 00 00 00 00 ......?......... 208558ef11aSdrh| 1616: 00 00 00 00 00 00 00 00 00 00 89 50 02 04 00 93 ...........P.... 209558ef11aSdrh| 1632: 24 00 00 00 33 00 00 00 00 00 00 00 01 00 00 00 $...3........... 210558ef11aSdrh| 1648: 00 41 20 00 00 00 00 00 00 41 0e 00 00 00 00 00 .A ......A...... 211558ef11aSdrh| 1664: 00 00 00 04 4f 40 40 00 00 40 80 00 00 3f 80 00 ....O@@..@...?.. 212558ef11aSdrh| 1680: 00 40 00 00 00 00 00 00 00 00 00 04 4e 40 00 00 [email protected]@.. 213558ef11aSdrh| 1696: 00 40 40 00 00 3f 80 00 00 40 00 00 00 00 00 00 .@@..?...@...... 214558ef11aSdrh| 1712: 00 00 00 04 4d 3f 80 00 00 40 00 00 00 3f 80 00 ....M?...@...?.. 215558ef11aSdrh| 1728: 00 40 00 00 00 00 00 00 00 00 00 04 4c 00 00 00 [email protected]... 216558ef11aSdrh| 1744: 00 3f 80 00 00 3f 80 00 00 40 00 00 00 00 00 00 .?...?...@...... 217558ef11aSdrh| 1760: 00 00 00 04 b3 40 40 00 00 40 80 00 00 40 00 00 .....@@..@...@.. 218558ef11aSdrh| 1776: 00 40 40 00 00 00 00 00 00 00 00 04 b2 40 00 00 .@@..........@.. 219558ef11aSdrh| 1792: 00 40 40 00 00 40 00 00 00 40 40 00 00 00 00 00 .@@..@...@@..... 220558ef11aSdrh| 1808: 00 00 00 04 b1 3f 80 00 00 40 00 00 00 40 00 00 .....?...@...@.. 221558ef11aSdrh| 1824: 00 40 40 00 00 00 00 00 00 00 00 04 b0 00 00 00 .@@............. 222558ef11aSdrh| 1840: 00 3f 80 00 00 40 00 00 00 40 40 00 00 00 00 00 .?...@...@@..... 223558ef11aSdrh| 1856: 00 00 00 05 17 40 40 00 00 40 80 00 00 40 40 00 .....@@..@...@@. 224558ef11aSdrh| 1872: 00 40 80 00 00 00 00 00 00 00 00 05 16 40 00 00 .@...........@.. 225558ef11aSdrh| 1888: 00 40 40 00 00 40 40 00 00 40 80 00 00 00 00 00 .@@..@@..@...... 226558ef11aSdrh| 1904: 00 00 00 05 15 3f 80 00 00 40 00 00 00 40 40 00 .....?...@...@@. 227558ef11aSdrh| 1920: 00 40 80 00 00 00 00 00 00 00 00 05 14 00 00 00 .@.............. 228558ef11aSdrh| 1936: 00 3f 80 00 00 40 40 00 00 40 80 00 00 00 00 00 .?...@@..@...... 229558ef11aSdrh| 1952: 00 00 00 05 7b 40 40 00 00 40 80 00 00 40 80 00 .....@@..@...@.. 230558ef11aSdrh| 1968: 00 40 a0 00 00 00 00 00 00 00 00 05 7a 40 00 00 [email protected]@.. 231558ef11aSdrh| 1984: 00 40 40 00 00 40 80 00 00 40 a0 00 00 00 00 00 .@@..@...@...... 232558ef11aSdrh| 2000: 00 00 00 05 79 3f 80 00 00 40 00 00 00 40 80 00 ....y?...@...@.. 233558ef11aSdrh| 2016: 00 40 a0 00 00 00 00 00 00 00 00 05 78 00 00 00 [email protected]... 234558ef11aSdrh| 2032: 00 3f 80 00 00 40 80 00 00 40 a0 00 00 00 00 00 .?...@...@...... 235558ef11aSdrh| 2048: 00 00 00 05 df 40 40 00 00 40 80 00 00 40 a0 00 .....@@..@...@.. 236558ef11aSdrh| 2064: 00 40 c0 00 00 00 00 00 00 00 00 05 de 40 00 00 .@...........@.. 237558ef11aSdrh| 2080: 00 40 40 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .@@..@...@...... 238558ef11aSdrh| 2096: 00 00 00 05 dd 3f 80 00 00 40 00 00 00 40 a0 00 .....?...@...@.. 239558ef11aSdrh| 2112: 00 40 c0 00 00 00 00 00 00 00 00 05 dc 00 00 00 .@.............. 240558ef11aSdrh| 2128: 00 3f 80 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .?...@...@...... 241558ef11aSdrh| 2144: 00 00 00 06 43 40 40 00 00 40 80 00 00 40 c0 00 ....C@@..@...@.. 242558ef11aSdrh| 2160: 00 40 e0 00 00 00 00 00 00 00 00 06 42 40 00 00 [email protected]@.. 243558ef11aSdrh| 2176: 00 40 40 00 00 40 c0 00 00 40 e0 00 00 00 00 00 .@@..@...@...... 244558ef11aSdrh| 2192: 00 00 00 06 41 3f 80 00 00 40 00 00 00 40 c0 00 ....A?...@...@.. 245558ef11aSdrh| 2208: 00 40 e0 00 00 00 00 00 00 00 00 06 40 00 00 00 .@..........@... 246558ef11aSdrh| 2224: 00 3f 80 00 00 40 c0 00 00 40 e0 00 00 00 00 00 .?...@...@...... 247558ef11aSdrh| 2240: 00 00 00 06 a7 40 40 00 00 40 80 00 00 40 e0 00 .....@@..@...@.. 248558ef11aSdrh| 2256: 00 41 00 00 00 00 00 00 00 00 00 06 a6 40 00 00 .A...........@.. 249558ef11aSdrh| 2272: 00 40 40 00 00 40 e0 00 00 41 00 00 00 00 00 00 .@@[email protected]...... 250558ef11aSdrh| 2288: 00 00 00 06 a5 3f 80 00 00 40 00 00 00 40 e0 00 .....?...@...@.. 251558ef11aSdrh| 2304: 00 41 00 00 00 00 00 00 00 00 00 06 a4 00 00 00 .A.............. 252558ef11aSdrh| 2320: 00 3f 80 00 00 40 e0 00 00 41 00 00 00 00 00 00 [email protected]...... 253558ef11aSdrh| 2336: 00 00 00 07 0a 40 00 00 00 40 40 00 00 41 00 00 .....@...@@..A.. 254558ef11aSdrh| 2352: 00 41 10 00 00 00 00 00 00 00 00 07 09 3f 80 00 .A...........?.. 255558ef11aSdrh| 2368: 00 40 00 00 00 41 00 00 00 41 10 00 00 00 00 00 [email protected]...... 256558ef11aSdrh| 2384: 00 00 00 07 08 00 00 00 00 3f 80 00 00 41 00 00 .........?...A.. 257558ef11aSdrh| 2400: 00 41 10 00 00 00 00 00 00 00 00 07 6e 40 00 00 .A..........n@.. 258558ef11aSdrh| 2416: 00 40 40 00 00 41 10 00 00 41 20 00 00 00 00 00 .@@..A...A ..... 259558ef11aSdrh| 2432: 00 00 00 07 6d 3f 80 00 00 40 00 00 00 41 10 00 ....m[email protected].. 260558ef11aSdrh| 2448: 00 41 20 00 00 00 00 00 00 00 00 07 6c 00 00 00 .A .........l... 261558ef11aSdrh| 2464: 00 3f 80 00 00 41 10 00 00 41 20 00 00 00 00 00 .?...A...A ..... 262558ef11aSdrh| 2480: 00 00 00 07 0b 40 40 00 00 40 80 00 00 41 00 00 .....@@[email protected].. 263558ef11aSdrh| 2496: 00 41 10 00 00 00 00 00 00 00 00 07 6f 40 40 00 .A..........o@@. 264558ef11aSdrh| 2512: 00 40 80 00 00 41 10 00 00 41 20 00 00 00 00 00 [email protected] ..... 265558ef11aSdrh| 2528: 00 00 00 03 ec 40 80 00 00 40 a0 00 00 00 00 00 .....@...@...... 266558ef11aSdrh| 2544: 00 3f 80 00 00 00 00 00 00 00 00 04 50 40 80 00 .?..........P@.. 267558ef11aSdrh| 2560: 00 40 a0 00 00 3f 80 00 00 40 00 00 00 00 00 00 .@...?...@...... 268558ef11aSdrh| 2576: 00 00 00 04 b4 40 80 00 00 40 a0 00 00 40 00 00 .....@...@...@.. 269558ef11aSdrh| 2592: 00 40 40 00 00 00 00 00 00 00 00 05 18 40 80 00 .@@..........@.. 270558ef11aSdrh| 2608: 00 40 a0 00 00 40 40 00 00 40 80 00 00 00 00 00 .@...@@..@...... 271558ef11aSdrh| 2624: 00 00 00 05 7c 40 80 00 00 40 a0 00 00 40 80 00 ....|@...@...@.. 272558ef11aSdrh| 2640: 00 40 a0 00 00 00 00 00 00 00 00 05 e0 40 80 00 .@...........@.. 273558ef11aSdrh| 2656: 00 40 a0 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .@...@...@...... 274558ef11aSdrh| 2672: 00 00 00 06 44 40 80 00 00 40 a0 00 00 40 c0 00 ....D@...@...@.. 275558ef11aSdrh| 2688: 00 40 e0 00 00 00 00 00 00 00 00 06 a8 40 80 00 .@...........@.. 276558ef11aSdrh| 2704: 00 40 a0 00 00 40 e0 00 00 41 00 00 00 00 00 00 .@...@...A...... 277558ef11aSdrh| 2720: 00 00 00 07 0c 40 80 00 00 40 a0 00 00 41 00 00 .....@...@...A.. 278558ef11aSdrh| 2736: 00 41 10 00 00 00 00 00 00 00 00 07 70 40 80 00 .A..........p@.. 279558ef11aSdrh| 2752: 00 40 a0 00 00 41 10 00 00 41 20 00 00 00 00 00 [email protected] ..... 280558ef11aSdrh| 2768: 00 00 00 03 ed 40 a0 00 00 40 c0 00 00 00 00 00 .....@...@...... 281558ef11aSdrh| 2784: 00 3f 80 00 00 00 00 00 00 00 00 04 51 40 a0 00 .?..........Q@.. 282558ef11aSdrh| 2800: 00 40 c0 00 00 3f 80 00 00 40 00 00 00 00 00 00 .@...?...@...... 283558ef11aSdrh| 2816: 00 00 00 04 b5 40 a0 00 00 40 c0 00 00 40 00 00 .....@...@...@.. 284558ef11aSdrh| 2832: 00 40 40 00 00 00 00 00 00 00 00 05 19 40 a0 00 .@@..........@.. 285558ef11aSdrh| 2848: 00 40 c0 00 00 40 40 00 00 40 80 00 00 89 50 01 .@...@@[email protected]. 286558ef11aSdrh| 2864: 04 00 93 24 00 01 00 02 00 00 00 00 00 00 00 03 ...$............ 287558ef11aSdrh| 2880: 00 00 00 00 40 80 00 00 00 00 00 00 3f 80 00 00 ....@.......?... 288558ef11aSdrh| 2896: 00 00 00 00 00 00 00 02 00 00 00 00 41 20 00 00 ............A .. 289558ef11aSdrh| 2912: 00 00 00 00 41 20 00 00 00 00 00 00 00 00 00 00 ....A .......... 290558ef11aSdrh| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 05 03 ................ 291558ef11aSdrh| page 4 offset 12288 292558ef11aSdrh| 0: 0d 00 00 00 00 10 00 00 00 00 00 00 00 00 00 00 ................ 293558ef11aSdrh| page 5 offset 16384 294558ef11aSdrh| 0: 0d 00 00 00 03 01 87 00 0b 2d 06 5a 01 87 00 00 .........-.Z.... 295558ef11aSdrh| 384: 00 00 00 00 00 00 00 89 50 03 04 00 93 24 00 00 ........P....$.. 296558ef11aSdrh| 400: 00 11 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 297558ef11aSdrh| 688: 00 00 00 00 42 c8 00 00 42 4c 00 00 42 00 00 00 ....B...BL..B... 298558ef11aSdrh| 720: 03 eb 40 40 00 00 40 80 00 00 00 00 00 00 3f 80 ..@@..@.......?. 299558ef11aSdrh| 736: 00 00 00 00 00 00 00 00 03 ea 40 00 00 00 40 40 ..........@...@@ 300558ef11aSdrh| 752: 00 00 00 00 00 00 3f 80 00 00 00 00 00 00 00 00 ......?......... 301558ef11aSdrh| 768: 03 e9 3f 80 00 00 40 00 00 00 00 00 00 00 3f 80 ..?...@.......?. 302558ef11aSdrh| 784: 00 00 00 00 00 00 00 00 03 e8 00 00 00 00 3f 80 ..............?. 303558ef11aSdrh| 800: 00 00 00 00 00 00 3f 80 00 00 00 00 00 00 00 00 ......?......... 304558ef11aSdrh| 1616: 00 00 00 00 00 00 00 00 00 00 89 50 02 04 00 93 ...........P.... 305558ef11aSdrh| 1632: 24 00 00 00 2d 00 00 00 00 00 00 04 4c 00 00 00 $...-.......L... 306558ef11aSdrh| 1648: 00 3f 80 00 00 3f 80 00 00 40 00 00 00 00 00 00 .?...?...@...... 307558ef11aSdrh| 1664: 00 00 00 04 b0 00 00 00 00 3f 80 00 00 40 00 00 .........?...@.. 308558ef11aSdrh| 1680: 00 40 40 00 00 00 00 00 00 00 00 05 14 00 00 00 .@@............. 309558ef11aSdrh| 1696: 00 3f 80 00 00 40 40 00 00 40 80 00 00 00 00 00 .?...@@..@...... 310558ef11aSdrh| 1712: 00 00 00 05 78 00 00 00 00 3f 80 00 00 40 80 00 ....x....?...@.. 311558ef11aSdrh| 1728: 00 40 a0 00 00 00 00 00 00 00 00 05 dc 00 00 00 .@.............. 312558ef11aSdrh| 1744: 00 3f 80 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .?...@...@...... 313558ef11aSdrh| 1760: 00 00 00 00 01 00 00 00 00 41 20 00 00 00 00 00 .........A ..... 314558ef11aSdrh| 1776: 00 41 0e 00 00 00 00 00 00 00 00 04 4d 3f 80 00 .A..........M?.. 315558ef11aSdrh| 1792: 00 40 00 00 00 3f 80 00 00 40 00 00 00 00 00 00 .@...?...@...... 316558ef11aSdrh| 1808: 00 00 00 04 b1 3f 80 00 00 40 00 00 00 40 00 00 .....?...@...@.. 317558ef11aSdrh| 1824: 00 40 40 00 00 00 00 00 00 00 00 05 15 3f 80 00 .@@..........?.. 318558ef11aSdrh| 1840: 00 40 00 00 00 40 40 00 00 40 80 00 00 00 00 00 .@...@@..@...... 319558ef11aSdrh| 1856: 00 00 00 05 79 3f 80 00 00 40 00 00 00 40 80 00 ....y?...@...@.. 320558ef11aSdrh| 1872: 00 40 a0 00 00 00 00 00 00 00 00 05 dd 3f 80 00 .@...........?.. 321558ef11aSdrh| 1888: 00 40 00 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .@...@...@...... 322558ef11aSdrh| 1904: 00 00 00 04 4e 40 00 00 00 40 40 00 00 3f 80 00 ....N@...@@..?.. 323558ef11aSdrh| 1920: 00 40 00 00 00 00 00 00 00 00 00 04 b2 40 00 00 .@...........@.. 324558ef11aSdrh| 1936: 00 40 40 00 00 40 00 00 00 40 40 00 00 00 00 00 .@@..@...@@..... 325558ef11aSdrh| 1952: 00 00 00 05 16 40 00 00 00 40 40 00 00 40 40 00 .....@...@@..@@. 326558ef11aSdrh| 1968: 00 40 80 00 00 00 00 00 00 00 00 05 7a 40 00 00 [email protected]@.. 327558ef11aSdrh| 1984: 00 40 40 00 00 40 80 00 00 40 a0 00 00 00 00 00 .@@..@...@...... 328558ef11aSdrh| 2000: 00 00 00 05 de 40 00 00 00 40 40 00 00 40 a0 00 .....@...@@..@.. 329558ef11aSdrh| 2016: 00 40 c0 00 00 00 00 00 00 00 00 04 4f 40 40 00 [email protected]@@. 330558ef11aSdrh| 2032: 00 40 80 00 00 3f 80 00 00 40 00 00 00 00 00 00 .@...?...@...... 331558ef11aSdrh| 2048: 00 00 00 04 b3 40 40 00 00 40 80 00 00 40 00 00 .....@@..@...@.. 332558ef11aSdrh| 2064: 00 40 40 00 00 00 00 00 00 00 00 05 17 40 40 00 .@@..........@@. 333558ef11aSdrh| 2080: 00 40 80 00 00 40 40 00 00 40 80 00 00 00 00 00 .@...@@..@...... 334558ef11aSdrh| 2096: 00 00 00 05 7b 40 40 00 00 40 80 00 00 40 80 00 .....@@..@...@.. 335558ef11aSdrh| 2112: 00 40 a0 00 00 00 00 00 00 00 00 05 df 40 40 00 .@...........@@. 336558ef11aSdrh| 2128: 00 40 80 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .@...@...@...... 337558ef11aSdrh| 2144: 00 00 00 03 ec 40 80 00 00 40 a0 00 00 00 00 00 .....@...@...... 338558ef11aSdrh| 2160: 00 3f 80 00 00 00 00 00 00 00 00 04 50 40 80 00 .?..........P@.. 339558ef11aSdrh| 2176: 00 40 a0 00 00 3f 80 00 00 40 00 00 00 00 00 00 .@...?...@...... 340558ef11aSdrh| 2192: 00 00 00 04 b4 40 80 00 00 40 a0 00 00 40 00 00 .....@...@...@.. 341558ef11aSdrh| 2208: 00 40 40 00 00 00 00 00 00 00 00 05 18 40 80 00 .@@..........@.. 342558ef11aSdrh| 2224: 00 40 a0 00 00 40 40 00 00 40 80 00 00 00 00 00 .@...@@..@...... 343558ef11aSdrh| 2240: 00 00 00 05 7c 40 80 00 00 40 a0 00 00 40 80 00 ....|@...@...@.. 344558ef11aSdrh| 2256: 00 40 a0 00 00 00 00 00 00 00 00 05 e0 40 80 00 .@...........@.. 345558ef11aSdrh| 2272: 00 40 a0 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .@...@...@...... 346558ef11aSdrh| 2288: 00 00 00 03 f0 41 00 00 00 41 10 00 00 00 00 00 .....A...A...... 347558ef11aSdrh| 2304: 00 3f 80 00 00 00 00 00 00 00 00 04 54 41 00 00 .?..........TA.. 348558ef11aSdrh| 2320: 00 41 10 00 00 3f 80 00 00 40 00 00 00 00 00 00 .A...?...@...... 349558ef11aSdrh| 2336: 00 00 00 04 b8 41 00 00 00 41 10 00 00 40 00 00 .....A...A...@.. 350558ef11aSdrh| 2352: 00 40 40 00 00 00 00 00 00 00 00 05 1c 41 00 00 .@@..........A.. 351558ef11aSdrh| 2368: 00 41 10 00 00 40 40 00 00 40 80 00 00 00 00 00 .A...@@..@...... 352558ef11aSdrh| 2384: 00 00 00 05 80 41 00 00 00 41 10 00 00 40 80 00 .....A...A...@.. 353558ef11aSdrh| 2400: 00 40 a0 00 00 00 00 00 00 00 00 05 e4 41 00 00 [email protected].. 354558ef11aSdrh| 2416: 00 41 10 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .A...@...@...... 355558ef11aSdrh| 2432: 00 00 00 06 48 41 00 00 00 41 10 00 00 40 c0 00 ....HA...A...@.. 356558ef11aSdrh| 2448: 00 40 e0 00 00 00 00 00 00 00 00 06 ac 41 00 00 [email protected].. 357558ef11aSdrh| 2464: 00 41 10 00 00 40 e0 00 00 41 00 00 00 00 00 00 [email protected]...... 358558ef11aSdrh| 2480: 00 00 00 07 10 41 00 00 00 41 10 00 00 41 00 00 .....A...A...A.. 359558ef11aSdrh| 2496: 00 41 10 00 00 00 00 00 00 00 00 03 f1 41 10 00 .A...........A.. 360558ef11aSdrh| 2512: 00 41 20 00 00 00 00 00 00 3f 80 00 00 00 00 00 .A ......?...... 361558ef11aSdrh| 2528: 00 00 00 04 55 41 10 00 00 41 20 00 00 3f 80 00 ....UA...A ..?.. 362558ef11aSdrh| 2544: 00 40 00 00 00 00 00 00 00 00 00 04 b9 41 10 00 [email protected].. 363558ef11aSdrh| 2560: 00 41 20 00 00 40 00 00 00 40 40 00 00 00 00 00 .A ..@...@@..... 364558ef11aSdrh| 2576: 00 00 00 05 1d 41 10 00 00 41 20 00 00 40 40 00 .....A...A ..@@. 365558ef11aSdrh| 2592: 00 40 80 00 00 00 00 00 00 00 00 05 81 41 10 00 [email protected].. 366558ef11aSdrh| 2608: 00 41 20 00 00 40 80 00 00 40 a0 00 00 00 00 00 .A ..@...@...... 367558ef11aSdrh| 2624: 00 00 00 05 e5 41 10 00 00 41 20 00 00 40 a0 00 .....A...A ..@.. 368558ef11aSdrh| 2640: 00 40 c0 00 00 00 00 00 00 00 00 06 49 41 10 00 [email protected].. 369558ef11aSdrh| 2656: 00 41 20 00 00 40 c0 00 00 40 e0 00 00 00 00 00 .A ..@...@...... 370558ef11aSdrh| 2672: 00 00 00 06 ad 41 10 00 00 41 20 00 00 40 e0 00 .....A...A ..@.. 371558ef11aSdrh| 2688: 00 41 00 00 00 00 00 00 00 00 00 07 11 41 10 00 .A...........A.. 372558ef11aSdrh| 2704: 00 41 20 00 00 41 00 00 00 41 10 00 00 00 00 00 .A ..A...A...... 373558ef11aSdrh| 2848: 00 00 00 00 00 00 00 00 00 00 00 00 00 89 50 01 ..............P. 374558ef11aSdrh| 2864: 04 00 93 24 00 01 00 04 00 00 00 00 00 00 00 03 ...$............ 375558ef11aSdrh| 2880: 00 00 00 00 40 80 00 00 00 00 00 00 3f 80 00 00 ....@.......?... 376558ef11aSdrh| 2896: 00 00 00 00 00 00 00 02 00 00 00 00 41 20 00 00 ............A .. 377558ef11aSdrh| 2912: 00 00 00 00 41 10 00 00 00 00 00 00 00 00 00 04 ....A........... 378558ef11aSdrh| 2928: 00 00 00 00 41 20 00 00 40 c0 00 00 41 20 00 00 ....A [email protected] .. 379558ef11aSdrh| 2944: 00 00 00 00 00 00 00 05 40 a0 00 00 41 00 00 00 [email protected]... 380558ef11aSdrh| 2960: 00 00 00 00 41 20 00 00 00 00 00 00 00 00 00 00 ....A .......... 381558ef11aSdrh| page 6 offset 20480 382558ef11aSdrh| 0: 0d 00 00 00 02 06 5a 00 0b 2d 06 5a 00 00 00 00 ......Z..-.Z.... 383558ef11aSdrh| 1616: 00 00 00 00 00 00 00 00 00 00 89 50 05 04 00 93 ...........P.... 384558ef11aSdrh| 1632: 24 00 00 00 1c 00 00 00 00 00 00 03 ed 40 a0 00 $............@.. 385558ef11aSdrh| 1648: 00 40 c0 00 00 00 00 00 00 3f 80 00 00 00 00 00 .@.......?...... 386558ef11aSdrh| 1664: 00 00 00 04 51 40 a0 00 00 40 c0 00 00 3f 80 00 ....Q@...@...?.. 387558ef11aSdrh| 1680: 00 40 00 00 00 00 00 00 00 00 00 04 b5 40 a0 00 .@...........@.. 388558ef11aSdrh| 1696: 00 40 c0 00 00 40 00 00 00 40 40 00 00 00 00 00 .@...@...@@..... 389558ef11aSdrh| 1712: 00 00 00 05 19 40 a0 00 00 40 c0 00 00 40 40 00 .....@...@...@@. 390558ef11aSdrh| 1728: 00 40 80 00 00 00 00 00 00 00 00 05 7d 40 a0 00 .@...........@.. 391558ef11aSdrh| 1744: 00 40 c0 00 00 40 80 00 00 40 a0 00 00 00 00 00 .@...@...@...... 392558ef11aSdrh| 1760: 00 00 00 05 e1 40 a0 00 00 40 c0 00 00 40 a0 00 .....@...@...@.. 393558ef11aSdrh| 1776: 00 40 c0 00 00 00 00 00 00 00 00 06 45 40 a0 00 [email protected]@.. 394558ef11aSdrh| 1792: 00 40 c0 00 00 40 c0 00 00 40 e0 00 00 00 00 00 .@...@...@...... 395558ef11aSdrh| 1808: 00 00 00 06 a9 40 a0 00 00 40 c0 00 00 40 e0 00 .....@...@...@.. 396558ef11aSdrh| 1824: 00 41 00 00 00 00 00 00 00 00 00 07 0d 40 a0 00 .A...........@.. 397558ef11aSdrh| 1840: 00 40 c0 00 00 41 00 00 00 41 10 00 00 00 00 00 [email protected]...... 398558ef11aSdrh| 1856: 00 00 00 03 ee 40 c0 00 00 40 e0 00 00 00 00 00 .....@...@...... 399558ef11aSdrh| 1872: 00 3f 80 00 00 00 00 00 00 00 00 04 52 40 c0 00 .?..........R@.. 400558ef11aSdrh| 1888: 00 40 e0 00 00 3f 80 00 00 40 00 00 00 00 00 00 .@...?...@...... 401558ef11aSdrh| 1904: 00 00 00 04 b6 40 c0 00 00 40 e0 00 00 40 00 00 .....@...@...@.. 402558ef11aSdrh| 1920: 00 40 40 00 00 00 00 00 00 00 00 05 1a 40 c0 00 .@@..........@.. 403558ef11aSdrh| 1936: 00 40 e0 00 00 40 40 00 00 40 80 00 00 00 00 00 .@...@@..@...... 404558ef11aSdrh| 1952: 00 00 00 05 7e 40 c0 00 00 40 e0 00 00 40 80 00 ....~@...@...@.. 405558ef11aSdrh| 1968: 00 40 a0 00 00 00 00 00 00 00 00 05 e2 40 c0 00 .@...........@.. 406558ef11aSdrh| 1984: 00 40 e0 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .@...@...@...... 407558ef11aSdrh| 2000: 00 00 00 06 46 40 c0 00 00 40 e0 00 00 40 c0 00 ....F@...@...@.. 408558ef11aSdrh| 2016: 00 40 e0 00 00 00 00 00 00 00 00 06 aa 40 c0 00 .@...........@.. 409558ef11aSdrh| 2032: 00 40 e0 00 00 40 e0 00 00 41 00 00 00 00 00 00 .@...@...A...... 410558ef11aSdrh| 2048: 00 00 00 07 0e 40 c0 00 00 40 e0 00 00 41 00 00 .....@...@...A.. 411558ef11aSdrh| 2064: 00 41 10 00 00 00 00 00 00 00 00 03 ef 40 e0 00 .A...........@.. 412558ef11aSdrh| 2080: 00 41 00 00 00 00 00 00 00 3f 80 00 00 00 00 00 .A.......?...... 413558ef11aSdrh| 2096: 00 00 00 04 53 40 e0 00 00 41 00 00 00 3f 80 00 [email protected]...?.. 414558ef11aSdrh| 2112: 00 40 00 00 00 00 00 00 00 00 00 04 b7 40 e0 00 .@...........@.. 415558ef11aSdrh| 2128: 00 41 00 00 00 40 00 00 00 40 40 00 00 00 00 00 .A...@...@@..... 416558ef11aSdrh| 2144: 00 00 00 05 1b 40 e0 00 00 41 00 00 00 40 40 00 [email protected]...@@. 417558ef11aSdrh| 2160: 00 40 80 00 00 00 00 00 00 00 00 05 7f 40 e0 00 .@...........@.. 418558ef11aSdrh| 2176: 00 41 00 00 00 40 80 00 00 40 a0 00 00 00 00 00 .A...@...@...... 419558ef11aSdrh| 2192: 00 00 00 05 e3 40 e0 00 00 41 00 00 00 40 a0 00 [email protected]...@.. 420558ef11aSdrh| 2208: 00 40 c0 00 00 00 00 00 00 00 00 06 47 40 e0 00 [email protected]@.. 421558ef11aSdrh| 2224: 00 41 00 00 00 40 c0 00 00 40 e0 00 00 00 00 00 .A...@...@...... 422558ef11aSdrh| 2240: 00 00 00 06 ab 40 e0 00 00 41 00 00 00 40 e0 00 [email protected]...@.. 423558ef11aSdrh| 2256: 00 41 00 00 00 00 00 00 00 00 00 07 0f 40 e0 00 .A...........@.. 424558ef11aSdrh| 2272: 00 41 00 00 00 41 00 00 00 41 10 00 00 00 00 00 .A...A...A...... 425558ef11aSdrh| 2288: 00 00 00 07 73 40 e0 00 00 41 00 00 00 41 10 00 [email protected].. 426558ef11aSdrh| 2304: 00 41 20 00 00 00 00 00 00 00 00 00 00 00 00 00 .A ............. 427558ef11aSdrh| 2848: 00 00 00 00 00 00 00 00 00 00 00 00 00 89 50 04 ..............P. 428558ef11aSdrh| 2864: 04 00 93 24 00 00 00 18 00 00 00 00 00 00 06 43 ...$...........C 429558ef11aSdrh| 2880: 40 40 00 00 40 80 00 00 40 c0 00 00 40 e0 00 00 @@..@...@...@... 430558ef11aSdrh| 2896: 00 00 00 00 00 00 06 42 40 00 00 00 40 40 00 00 .......B@...@@.. 431558ef11aSdrh| 2912: 40 c0 00 00 40 e0 00 00 00 00 00 00 00 00 06 41 @[email protected] 432558ef11aSdrh| 2928: 3f 80 00 00 40 00 00 00 40 c0 00 00 40 e0 00 00 ?...@...@...@... 433558ef11aSdrh| 2944: 00 00 00 00 00 00 06 40 00 00 00 00 3f 80 00 00 .......@....?... 434558ef11aSdrh| 2960: 40 c0 00 00 40 e0 00 00 00 00 00 00 00 00 06 44 @[email protected] 435558ef11aSdrh| 2976: 40 80 00 00 40 a0 00 00 40 c0 00 00 40 e0 00 00 @...@...@...@... 436558ef11aSdrh| 2992: 00 00 00 00 00 00 06 a7 40 40 00 00 40 80 00 00 ........@@..@... 437558ef11aSdrh| 3008: 40 e0 00 00 41 00 00 00 00 00 00 00 00 00 06 a6 @...A........... 438558ef11aSdrh| 3024: 40 00 00 00 40 40 00 00 40 e0 00 00 41 00 00 00 @...@@[email protected]... 439558ef11aSdrh| 3040: 00 00 00 00 00 00 06 a5 3f 80 00 00 40 00 00 00 ........?...@... 440558ef11aSdrh| 3056: 40 e0 00 00 41 00 00 00 00 00 00 00 00 00 06 a4 @...A........... 441558ef11aSdrh| 3072: 00 00 00 00 3f 80 00 00 40 e0 00 00 41 00 00 00 [email protected]... 442558ef11aSdrh| 3088: 00 00 00 00 00 00 06 a8 40 80 00 00 40 a0 00 00 ........@...@... 443558ef11aSdrh| 3104: 40 e0 00 00 41 00 00 00 00 00 00 00 00 00 07 0a @...A........... 444558ef11aSdrh| 3120: 40 00 00 00 40 40 00 00 41 00 00 00 41 10 00 00 @...@@..A...A... 445558ef11aSdrh| 3136: 00 00 00 00 00 00 07 09 3f 80 00 00 40 00 00 00 ........?...@... 446558ef11aSdrh| 3152: 41 00 00 00 41 10 00 00 00 00 00 00 00 00 07 08 A...A........... 447558ef11aSdrh| 3168: 00 00 00 00 3f 80 00 00 41 00 00 00 41 10 00 00 ....?...A...A... 448558ef11aSdrh| 3184: 00 00 00 00 00 00 07 0b 40 40 00 00 40 80 00 00 ........@@..@... 449558ef11aSdrh| 3200: 41 00 00 00 41 10 00 00 00 00 00 00 00 00 07 0c A...A........... 450558ef11aSdrh| 3216: 40 80 00 00 40 a0 00 00 41 00 00 00 41 10 00 00 @[email protected]... 451558ef11aSdrh| 3232: 00 00 00 00 00 00 07 6e 40 00 00 00 40 40 00 00 .......n@...@@.. 452558ef11aSdrh| 3248: 41 10 00 00 41 20 00 00 00 00 00 00 00 00 07 6d A...A .........m 453558ef11aSdrh| 3264: 3f 80 00 00 40 00 00 00 41 10 00 00 41 20 00 00 [email protected] .. 454558ef11aSdrh| 3280: 00 00 00 00 00 00 07 6c 00 00 00 00 3f 80 00 00 .......l....?... 455558ef11aSdrh| 3296: 41 10 00 00 41 20 00 00 00 00 00 00 00 00 07 6f A...A .........o 456558ef11aSdrh| 3312: 40 40 00 00 40 80 00 00 41 10 00 00 41 20 00 00 @@[email protected] .. 457558ef11aSdrh| 3328: 00 00 00 00 00 00 07 70 40 80 00 00 40 a0 00 00 .......p@...@... 458558ef11aSdrh| 3344: 41 10 00 00 41 20 00 00 00 00 00 00 00 00 07 71 A...A .........q 459558ef11aSdrh| 3360: 40 a0 00 00 40 c0 00 00 41 10 00 00 41 20 00 00 @[email protected] .. 460558ef11aSdrh| 3376: 00 00 00 00 00 00 07 72 40 c0 00 00 40 e0 00 00 .......r@...@... 461558ef11aSdrh| 3392: 41 10 00 00 41 20 00 00 00 00 00 00 00 00 07 74 A...A .........t 462558ef11aSdrh| 3408: 41 00 00 00 41 10 00 00 41 10 00 00 41 20 00 00 A...A...A...A .. 463558ef11aSdrh| 3424: 00 00 00 00 00 00 07 75 41 10 00 00 41 20 00 00 .......uA...A .. 464558ef11aSdrh| 3440: 41 10 00 00 41 20 00 00 00 00 00 00 00 00 00 00 A...A .......... 465558ef11aSdrh| end c1b.db 466558ef11aSdrh }] 467558ef11aSdrh catchsql { 4683c1970fcSdan PRAGMA writable_schema = 1; 469558ef11aSdrh SELECT rtreecheck('t1'); 470558ef11aSdrh } 471558ef11aSdrh} {1 {SQL logic error}} 472558ef11aSdrh 473fb077f3cSdrhdo_test rtreefuzz001-200 { 474fb077f3cSdrh sqlite3 db {} 475fb077f3cSdrh db deserialize [decode_hexdb { 476fb077f3cSdrh| size 16384 pagesize 4096 filename c3.db 477fb077f3cSdrh| page 1 offset 0 478fb077f3cSdrh| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. 479fb077f3cSdrh| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 04 .....@ ........ 480fb077f3cSdrh| 32: 00 00 00 00 01 00 00 00 00 00 00 04 00 00 00 04 ................ 481fb077f3cSdrh| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ 482fb077f3cSdrh| 96: 00 00 00 00 0d 00 00 00 04 0e 9c 00 0f ad 0f 4f ...............O 483fb077f3cSdrh| 112: 0e fc 0e 9c 00 00 00 00 00 00 00 00 00 00 00 00 ................ 484fb077f3cSdrh| 3728: 00 00 00 00 00 00 00 00 00 00 00 00 5e 04 07 17 ............^... 485fb077f3cSdrh| 3744: 1f 1f 01 81 0b 74 61 62 6c 65 74 31 5f 70 61 72 .....tablet1_par 486fb077f3cSdrh| 3760: 65 6e 74 74 31 5f 70 61 72 65 6e 74 04 43 52 45 entt1_parent.CRE 487cde4bf8bSdrh| 3776: 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 70 61 ATE TABLE .t1_pa 488cde4bf8bSdrh| 3792: 72 65 6e 74 22 28 6e 6f 64 65 6e 6f 20 49 4e 54 rent.(nodeno INT 489fb077f3cSdrh| 3808: 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 EGER PRIMARY KEY 490fb077f3cSdrh| 3824: 2c 70 61 72 65 6e 74 6e 6f 64 65 29 51 03 06 17 ,parentnode)Q... 491fb077f3cSdrh| 3840: 1b 1b 01 7b 74 61 62 6c 65 74 31 5f 6e 6f 64 65 ....tablet1_node 492fb077f3cSdrh| 3856: 74 31 5f 6e 6f 64 65 03 43 52 45 41 54 45 20 54 t1_node.CREATE T 493cde4bf8bSdrh| 3872: 41 42 4c 45 20 22 74 31 5f 6e 6f 64 65 22 28 6e ABLE .t1_node.(n 494fb077f3cSdrh| 3888: 6f 64 65 6e 6f 20 49 4e 54 45 47 45 52 20 50 52 odeno INTEGER PR 495cde4bf8bSdrh| 3904: 49 4d 41 52 59 20 4b 45 59 2c 64 61 74 61 29 5c IMARY KEY,data). 496fb077f3cSdrh| 3920: 02 07 17 1d 1d 01 81 0b 74 61 62 6c 65 74 31 5f ........tablet1_ 497fb077f3cSdrh| 3936: 72 6f 77 69 64 74 31 5f 72 6f 77 69 64 02 43 52 rowidt1_rowid.CR 498cde4bf8bSdrh| 3952: 45 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 72 EATE TABLE .t1_r 499cde4bf8bSdrh| 3968: 6f 77 69 64 22 28 72 6f 77 69 64 20 49 4e 54 45 owid.(rowid INTE 500fb077f3cSdrh| 3984: 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c GER PRIMARY KEY, 501fb077f3cSdrh| 4000: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 29 51 01 07 nodeno,a0,a1)Q.. 502fb077f3cSdrh| 4016: 17 11 11 08 81 0f 74 61 62 6c 65 74 31 74 31 43 ......tablet1t1C 503fb077f3cSdrh| 4032: 52 45 41 54 45 20 56 49 52 54 55 41 4c 20 54 41 REATE VIRTUAL TA 504fb077f3cSdrh| 4048: 42 4c 45 20 74 31 20 55 53 49 4e 47 20 72 74 72 BLE t1 USING rtr 505fb077f3cSdrh| 4064: 65 65 28 69 64 2c 78 30 2c 78 31 2c 79 30 2c 79 ee(id,x0,x1,y0,y 506fb077f3cSdrh| 4080: 31 2c 2b 6c 61 62 65 6c 2c 2b 6f 74 68 65 72 29 1,+label,+other) 507fb077f3cSdrh| page 2 offset 4096 508fb077f3cSdrh| 0: 0d 00 00 00 0e 0e f7 00 0f e8 0f d0 0f b7 0f 9e ................ 509fb077f3cSdrh| 16: 0f 91 0f 81 0f 70 0f 5e 0f 4f 0f 39 0f 29 0f 18 .....p.^.O.9.).. 510fb077f3cSdrh| 32: 0f 06 0e f7 00 00 00 00 00 00 00 00 00 00 00 00 ................ 511fb077f3cSdrh| 3824: 00 00 00 00 00 00 00 0d 0e 05 00 09 1d 00 74 6f ..............to 512fb077f3cSdrh| 3840: 70 20 68 61 6c 66 10 0d 05 00 09 23 00 62 6f 74 p half.....#.bot 513fb077f3cSdrh| 3856: 74 6f 6d 20 68 61 6c 66 0f 0c 05 00 09 21 00 72 tom half.....!.r 514fb077f3cSdrh| 3872: 69 67 68 74 20 68 61 6c 66 0e 0b 05 00 09 1f 00 ight half....... 515fb077f3cSdrh| 3888: 6c 65 66 74 20 68 61 6c 66 14 0a 05 00 09 2b 00 left half.....+. 516fb077f3cSdrh| 3904: 74 68 65 20 77 68 6f 6c 65 20 74 68 69 6e 67 0d the whole thing. 517fb077f3cSdrh| 3920: 09 05 00 09 1d 00 74 6f 70 20 65 64 67 65 10 08 ......top edge.. 518fb077f3cSdrh| 3936: 05 00 09 23 00 62 6f 74 74 6f 6d 20 65 64 67 65 ...#.bottom edge 519fb077f3cSdrh| 3952: 0f 07 05 00 09 21 00 72 69 67 68 74 20 65 64 67 .....!.right edg 520fb077f3cSdrh| 3968: 65 0e 06 05 00 09 1f 00 6c 65 66 74 20 65 64 67 e.......left edg 521fb077f3cSdrh| 3984: 65 0b 05 05 00 09 19 00 63 65 6e 74 65 72 17 04 e.......center.. 522fb077f3cSdrh| 4000: 05 00 09 31 00 75 70 70 65 72 2d 72 69 67 68 74 ...1.upper-right 523fb077f3cSdrh| 4016: 20 63 6f 72 6e 65 72 17 03 05 00 09 31 00 6c 6f corner.....1.lo 524fb077f3cSdrh| 4032: 77 65 72 2d 72 69 67 68 74 27 60 f6 32 6e 65 72 wer-right'`.2ner 525fb077f3cSdrh| 4048: 16 02 05 00 09 2f 00 75 70 70 65 72 2d 6c 65 66 ...../.upper-lef 526fb077f3cSdrh| 4064: 74 20 63 6f 72 6e 65 72 16 01 05 00 09 2f 00 6c t corner...../.l 527fb077f3cSdrh| 4080: 6f 77 65 72 2d 6c 65 66 74 20 63 6f 72 6e 65 72 ower-left corner 528fb077f3cSdrh| page 3 offset 8192 529fb077f3cSdrh| 0: 0d 00 00 00 02 0b 2d 00 0b 2d 00 00 00 00 00 00 ......-..-...... 530fb077f3cSdrh| 2848: 00 00 00 00 00 00 00 00 00 00 00 00 00 89 50 01 ..............P. 531fb077f3cSdrh| 2864: 04 00 93 24 00 00 00 0e 00 00 00 00 00 00 00 01 ...$............ 532fb077f3cSdrh| 2880: 00 00 00 00 41 20 00 00 00 00 00 00 41 20 01 00 ....A ......A .. 533fb077f3cSdrh| 2896: 00 00 00 00 00 00 00 02 00 00 00 00 41 00 00 04 ............A... 534fb077f3cSdrh| 2912: 2b 40 00 0c 42 c8 00 00 00 00 00 00 00 00 00 03 +@..B........... 535fb077f3cSdrh| 2928: 42 b4 00 00 42 c8 00 00 00 00 00 00 41 20 00 00 B...B.......A .. 536fb077f3cSdrh| 2944: 00 00 00 00 00 00 00 04 42 b4 00 00 42 c8 00 00 ........B...B... 537fb077f3cSdrh| 2960: 42 b4 00 00 42 c8 00 00 00 00 00 00 00 00 00 05 B...B........... 538fb077f3cSdrh| 2976: 42 20 00 00 42 70 00 00 42 20 00 00 42 70 00 00 B ..Bp..B ..Bp.. 539fb077f3cSdrh| 2992: 00 00 00 00 00 00 00 60 00 00 00 04 0a 00 00 00 .......`........ 540fb077f3cSdrh| 3008: 00 00 00 42 c8 00 00 00 00 00 00 00 00 00 07 42 ...B...........B 541fb077f3cSdrh| 3024: be 00 00 42 c8 00 00 00 00 00 00 42 c8 00 00 00 ...B.......B.... 542fb077f3cSdrh| 3040: 00 00 00 00 00 00 08 00 00 00 00 42 c8 00 00 00 ...........B.... 543fb077f3cSdrh| 3056: 00 00 00 40 a0 00 00 00 00 00 00 00 00 00 09 00 ...@............ 544fb077f3cSdrh| 3072: 00 00 00 42 c8 00 00 42 be 00 00 42 c8 00 00 00 ...B...B...B.... 545fb077f3cSdrh| 3088: 00 00 00 00 00 00 0a 00 00 00 00 42 c8 00 00 00 ...........B.... 546fb077f3cSdrh| 3104: 00 00 00 42 c8 00 00 00 00 00 00 00 00 00 0b 00 ...B............ 547fb077f3cSdrh| 3120: 00 00 00 42 48 00 00 00 00 00 04 2c 80 00 00 00 ...BH......,.... 548fb077f3cSdrh| 3136: 00 00 00 00 00 00 c4 24 c0 00 04 2c 80 00 00 00 .......$...,.... 549fb077f3cSdrh| 3152: 00 00 04 2c 80 00 00 00 00 00 00 00 00 00 d0 00 ...,............ 550fb077f3cSdrh| 3168: 00 00 04 2c 80 00 00 00 00 00 04 24 80 00 00 00 ...,.......$.... 551fb077f3cSdrh| 3184: 00 00 00 00 00 00 e0 00 00 00 04 2c 80 00 04 24 ...........,...$ 552fb077f3cSdrh| 3200: c0 00 04 2c 00 00 00 00 00 00 00 00 00 00 00 00 ...,............ 553fb077f3cSdrh| page 4 offset 12288 554fb077f3cSdrh| 0: 0d 00 00 00 00 10 00 00 00 00 00 00 00 00 00 00 ................ 555fb077f3cSdrh| end c3.db 556fb077f3cSdrh }] 557fb077f3cSdrh catchsql { 558fb077f3cSdrh WITH RECURSIVE 559fb077f3cSdrh c1(x) AS (VALUES(0) UNION ALL SELECT x+1 FROM c1 WHERE x<99), 560fb077f3cSdrh c2(y) AS (VALUES(0) UNION ALL SELECT y+1 FROM c2 WHERE y<99) 561fb077f3cSdrh INSERT INTO t1(id, x0,x1,y0,y1,label) 562fb077f3cSdrh SELECT 1000+x+y*100, x, x+1, y, y+1, printf('box-%d,%d',x,y) FROM c1, c2; 563fb077f3cSdrh } 564cde4bf8bSdrh} {1 {database disk image is malformed}} 565fb077f3cSdrhdo_test rtreefuzz001-210 { 566fb077f3cSdrh catchsql { 567fb077f3cSdrh SELECT rtreecheck('t1'); 568fb077f3cSdrh } 569cde4bf8bSdrh} {/1 .*corrupt.*/} 570fb077f3cSdrh 571273e01b4Sdrhdo_test rtreefuzz001-300 { 572273e01b4Sdrh sqlite3 db {} 573273e01b4Sdrh db deserialize [decode_hexdb { 574273e01b4Sdrh| size 16384 pagesize 4096 filename c4.db 575273e01b4Sdrh| page 1 offset 0 576273e01b4Sdrh| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. 577273e01b4Sdrh| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 04 .....@ ........ 578273e01b4Sdrh| 32: 00 00 00 00 00 00 00 00 00 00 00 04 00 00 00 04 ................ 579273e01b4Sdrh| 96: 00 00 00 00 0d 00 00 00 04 0e 9c 00 0f ad 0f 4f ...............O 580273e01b4Sdrh| 112: 0e fc 0e 9c 00 00 00 00 00 00 00 00 00 00 00 00 ................ 581273e01b4Sdrh| 3728: 00 00 00 00 00 00 00 00 00 00 00 00 5e 04 07 17 ............^... 582273e01b4Sdrh| 3744: 1f 1f 01 81 0b 74 61 62 6c 65 74 31 5f 70 61 72 .....tablet1_par 583273e01b4Sdrh| 3760: 65 6e 74 74 31 5f 70 61 72 65 6e 74 04 43 52 45 entt1_parent.CRE 584cde4bf8bSdrh| 3776: 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 70 61 ATE TABLE .t1_pa 585cde4bf8bSdrh| 3792: 72 65 6e 74 22 28 6e 6f 64 65 6e 6f 20 49 4e 54 rent.(nodeno INT 586273e01b4Sdrh| 3808: 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 EGER PRIMARY KEY 587273e01b4Sdrh| 3824: 2c 70 61 72 65 6e 74 6e 6f 64 65 29 51 03 06 17 ,parentnode)Q... 588273e01b4Sdrh| 3840: 1b 1b 01 7b 74 61 62 6c 65 74 31 5f 6e 6f 64 65 ....tablet1_node 589273e01b4Sdrh| 3856: 74 31 5f 6e 6f 64 65 03 43 52 45 41 54 45 20 54 t1_node.CREATE T 590cde4bf8bSdrh| 3872: 41 42 4c 45 20 22 74 31 5f 6e 6f 64 65 22 28 6e ABLE .t1_node.(n 591273e01b4Sdrh| 3888: 6f 64 65 6e 6f 20 49 4e 54 45 47 45 52 20 50 52 odeno INTEGER PR 592cde4bf8bSdrh| 3904: 49 4d 41 52 59 20 4b 45 59 2c 64 61 74 61 29 5c IMARY KEY,data). 593273e01b4Sdrh| 3920: 02 07 17 1d 1d 01 81 0b 74 61 62 6c 65 74 31 5f ........tablet1_ 594273e01b4Sdrh| 3936: 72 6f 77 69 64 74 31 5f 72 6f 77 69 64 02 43 52 rowidt1_rowid.CR 595cde4bf8bSdrh| 3952: 45 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 72 EATE TABLE .t1_r 596cde4bf8bSdrh| 3968: 6f 77 69 64 22 28 72 6f 77 69 64 20 49 4e 54 45 owid.(rowid INTE 597273e01b4Sdrh| 3984: 47 45 72 20 50 52 49 4d 41 52 59 20 4b 45 59 2c GEr PRIMARY KEY, 598273e01b4Sdrh| 4000: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 29 51 01 07 nodeno,a0,a1)Q.. 599273e01b4Sdrh| 4016: 17 11 11 08 81 0f 74 61 62 6c 65 74 31 74 31 43 ......tablet1t1C 600273e01b4Sdrh| 4032: 52 45 41 54 45 20 56 49 52 54 55 41 4c 20 54 41 REATE VIRTUAL TA 601273e01b4Sdrh| 4048: 42 4c 45 20 74 31 20 55 53 49 4e 47 20 72 74 72 BLE t1 USING rtr 602273e01b4Sdrh| 4064: 65 65 28 69 64 2c 78 30 2c 78 31 2c 79 30 2c 79 ee(id,x0,x1,y0,y 603273e01b4Sdrh| 4080: 31 2c 2b 6c 61 62 65 6c 2c 2b 6f 74 68 65 72 29 1,+label,+other) 604273e01b4Sdrh| page 2 offset 4096 605273e01b4Sdrh| 0: 0d 00 00 00 0e 0e f7 00 0f e8 0f 00 fb 70 f9 e0 .............p.. 606273e01b4Sdrh| 16: f9 10 f8 10 f7 00 f5 e0 f4 f0 f3 90 f2 90 f1 80 ................ 607273e01b4Sdrh| 32: f0 60 ef 00 00 00 00 00 00 00 00 00 00 00 00 00 .`.............. 608273e01b4Sdrh| 3824: 00 00 00 00 00 00 00 0d 0e 05 00 09 1d 00 74 6f ..............to 609273e01b4Sdrh| 3840: 70 20 68 61 6c 66 10 0d 05 00 09 23 00 62 6f 74 p half.....#.bot 610273e01b4Sdrh| 3856: 74 6f 6d 20 68 61 6c 66 0f 0c 05 00 09 21 00 72 tom half.....!.r 611273e01b4Sdrh| 3872: 69 67 68 74 20 68 61 6c 66 0e 0b 05 00 09 1f 00 ight half....... 612273e01b4Sdrh| 3888: 6c 65 66 74 20 68 61 6c 66 14 0a 05 00 09 2b 00 left half.....+. 613273e01b4Sdrh| 3904: 00 03 98 20 49 98 2f 6c 62 05 74 68 69 6e 67 0d ... I./lb.thing. 614273e01b4Sdrh| 3920: 09 05 00 09 1d 00 74 6f 70 20 65 64 67 65 10 08 ......top edge.. 615273e01b4Sdrh| 3936: 05 00 09 23 00 62 6f 74 74 6f 6d 20 65 64 67 65 ...#.bottom edge 616273e01b4Sdrh| 3952: 0f 07 05 00 09 21 00 72 69 67 68 74 20 65 64 67 .....!.right edg 617273e01b4Sdrh| 3968: 65 0e 06 05 00 09 1f 00 6c 65 66 74 20 65 64 67 e.......left edg 618273e01b4Sdrh| 3984: 65 0b 05 05 00 09 19 00 63 65 6e 74 65 72 17 04 e.......center.. 619273e01b4Sdrh| 4000: 05 00 09 31 00 75 70 70 65 72 2d 72 69 67 68 74 ...1.upper-right 620273e01b4Sdrh| 4016: 20 63 6f 72 6e 65 72 17 03 05 00 09 31 00 6c 6f corner.....1.lo 621273e01b4Sdrh| 4032: 77 65 72 2d 72 69 67 68 74 20 63 6f 72 6e 65 72 wer-right corner 622273e01b4Sdrh| 4048: 16 02 05 00 09 2f 00 75 70 70 65 72 2d 6c 65 66 ...../.upper-lef 623273e01b4Sdrh| 4064: 74 20 63 6f 72 6e 65 72 16 01 05 00 09 2f 00 6c t corner...../.l 624273e01b4Sdrh| 4080: 6f 77 65 72 2d 6c 65 66 74 20 63 6f 72 6e 65 72 ower-left corner 625273e01b4Sdrh| page 3 offset 8192 626273e01b4Sdrh| 0: 0d 00 00 00 01 0b 2d 00 0b 2d 00 00 00 00 00 00 ......-..-...... 627273e01b4Sdrh| 2848: 00 00 00 00 00 00 00 00 00 00 00 00 00 89 50 01 ..............P. 628273e01b4Sdrh| 2864: 04 00 93 24 00 00 00 0e 00 00 00 00 00 00 00 01 ...$............ 629273e01b4Sdrh| 2880: 00 00 00 04 01 20 00 00 00 00 00 04 12 00 00 00 ..... .......... 630273e01b4Sdrh| 2896: 00 00 00 00 00 00 00 23 00 00 00 00 41 20 00 00 .......#....A .. 631273e01b4Sdrh| 2912: 42 b4 00 00 42 c8 00 00 00 00 00 00 00 00 00 03 B...B........... 632273e01b4Sdrh| 2928: 42 b4 00 00 42 c8 00 00 00 00 00 00 41 20 00 00 B...B.......A .. 633273e01b4Sdrh| 2944: 00 00 00 00 00 00 00 04 42 b4 00 00 42 c8 00 00 ........B...B... 634273e01b4Sdrh| 2960: 42 b4 00 00 42 c8 00 00 00 00 00 00 00 00 00 05 B...B........... 635273e01b4Sdrh| 2976: 42 20 00 00 42 70 00 00 42 20 00 00 42 70 00 00 B ..Bp..B ..Bp.. 636273e01b4Sdrh| 2992: 00 00 00 00 00 00 00 06 00 00 00 00 40 a0 00 00 ............@... 637273e01b4Sdrh| 3008: 00 00 00 04 2c 80 00 00 00 00 00 00 00 00 00 74 ....,..........t 638273e01b4Sdrh| 3024: 2b e0 00 04 2c 80 00 04 2c 80 00 00 00 00 00 00 +...,...,....... 639273e01b4Sdrh| 3040: 00 00 00 80 00 00 00 04 2c 80 00 00 00 00 00 04 ........,....... 640273e01b4Sdrh| 3056: 0a 00 00 00 00 00 b0 80 00 00 04 2c 80 00 04 2b ...........,...+ 641273e01b4Sdrh| 3072: e0 00 04 2c 80 00 00 00 00 00 00 00 00 00 a0 00 ...,............ 642273e01b4Sdrh| 3088: 00 00 04 2c 80 00 00 00 00 00 04 2c 80 00 00 00 ...,.......,.... 643273e01b4Sdrh| 3104: 00 00 00 00 00 00 b0 00 00 00 04 24 80 00 00 00 ...........$.... 644273e01b4Sdrh| 3120: 00 00 04 2c 80 00 00 00 00 00 00 00 50 00 91 f0 ...,........P... 645273e01b4Sdrh| 3136: 06 c6 56 67 42 06 86 16 c6 61 40 a0 50 00 92 b0 [email protected]... 646273e01b4Sdrh| 3152: 07 46 86 52 07 76 86 f6 c6 52 07 46 86 96 e6 70 .F.R.v...R.F...p 647273e01b4Sdrh| 3168: d0 90 50 00 91 d0 07 46 f7 02 06 56 46 76 51 00 ..P....F...VFvQ. 648273e01b4Sdrh| 3184: 80 50 00 92 30 06 26 f7 47 46 f6 d2 06 56 46 76 .P..0.&.GF...VFv 649273e01b4Sdrh| 3200: 50 f0 70 50 00 92 10 07 26 96 76 87 42 06 56 46 P.pP....&.v.B.VF 650273e01b4Sdrh| 3216: 76 50 e0 60 50 00 91 f0 06 c6 56 67 42 06 56 46 vP.`P.....VgB.VF 651273e01b4Sdrh| 3232: 76 50 b0 50 50 00 91 90 06 36 56 e7 46 57 21 70 vP.PP....6V.FW!p 652cde4bf8bSdrh| 3248: 40 50 00 93 10 07 57 07 06 57 22 d7 26 96 76 87 @P....W..W..&.v. 653273e01b4Sdrh| 3264: 42 06 36 f7 26 e6 57 21 70 30 50 00 93 10 06 c6 B.6.&.W!p0P..... 654cde4bf8bSdrh| 3280: f7 76 57 22 d7 26 96 76 87 42 06 36 f7 26 e6 57 .vW..&.v.B.6.&.W 655cde4bf8bSdrh| 3296: 21 60 20 50 00 92 f0 07 57 07 06 57 22 d6 c6 56 !` P....W..W...V 656273e01b4Sdrh| 3312: 60 00 00 c4 24 c0 00 04 2c 80 00 00 00 00 00 04 `...$...,....... 657273e01b4Sdrh| 3328: 2c 80 00 00 00 00 00 00 00 00 00 d0 00 00 00 04 ,............... 658273e01b4Sdrh| 3344: 2c 80 00 00 00 00 00 04 24 80 00 00 00 00 00 00 ,.......$....... 659273e01b4Sdrh| 3360: 00 00 00 e0 00 00 00 04 2c 80 00 04 24 c0 00 04 ........,...$... 660273e01b4Sdrh| 3376: 2c 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ,............... 661273e01b4Sdrh| page 4 offset 12288 662273e01b4Sdrh| 0: 0d 00 00 00 00 10 00 00 00 00 00 00 00 00 00 00 ................ 663273e01b4Sdrh| end c4.db 664273e01b4Sdrh }] 665273e01b4Sdrh catchsql { 666273e01b4Sdrh UPDATE t1 SET label='x'; 667273e01b4Sdrh } 668cde4bf8bSdrh} {1 {rtree constraint failed: t1.(y0<=y1)}} 669273e01b4Sdrhdo_test rtreefuzz001-310 { 670273e01b4Sdrh catchsql { 671273e01b4Sdrh SELECT rtreecheck('t1'); 672273e01b4Sdrh } 673cde4bf8bSdrh} {/1 .*corrupt.*/} 674273e01b4Sdrh 675cde4bf8bSdrhdo_test rtreefuzz001-400 { 676cde4bf8bSdrh sqlite3 db {} 677cde4bf8bSdrh db deserialize [decode_hexdb { 678cde4bf8bSdrh| size 16384 pagesize 4096 filename c7.db 679cde4bf8bSdrh| page 1 offset 0 680cde4bf8bSdrh| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. 681cde4bf8bSdrh| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 04 .....@ ........ 682cde4bf8bSdrh| 32: 00 00 00 00 01 00 00 00 00 00 00 04 00 00 00 04 ................ 683cde4bf8bSdrh| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ 684cde4bf8bSdrh| 96: 00 00 00 00 0d 00 00 00 04 0e 9c 00 0f ad 0f 4f ...............O 685cde4bf8bSdrh| 112: 0e fc 0e 9c 00 00 00 00 00 00 00 00 00 00 00 00 ................ 686cde4bf8bSdrh| 3728: 00 00 00 00 00 00 00 00 00 00 00 00 5e 04 07 17 ............^... 687cde4bf8bSdrh| 3744: 1f 1f 01 81 0b 74 61 62 6c 65 74 31 5f 70 61 72 .....tablet1_par 688cde4bf8bSdrh| 3760: 65 6e 74 74 31 5f 70 61 72 65 6e 74 04 43 52 45 entt1_parent.CRE 689cde4bf8bSdrh| 3776: 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 70 61 ATE TABLE .t1_pa 690cde4bf8bSdrh| 3792: 72 65 6e 74 22 28 6e 6f 64 65 6e 6f 20 49 4e 54 rent.(nodeno INT 691cde4bf8bSdrh| 3808: 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 EGER PRIMARY KEY 692cde4bf8bSdrh| 3824: 2c 70 61 72 65 6e 74 6e 6f 64 65 29 51 03 06 17 ,parentnode)Q... 693cde4bf8bSdrh| 3840: 1b 1b 01 7b 74 61 62 6c 65 74 31 5f 6e 6f 64 65 ....tablet1_node 694cde4bf8bSdrh| 3856: 74 31 5f 6e 6f 64 65 03 43 52 45 41 54 45 20 54 t1_node.CREATE T 695cde4bf8bSdrh| 3872: 41 42 4c 45 20 22 74 31 5f 6e 6f 64 65 22 28 6e ABLE .t1_node.(n 696cde4bf8bSdrh| 3888: 6f 64 65 6e 6f 20 49 4e 54 45 47 45 52 20 50 52 odeno INTEGER PR 697cde4bf8bSdrh| 3904: 49 4d 41 52 59 20 4b 45 59 2c 64 61 74 61 29 5c IMARY KEY,data). 698cde4bf8bSdrh| 3920: 02 07 17 1d 1d 01 81 0b 74 61 62 6c 65 74 31 5f ........tablet1_ 699cde4bf8bSdrh| 3936: 72 6f 77 69 64 74 31 5f 72 6f 77 69 64 02 43 52 rowidt1_rowid.CR 700cde4bf8bSdrh| 3952: 45 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 72 EATE TABLE .t1_r 701cde4bf8bSdrh| 3968: 6f 77 69 64 22 28 72 6f 77 69 64 20 49 4e 54 45 owid.(rowid INTE 702cde4bf8bSdrh| 3984: 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c GER PRIMARY KEY, 703cde4bf8bSdrh| 4000: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 29 51 01 07 nodeno,a0,a1)Q.. 704cde4bf8bSdrh| 4016: 17 11 11 08 81 0f 74 61 62 6c 65 74 31 74 31 43 ......tablet1t1C 705cde4bf8bSdrh| 4032: 52 45 41 54 45 20 56 49 52 54 55 41 4c 20 54 41 REATE VIRTUAL TA 706cde4bf8bSdrh| 4048: 42 4c 45 20 74 31 20 55 53 49 4e 47 20 72 74 72 BLE t1 USING rtr 707cde4bf8bSdrh| 4064: 65 65 28 69 64 2c 78 30 2c 78 31 2c 79 30 2c 79 ee(id,x0,x1,y0,y 708cde4bf8bSdrh| 4080: 31 2c 2b 6c 61 62 65 6c 2c 2b 6f 74 68 65 72 29 1,+label,+other) 709cde4bf8bSdrh| page 2 offset 4096 710cde4bf8bSdrh| 0: 0d 00 00 00 0e 0e f7 00 0f e8 0f d0 0f b7 0f 9e ................ 711cde4bf8bSdrh| 16: 0f 91 0f 81 0f 70 0f 5e 0f 4f 0f 39 0f 29 0f 18 .....p.^.O.9.).. 712cde4bf8bSdrh| 32: 0f 06 0e f7 00 00 00 00 00 00 00 00 00 00 00 00 ................ 713cde4bf8bSdrh| 3824: 00 00 00 00 00 00 00 0d 0e 05 00 09 1d 00 74 6f ..............to 714cde4bf8bSdrh| 3840: 70 20 68 61 6c 66 10 0d 05 00 09 23 00 62 6f 74 p half.....#.bot 715cde4bf8bSdrh| 3856: 74 6f 6d 20 68 61 6c 66 0f 0c 05 00 09 21 00 72 tom half.....!.r 716cde4bf8bSdrh| 3872: 69 67 68 74 20 68 61 6c 66 0e 0b 05 00 09 1f 00 ight half....... 717cde4bf8bSdrh| 3888: 6c 65 66 74 20 68 61 6c 66 14 0a 05 00 09 2b 00 left half.....+. 718cde4bf8bSdrh| 3904: 74 68 65 20 77 68 6f 6c 65 20 74 68 69 6e 67 0d the whole thing. 719cde4bf8bSdrh| 3920: 09 05 00 09 1d 00 74 6f 70 20 65 64 67 65 10 08 ......top edge.. 720cde4bf8bSdrh| 3936: 05 00 09 23 00 62 6f 74 74 6f 6d 20 65 64 67 65 ...#.bottom edge 721cde4bf8bSdrh| 3952: 0f 07 05 00 09 21 00 72 69 67 68 74 20 65 64 67 .....!.right edg 722cde4bf8bSdrh| 3968: 65 0e 06 05 00 09 1f 00 6c 65 66 74 20 65 64 67 e.......left edg 723cde4bf8bSdrh| 3984: 65 0b 05 05 00 09 19 00 23 65 6e 74 65 72 17 04 e.......#enter.. 724cde4bf8bSdrh| 4000: 05 00 09 31 00 75 70 70 65 72 2d 72 69 67 68 74 ...1.upper-right 725cde4bf8bSdrh| 4016: 20 63 6f 72 6e 65 72 17 03 05 00 09 31 00 6c 6f corner.....1.lo 726cde4bf8bSdrh| 4032: 77 65 72 2d 72 69 67 68 74 20 63 6f 72 6e 65 72 wer-right corner 727cde4bf8bSdrh| 4048: 16 02 05 00 09 2f 00 75 70 70 65 72 2d 6c 65 66 ...../.upper-lef 728cde4bf8bSdrh| 4064: 74 20 63 6f 72 6e 65 72 16 01 05 00 09 2f 00 6c t corner...../.l 729cde4bf8bSdrh| 4080: 6f 77 65 72 2d 6c 65 66 74 20 63 6f 72 6e 65 72 ower-left corner 730cde4bf8bSdrh| page 3 offset 8192 731cde4bf8bSdrh| 0: 0d 00 00 00 02 0b 2d 00 0b 2d 00 00 00 00 00 00 ......-..-...... 732cde4bf8bSdrh| 2848: 00 00 00 00 00 00 00 00 00 00 00 00 00 89 50 01 ..............P. 733cde4bf8bSdrh| 2864: 04 00 93 24 00 00 00 00 00 00 00 00 08 00 00 00 ...$............ 734cde4bf8bSdrh| 2880: 00 42 c8 00 00 00 00 00 00 40 a0 00 00 00 00 00 .B.......@...... 735cde4bf8bSdrh| 2896: 00 00 00 00 42 c8 00 00 00 00 00 00 00 00 00 07 ....B........... 736cde4bf8bSdrh| 2912: 42 be 00 00 42 c8 00 00 00 00 00 00 42 c8 00 00 B...B.......B... 737cde4bf8bSdrh| 2928: 00 00 00 00 00 00 00 08 00 00 00 00 42 c8 00 00 ............B... 738cde4bf8bSdrh| 2944: 00 00 00 00 40 a0 00 00 00 00 00 00 00 00 00 09 ....@........... 739cde4bf8bSdrh| 2960: 00 00 00 00 42 c8 00 00 42 be 00 00 42 c8 00 00 ....B...B...B... 740cde4bf8bSdrh| 2976: 00 00 00 00 00 00 00 0a 00 00 00 00 42 c8 00 00 ............B... 741cde4bf8bSdrh| 2992: 00 00 00 00 42 c8 00 00 00 00 00 00 00 00 00 0b ....B........... 742cde4bf8bSdrh| 3008: 00 00 00 00 42 48 00 00 00 00 00 04 2c 80 00 00 ....BH......,... 743cde4bf8bSdrh| 3024: 00 00 00 00 00 00 00 c4 00 00 00 00 00 42 c8 00 .............B.. 744cde4bf8bSdrh| 3040: 00 00 00 00 00 00 00 00 07 42 be 00 00 42 c8 00 .........B...B.. 745cde4bf8bSdrh| 3056: 00 00 00 00 00 42 c8 00 00 00 00 00 00 00 00 00 .....B.......... 746cde4bf8bSdrh| 3072: 08 00 00 00 00 42 c8 00 00 00 00 00 00 40 a0 00 .....B.......@.. 747cde4bf8bSdrh| 3088: 00 00 00 00 00 00 00 00 09 00 00 00 00 42 c8 00 .............B.. 748cde4bf8bSdrh| 3104: 00 42 be 00 00 42 c8 00 00 00 00 00 00 00 00 00 .B...B.......... 749cde4bf8bSdrh| 3120: 0a 00 00 00 00 42 c8 00 00 00 00 00 00 42 c8 00 .....B.......B.. 750cde4bf8bSdrh| 3136: 00 00 00 00 00 00 00 00 0b 00 00 00 00 42 48 00 .............BH. 751cde4bf8bSdrh| 3152: 00 00 00 00 04 2c 80 00 00 00 00 00 00 00 00 00 .....,.......... 752cde4bf8bSdrh| 3168: c4 24 c0 00 04 2c 80 00 00 00 00 00 04 2c 80 00 .$...,.......,.. 753cde4bf8bSdrh| 3184: 00 00 00 00 00 00 00 00 d0 00 00 00 04 2c 80 00 .............,.. 754cde4bf8bSdrh| 3200: 00 00 00 00 04 24 80 00 00 00 00 00 00 00 00 00 .....$.......... 755cde4bf8bSdrh| 3216: e0 00 00 00 04 2c 80 00 04 24 c0 00 04 2c 00 00 .....,...$...,.. 756cde4bf8bSdrh| page 4 offset 12288 757cde4bf8bSdrh| 0: 0d 00 00 00 00 10 00 00 00 00 00 00 0e 00 00 00 ................ 758cde4bf8bSdrh| 16: 00 42 c8 00 00 42 4c 00 00 42 c8 00 00 00 00 00 .B...BL..B...... 759cde4bf8bSdrh| 32: 00 00 00 0a 00 00 00 00 42 c8 00 00 00 00 00 00 ........B....... 760cde4bf8bSdrh| 48: 42 c8 00 00 00 00 00 00 00 00 00 0b 00 00 00 00 B............... 761cde4bf8bSdrh| 64: 42 48 00 00 00 00 00 04 2c 80 00 00 00 00 00 00 BH......,....... 762cde4bf8bSdrh| 80: 00 00 00 c4 24 c0 00 04 2c 80 00 00 00 00 00 04 ....$...,....... 763cde4bf8bSdrh| 96: 2c 80 00 00 00 00 00 00 00 00 00 d0 00 00 00 04 ,............... 764cde4bf8bSdrh| 112: 2c 80 00 00 00 00 00 04 24 80 00 00 00 00 00 00 ,.......$....... 765cde4bf8bSdrh| 128: 00 00 00 e0 00 00 00 04 2c 80 00 04 24 c0 00 04 ........,...$... 766cde4bf8bSdrh| 144: 2c 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ,............... 767cde4bf8bSdrh| end c7.db 768cde4bf8bSdrh }] 769cde4bf8bSdrh catchsql { 770cde4bf8bSdrh WITH RECURSIVE 771cde4bf8bSdrh c1(x) AS (VALUES(0) UNION ALL SELECT x+1 FROM c1 WHERE x<8), 772cde4bf8bSdrh c2(y) AS (VALUES(0) UNION ALL SELECT y+1 FROM c2 WHERE y<5) 773cde4bf8bSdrh INSERT INTO t1(id, x0,x1,y0,y1,label) 774cde4bf8bSdrh SELECT 1000+x+y*100, x, x+1, y, y+1, printf('box-%d,%d',x,y) FROM c1, c2; 775cde4bf8bSdrh } 776cde4bf8bSdrh} {1 {database disk image is malformed}} 777273e01b4Sdrh 7788fbcb048Sdrhdo_test rtreefuzz001-500 { 7798fbcb048Sdrh sqlite3 db {} 7808fbcb048Sdrh db deserialize [decode_hexdb { 7818fbcb048Sdrh| size 16384 pagesize 4096 filename crash-2e81f5dce5cbd4.db 7828fbcb048Sdrh| page 1 offset 0 7838fbcb048Sdrh| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. 7848fbcb048Sdrh| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 00 .....@ ........ 7858fbcb048Sdrh| 96: 00 00 00 00 0d 00 00 00 05 0e 6d 00 0f c8 0f 7b ..........m..... 7868fbcb048Sdrh| 112: 0f 20 0e cd 0e 6d 00 00 00 00 00 00 00 00 00 00 . ...m.......... 7878fbcb048Sdrh| 3680: 00 00 00 00 00 00 00 00 00 00 00 00 00 5e 05 07 .............^.. 7888fbcb048Sdrh| 3696: 17 1f 1f 01 81 0b 74 61 62 6c 65 74 31 5f 70 61 ......tablet1_pa 7898fbcb048Sdrh| 3712: 72 65 6e 74 74 31 5f 70 61 72 65 6e 74 05 43 52 rentt1_parent.CR 7908fbcb048Sdrh| 3728: 45 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 70 EATE TABLE .t1_p 7918fbcb048Sdrh| 3744: 61 72 65 6e 74 22 28 6e 6f 64 65 6e 6f 20 49 4e arent.(nodeno IN 7928fbcb048Sdrh| 3760: 54 45 47 45 42 20 50 52 49 4d 41 52 59 20 4b 45 TEGEB PRIMARY KE 7938fbcb048Sdrh| 3776: 59 2c 70 61 72 65 6e 74 6e 6f 64 65 29 51 04 06 Y,parentnode)Q.. 7948fbcb048Sdrh| 3792: 17 1b 1b 01 7b 74 61 62 6c 65 74 31 5f 6e 6f 64 .....tablet1_nod 7958fbcb048Sdrh| 3808: 65 74 31 5f 6e 6f 64 65 04 43 52 45 41 54 45 20 et1_node.CREATE 7968fbcb048Sdrh| 3824: 54 41 42 4c 45 20 22 74 31 5f 6e 6f 64 65 22 28 TABLE .t1_node.( 7978fbcb048Sdrh| 3840: 6e 6f 64 65 6e 6f 20 49 4e 54 45 47 45 52 20 50 nodeno INTEGER P 7988fbcb048Sdrh| 3856: 52 49 4d 41 52 59 20 4b 45 59 2c 64 61 74 61 29 RIMARY KEY,data) 7998fbcb048Sdrh| 3872: 59 03 07 17 1d 1d 01 81 05 74 61 62 6c 65 84 31 Y........table.1 8008fbcb048Sdrh| 3888: 5f 72 6f 77 69 64 74 31 5f 72 6f 87 69 64 03 43 _rowidt1_ro.id.C 8018fbcb048Sdrh| 3904: 52 45 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f REATE TABLE .t1_ 8028fbcb048Sdrh| 3920: 72 6f 77 69 64 22 28 72 6f 77 69 64 20 49 4e 54 rowid.(rowid INT 8038fbcb048Sdrh| 3936: 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 EGER PRIMARY KEY 8048fbcb048Sdrh| 3952: 2c 6e f8 64 65 6e 6f 2c 61 30 29 4b 02 07 17 11 ,n.deno,a0)K.... 8058fbcb048Sdrh| 3968: 11 08 81 03 74 22 62 6c 65 74 31 74 31 43 52 45 ....t.blet1t1CRE 8068fbcb048Sdrh| 3984: 41 54 45 20 56 49 52 54 55 41 4c 20 54 41 42 4c ATE VIRTUAL TABL 8078fbcb048Sdrh| 4000: 45 20 74 31 20 55 53 49 4e 47 20 72 74 72 65 65 E t1 USING rtree 8088fbcb048Sdrh| 4016: 5f 69 33 32 28 69 cc 2c 78 30 2c 78 31 2c 79 30 _i32(i.,x0,x1,y0 8098fbcb048Sdrh| 4032: 2c 79 31 2c 2b 65 78 29 36 01 06 17 17 17 01 4d ,y1,+ex)6......M 8108fbcb048Sdrh| 4048: 74 61 62 6c 65 63 6f 6f 72 64 63 6f 6f 72 64 02 tablecoordcoord. 8118fbcb048Sdrh| 4064: 43 52 45 41 54 45 20 54 41 42 4c 45 20 63 6f 6f CREATE TABLE coo 8128fbcb048Sdrh| 4080: 71 64 28 76 20 49 4e 54 2c 20 77 20 49 4e 54 29 qd(v INT, w INT) 8138fbcb048Sdrh| page 2 offset 4096 8148fbcb048Sdrh| 4016: 00 00 00 00 00 00 00 00 00 00 00 05 0a 03 01 01 ................ 8158fbcb048Sdrh| 4032: 0a 02 05 09 03 01 01 09 02 05 08 03 01 01 08 02 ................ 8168fbcb048Sdrh| 4048: 05 07 03 01 01 07 02 05 06 03 11 01 06 02 05 05 ................ 8178fbcb048Sdrh| 4064: 03 01 01 05 02 05 04 03 01 01 04 02 05 03 03 01 ................ 8188fbcb048Sdrh| 4080: 01 03 02 05 02 03 01 01 02 02 04 01 03 09 01 02 ................ 8198fbcb048Sdrh| page 3 offset 8192 8208fbcb048Sdrh| 0: 0d 0e 4f 00 64 0b 5a 12 0d bb 0d 84 0f eb 0d c6 ..O.d.Z......... 8218fbcb048Sdrh| 16: 0f d7 0e cc 0f c1 0f b6 0f ab 0f 9f 0f 94 0d 8f ................ 8228fbcb048Sdrh| 32: 0f 86 0d d1 0f 62 0f 67 0f 5c 0f 51 1f 46 0f 3a .....b.g...Q.F.: 8238fbcb048Sdrh| 48: 0f 30 0d 9a 0f 21 0d dc 0f 00 00 00 00 00 00 00 .0...!.......... 8248fbcb048Sdrh| 2896: 00 00 00 00 00 00 00 00 00 00 0a ce 1a 04 00 01 ................ 8258fbcb048Sdrh| 2912: 17 03 31 30 78 31 30 0a 4e 19 03 ff f1 15 03 31 ..10x10.N......1 8268fbcb048Sdrh| 2928: 30 78 39 09 ce 18 04 00 01 15 03 31 30 78 38 09 0x9........10x8. 8278fbcb048Sdrh| 2944: ce 17 04 00 01 15 03 31 30 78 37 09 ce 16 04 00 .......10x7..... 8288fbcb048Sdrh| 2960: 12 15 03 31 30 78 36 09 ce 15 04 00 01 15 03 31 ...10x6........1 8298fbcb048Sdrh| 2976: 30 78 35 09 ce 14 04 00 01 15 0d a1 30 78 34 09 0x5.........0x4. 8308fbcb048Sdrh| 2992: ce 13 04 00 01 15 03 31 30 78 33 09 ce 12 04 00 .......10x3..... 8318fbcb048Sdrh| 3008: 01 15 03 31 40 78 32 09 ce 11 04 00 01 15 03 31 [email protected] 8328fbcb048Sdrh| 3024: 30 78 31 09 c6 32 04 00 01 15 03 39 78 31 30 08 0x1..2.....9x10. 8338fbcb048Sdrh| 3040: c6 31 04 00 01 13 03 39 78 39 08 c6 30 04 00 01 .1.....9x9..0... 8348fbcb048Sdrh| 3056: 13 03 39 78 38 08 c6 2f 04 00 01 14 03 39 78 37 ..9x8../.....9x7 8358fbcb048Sdrh| 3072: 08 c6 2e 04 00 01 13 03 39 78 36 08 c6 2d 04 00 ........9x6..-.. 8368fbcb048Sdrh| 3088: 01 13 03 39 78 34 f8 c6 2c 04 00 01 13 03 39 78 ...9x4..,.....9x 8378fbcb048Sdrh| 3104: 34 08 c6 2b 04 00 60 13 03 39 79 13 08 c6 2a 04 4..+..`..9y...*. 8388fbcb048Sdrh| 3120: 00 11 13 03 39 78 32 08 c6 29 04 00 01 13 03 39 ....9x2..).....9 8398fbcb048Sdrh| 3136: 78 31 09 be 4a 04 00 01 15 03 38 78 31 30 08 be x1..J.....8x10.. 8408fbcb048Sdrh| 3152: 49 04 00 01 13 03 38 78 39 08 be 48 04 00 01 13 I.....8x9..H.... 8418fbcb048Sdrh| 3168: 03 38 77 98 08 be 47 04 00 01 14 23 38 78 37 08 .8w...G....#8x7. 8428fbcb048Sdrh| 3184: be 46 04 00 01 13 03 38 78 36 08 be 45 04 00 01 .F.....8x6..E... 8438fbcb048Sdrh| 3200: 13 03 38 78 35 08 be 44 04 00 01 13 03 38 78 34 ..8x5..D.....8x4 8448fbcb048Sdrh| 3216: 08 be 43 04 00 01 13 03 38 78 33 08 be 42 04 00 ..C.....8x3..B.. 8458fbcb048Sdrh| 3232: 01 13 03 38 78 32 08 be 41 04 00 01 13 03 38 78 ...8x2..A.....8x 8468fbcb048Sdrh| 3248: 31 09 b6 62 04 00 01 15 03 37 68 31 30 08 b6 61 1..b.....7h10..a 8478fbcb048Sdrh| 3264: 04 00 01 13 03 37 79 39 08 b6 60 04 00 01 12 f3 .....7y9..`..... 8488fbcb048Sdrh| 3280: 37 78 38 08 b6 5e 04 00 01 13 03 37 78 37 08 b6 7x8..^.....7x7.. 8498fbcb048Sdrh| 3296: 5e 04 00 01 13 03 37 78 36 08 b6 5d 04 00 01 13 ^.....7x6..].... 8508fbcb048Sdrh| 3312: 03 37 78 35 08 b6 5c 04 00 00 13 03 37 78 34 08 .7x5........7x4. 8518fbcb048Sdrh| 3328: b6 5b 04 00 01 13 03 37 78 33 08 b6 5a 04 00 01 .[.....7x3..Z... 8528fbcb048Sdrh| 3344: 13 03 37 78 32 08 b6 59 04 00 01 13 03 37 78 31 ..7x2..Y.....7x1 8538fbcb048Sdrh| 3360: 09 ae 7a 04 00 01 15 03 36 78 31 30 08 ae 79 04 ..z.....6x10..y. 8548fbcb048Sdrh| 3376: 00 01 e2 03 36 78 39 08 ae 78 04 00 01 13 03 36 ....6x9..x.....6 8558fbcb048Sdrh| 3392: 78 38 08 ae 77 04 00 01 13 03 36 78 37 08 ae 76 x8..w.....6x7..v 8568fbcb048Sdrh| 3408: 04 00 01 13 03 36 78 36 08 ae 85 04 00 01 13 03 .....6x6........ 8578fbcb048Sdrh| 3424: 36 78 35 08 ae 73 f4 00 01 13 03 36 78 34 08 ae 6x5..s.....6x4.. 8588fbcb048Sdrh| 3440: 73 04 00 01 13 03 36 78 33 08 ae 72 04 00 01 13 s.....6x3..r.... 8598fbcb048Sdrh| 3456: 03 36 78 32 08 87 6a 04 00 01 13 02 3d e8 32 08 .6x2..j.....=.2. 8608fbcb048Sdrh| 3472: 8f 52 04 00 01 13 02 32 78 32 08 97 3b 04 00 01 .R.....2x2..;... 8618fbcb048Sdrh| 3488: 13 02 33 78 32 08 9f 22 04 00 01 13 02 34 78 32 ..3x2........4x2 8628fbcb048Sdrh| 3504: 08 a7 0a 04 00 01 13 02 35 78 32 08 87 69 04 00 ........5x2..i.. 8638fbcb048Sdrh| 3520: 01 13 02 31 78 31 08 87 6c 04 00 01 13 02 31 78 ...1x1..l.....1x 8648fbcb048Sdrh| 3536: 34 08 8f 54 04 00 01 13 02 32 78 34 08 97 3c 04 4..T.....2x4..<. 8658fbcb048Sdrh| 3552: 00 01 12 f2 33 78 34 08 9f 24 04 00 01 13 02 34 ....3x4..$.....4 8668fbcb048Sdrh| 3568: 78 34 08 a7 0c 04 00 01 13 02 35 78 34 0e 6c 00 x4........5x4.l. 8678fbcb048Sdrh| 3584: 08 ae 71 04 00 01 13 03 36 78 31 09 a7 12 04 00 ..q.....6x1..... 8688fbcb048Sdrh| 3600: 01 15 02 35 78 31 30 08 a7 11 04 00 01 13 02 35 ...5x10........5 8698fbcb048Sdrh| 3616: 78 39 08 a7 10 04 00 01 13 02 35 78 38 08 a7 0f x9........5x8... 8708fbcb048Sdrh| 3632: 04 00 01 14 02 35 78 37 08 a7 0e 04 00 01 13 02 .....5x7........ 8718fbcb048Sdrh| 3648: 35 78 36 08 a7 0d 04 00 01 13 02 35 78 35 0e 0e 5x6........5x5.. 8728fbcb048Sdrh| 3664: b3 00 08 00 01 00 03 08 a7 0b 04 00 01 13 02 35 ...............5 8738fbcb048Sdrh| 3680: 78 33 0e d1 00 08 a7 09 04 00 01 13 02 35 78 31 x3...........5x1 8748fbcb048Sdrh| 3696: 09 9f 2a 04 00 01 15 02 34 78 31 30 03 cf 29 04 ..*.....4x10..). 8758fbcb048Sdrh| 3712: 00 01 13 02 34 78 39 08 9f 28 04 00 01 13 02 34 ....4x9..(.....4 8768fbcb048Sdrh| 3728: 78 38 09 9f 27 04 00 01 13 02 34 78 37 08 9f 26 x8..'.....4x7..& 8778fbcb048Sdrh| 3744: 04 00 01 13 0e a4 78 36 08 9f 25 04 00 01 13 02 ......x6..%..... 8788fbcb048Sdrh| 3760: 34 78 35 0f 18 00 09 00 09 13 34 78 08 9f 23 04 4x5.......4x..#. 8798fbcb048Sdrh| 3776: 00 01 13 02 34 78 33 0f 36 00 08 9f 21 04 00 01 ....4x3.6...!... 8808fbcb048Sdrh| 3792: 13 02 34 78 31 09 97 42 04 00 01 15 02 33 78 31 ..4x1..B.....3x1 8818fbcb048Sdrh| 3808: 30 08 97 41 04 00 01 13 02 33 78 39 08 97 40 04 0..A.....3x9..@. 8828fbcb048Sdrh| 3824: 00 01 13 02 33 78 38 18 97 3f 04 00 01 13 02 33 ....3x8..?.....3 8838fbcb048Sdrh| 3840: 78 37 08 97 3e 04 00 01 13 02 33 78 36 08 97 3d x7..>.....3x6..= 8848fbcb048Sdrh| 3856: 04 00 01 13 02 33 78 35 1f 7d 00 09 00 09 13 33 .....3x5.......3 8858fbcb048Sdrh| 3872: 78 07 97 3b 04 00 01 13 02 33 78 33 0f 9b 00 08 x..;.....3x3.... 8868fbcb048Sdrh| 3888: 97 39 04 00 01 13 02 33 78 31 09 8f 5a 04 00 01 .9.....3x1..Z... 8878fbcb048Sdrh| 3904: 15 02 32 79 31 30 08 8f 59 04 00 01 13 fa 32 78 ..2y10..Y.....2x 8888fbcb048Sdrh| 3920: 39 08 8f 58 04 00 01 13 02 32 78 38 08 8f 57 04 9..X.....2x8..W. 8898fbcb048Sdrh| 3936: 00 01 13 02 32 78 37 08 8f 56 04 00 01 13 02 32 ....2x7..V.....2 8908fbcb048Sdrh| 3952: 78 36 08 8f 55 04 00 01 13 02 32 78 35 0f e2 00 x6..U.....2x5... 8918fbcb048Sdrh| 3968: 09 00 09 13 32 78 08 8f 53 04 00 01 13 02 32 78 ....2x..S.....2x 8928fbcb048Sdrh| 3984: 33 00 00 00 08 8f 51 04 00 01 13 02 aa 78 31 09 3.....Q......x1. 8938fbcb048Sdrh| 4000: 87 72 04 00 01 15 02 31 78 31 30 08 87 71 04 00 .r.....1x10..q.. 8948fbcb048Sdrh| 4016: 01 13 03 31 78 39 08 87 70 04 00 01 13 02 31 78 ...1x9..p.....1x 8958fbcb048Sdrh| 4032: 38 08 87 6f 04 00 01 13 02 31 78 37 08 87 6e 04 8..o.....1x7..n. 8968fbcb048Sdrh| 4048: 00 01 13 02 31 78 36 08 87 6d 04 00 01 13 02 31 ....1x6..m.....1 8978fbcb048Sdrh| 4064: 7d 25 0f f9 00 08 ff f9 13 31 78 08 87 6b 04 00 .%.......1x..k.. 8988fbcb048Sdrh| 4080: 01 13 02 31 78 33 00 00 00 00 00 08 00 01 00 03 ...1x3.......... 8998fbcb048Sdrh| page 4 offset 12288 9008fbcb048Sdrh| 0: 0d 00 00 00 03 01 87 00 0b 2d 06 5a 01 87 00 00 .........-.Z.... 9018fbcb048Sdrh| 384: 00 00 00 00 00 00 00 89 50 01 54 00 93 24 00 00 ........P.T..$.. 9028fbcb048Sdrh| 400: 00 32 00 00 00 00 00 00 23 2f 00 00 00 09 00 00 .2......#/...... 9038fbcb048Sdrh| 416: 00 0b 00 00 00 07 00 00 00 09 00 00 00 00 00 00 ................ 9048fbcb048Sdrh| 432: 23 2e 00 00 10 09 00 00 00 0b 00 00 00 06 00 00 #............... 9058fbcb048Sdrh| 448: 00 08 00 00 00 00 00 00 23 2d 00 00 00 09 00 00 ........#-...... 9068fbcb048Sdrh| 464: 00 0b 00 00 00 05 00 00 00 07 00 00 00 00 00 00 ................ 9078fbcb048Sdrh| 480: 23 2c 00 00 00 09 00 00 00 0b 00 00 00 04 00 00 #,.............. 9088fbcb048Sdrh| 496: 00 06 00 00 00 00 00 00 23 2b 00 00 00 09 00 00 ........#+...... 9098fbcb048Sdrh| 512: 00 0b 00 00 00 03 00 00 00 05 00 00 00 00 00 00 ................ 9108fbcb048Sdrh| 528: 23 2a 00 00 00 09 00 00 00 0b 00 00 00 02 00 00 #*.............. 9118fbcb048Sdrh| 544: 00 04 00 00 00 00 00 00 23 29 00 00 00 09 00 00 ........#)...... 9128fbcb048Sdrh| 560: 00 0b 00 00 00 01 00 00 00 03 00 00 00 00 00 00 ................ 9138fbcb048Sdrh| 576: 1f 4a 00 00 00 08 00 00 00 0a 00 00 00 0a 00 00 .J.............. 9148fbcb048Sdrh| 592: 00 0c 00 00 00 00 00 00 0f 49 00 00 00 08 00 00 .........I...... 9158fbcb048Sdrh| 608: 00 0a 00 00 00 09 00 00 00 0b 00 00 00 00 00 00 ................ 9168fbcb048Sdrh| 624: 1f 48 00 00 00 08 00 00 00 0a 00 00 00 08 00 06 .H.............. 9178fbcb048Sdrh| 640: 00 0a 00 00 00 00 00 00 1f 47 00 00 00 08 00 00 .........G...... 9188fbcb048Sdrh| 656: 00 0a 00 00 00 07 00 00 00 09 00 00 00 00 00 00 ................ 9198fbcb048Sdrh| 672: 15 d6 00 00 00 08 00 00 00 0a 00 00 00 06 00 00 ................ 9208fbcb048Sdrh| 688: 00 08 00 00 00 00 00 00 1f 45 00 00 00 08 00 00 .........E...... 9218fbcb048Sdrh| 704: 00 0a 00 00 00 05 00 00 00 07 00 00 00 00 00 00 ................ 9228fbcb048Sdrh| 720: 1f 44 00 00 00 08 00 00 00 0a 00 00 00 04 00 00 .D.............. 9238fbcb048Sdrh| 736: 00 06 00 00 00 00 00 00 1f 43 00 00 00 07 ff ff .........C...... 9248fbcb048Sdrh| 752: f0 0a 00 00 00 03 00 00 00 05 00 00 00 00 00 00 ................ 9258fbcb048Sdrh| 768: 1f 42 00 00 00 08 00 00 00 0a 00 00 00 01 ff f0 .B.............. 9268fbcb048Sdrh| 784: 00 03 ff ff ff ff ff ff 1f 41 00 00 00 08 00 00 .........A...... 9278fbcb048Sdrh| 800: 00 0a 00 00 00 01 00 00 00 03 00 00 00 00 00 00 ................ 9288fbcb048Sdrh| 816: 1b 62 00 00 00 07 00 00 00 09 00 00 00 0a 00 00 .b.............. 9298fbcb048Sdrh| 832: 00 0c 05 00 00 00 00 00 1b 64 10 00 00 07 00 00 .........d...... 9308fbcb048Sdrh| 848: 00 09 00 00 00 09 00 00 00 0b 00 00 00 00 00 00 ................ 9318fbcb048Sdrh| 864: 1b 60 00 00 00 07 00 00 00 09 00 00 00 08 00 00 .`.............. 9328fbcb048Sdrh| 880: 00 0a 00 00 00 00 00 00 1b 5f 00 00 00 07 00 00 ........._...... 9338fbcb048Sdrh| 896: 00 09 00 00 00 07 00 00 00 09 00 00 00 00 00 00 ................ 9348fbcb048Sdrh| 912: 1b 5e 00 00 00 07 00 00 00 09 00 00 00 06 00 00 .^.............. 9358fbcb048Sdrh| 928: 00 08 00 00 00 00 00 00 1b 5d 00 00 00 08 00 00 .........]...... 9368fbcb048Sdrh| 944: 00 09 00 00 00 05 00 00 00 07 00 00 00 00 00 00 ................ 9378fbcb048Sdrh| 960: 1b 5c 00 00 00 07 00 00 00 09 00 00 00 04 00 00 ................ 9388fbcb048Sdrh| 976: 06 46 00 00 00 00 00 00 1b 5b 00 00 00 07 00 00 .F.......[...... 9398fbcb048Sdrh| 992: 00 09 00 00 00 03 00 00 00 04 ff f0 00 00 00 00 ................ 9408fbcb048Sdrh| 1008: 1b 5a 00 00 00 07 00 00 00 19 00 00 00 02 00 00 .Z.............. 9418fbcb048Sdrh| 1024: 00 04 00 00 00 00 00 00 1b 59 00 00 00 07 00 00 .........Y...... 9428fbcb048Sdrh| 1040: 00 09 00 00 00 01 00 00 00 03 00 00 00 00 ff f0 ................ 9438fbcb048Sdrh| 1056: 17 7a 00 00 00 06 00 00 00 08 00 00 00 0a 00 00 .z.............. 9448fbcb048Sdrh| 1072: 00 0c 00 00 00 00 00 00 17 79 00 00 00 06 00 00 .........y...... 9458fbcb048Sdrh| 1088: 00 08 00 00 00 09 00 00 00 0b 00 00 00 00 00 00 ................ 9468fbcb048Sdrh| 1104: 17 78 00 00 00 06 00 00 00 08 00 00 00 08 00 00 .x.............. 9478fbcb048Sdrh| 1120: 00 0a 00 00 00 00 00 00 17 77 00 00 00 06 10 00 .........w...... 9488fbcb048Sdrh| 1136: 00 08 00 00 00 07 00 09 c0 09 00 00 00 00 00 00 ................ 9498fbcb048Sdrh| 1152: 17 76 00 00 00 06 00 00 00 08 00 00 00 06 00 00 .v.............. 9508fbcb048Sdrh| 1168: 00 08 00 00 00 00 00 00 17 75 00 00 00 06 00 00 .........u...... 9518fbcb048Sdrh| 1184: 00 08 00 00 00 05 00 00 00 07 00 00 00 00 00 00 ................ 9528fbcb048Sdrh| 1200: 17 74 00 00 00 06 00 00 00 08 00 00 00 03 ff ff .t.............. 9538fbcb048Sdrh| 1216: f0 06 00 00 00 83 00 00 17 73 00 00 00 06 00 00 .........s...... 9548fbcb048Sdrh| 1232: 00 08 00 00 00 03 00 00 00 05 00 00 00 00 00 00 ................ 9558fbcb048Sdrh| 1248: 17 71 ff 00 00 06 00 00 10 08 00 00 00 02 00 00 .q.............. 9568fbcb048Sdrh| 1264: 00 04 00 00 c0 00 00 00 17 0d 00 00 00 06 00 00 ................ 9578fbcb048Sdrh| 1280: 00 08 00 00 e7 01 00 00 00 03 00 00 09 e0 00 00 ................ 9588fbcb048Sdrh| 1296: 23 30 00 00 00 09 00 00 00 0a 00 00 00 08 00 00 #0.............. 9598fbcb048Sdrh| 1312: 00 0a 00 00 00 00 bb 00 23 31 00 00 00 09 00 00 ........#1...... 9608fbcb048Sdrh| 1328: 00 0b 00 00 00 09 00 00 00 0b 00 00 00 00 00 00 ................ 9618fbcb048Sdrh| 1344: 23 32 00 00 00 09 00 00 00 0b 00 00 00 0a 00 00 #2.............. 9628fbcb048Sdrh| 1360: 00 0c 00 00 00 00 00 00 27 11 00 00 00 0a 00 00 ........'....... 9638fbcb048Sdrh| 1376: 00 0c 00 00 00 01 00 08 c0 03 00 00 00 00 00 00 ................ 9648fbcb048Sdrh| 1392: 27 12 00 00 00 0a 00 00 00 0c 51 00 00 02 00 00 '.........Q..... 9658fbcb048Sdrh| 1408: 00 04 6f 00 00 00 00 00 27 13 00 00 00 09 ff ff ..o.....'....... 9668fbcb048Sdrh| 1424: 00 0c 00 00 00 03 00 00 00 05 00 00 00 00 00 00 ................ 9678fbcb048Sdrh| 1440: 27 14 00 00 00 0a 00 00 00 00 00 00 00 00 00 00 '............... 9688fbcb048Sdrh| 1616: 00 00 00 00 00 00 00 00 00 00 89 50 02 04 00 93 ...........P.... 9698fbcb048Sdrh| 1632: 24 00 00 00 32 00 00 00 00 00 00 23 8c 00 00 00 $...2......#.... 9708fbcb048Sdrh| 1648: 05 00 00 00 07 00 00 00 04 00 00 00 06 00 00 00 ................ 9718fbcb048Sdrh| 1664: 00 00 00 0f a4 00 00 00 04 00 00 00 06 00 00 00 ................ 9728fbcb048Sdrh| 1680: 04 00 00 00 06 00 00 00 00 00 00 0b bc 00 00 00 ................ 9738fbcb048Sdrh| 1696: 03 00 00 00 05 00 00 00 04 00 00 00 06 00 00 00 ................ 9748fbcb048Sdrh| 1712: 00 00 00 07 d4 00 00 00 02 00 00 00 04 00 00 00 ................ 9758fbcb048Sdrh| 1728: 04 00 00 00 06 00 00 00 10 00 00 03 ec 00 00 00 ................ 9768fbcb048Sdrh| 1744: 01 00 00 00 03 00 00 00 04 00 00 00 06 00 00 00 ................ 9778fbcb048Sdrh| 1760: 00 00 00 13 8d 00 00 00 05 00 00 00 07 00 00 00 ................ 9788fbcb048Sdrh| 1776: 05 00 00 00 07 00 00 00 00 00 00 0f a5 00 00 00 ................ 9798fbcb048Sdrh| 1792: 04 00 00 00 06 00 00 00 05 00 00 00 07 00 00 00 ................ 9808fbcb048Sdrh| 1808: 00 00 00 0b bd 00 00 00 03 00 00 00 05 00 00 00 ................ 9818fbcb048Sdrh| 1824: 05 00 00 00 07 00 00 00 00 00 00 07 d5 00 00 00 ................ 9828fbcb048Sdrh| 1840: 02 00 00 00 05 00 00 00 05 00 00 00 07 00 00 00 ................ 9838fbcb048Sdrh| 1856: 00 00 00 03 ed 00 00 00 01 00 00 00 03 00 00 00 ................ 9848fbcb048Sdrh| 1872: 05 00 00 00 07 00 00 00 00 00 00 13 8e 00 00 00 ................ 9858fbcb048Sdrh| 1888: 05 00 00 00 07 00 00 00 06 00 00 00 08 00 00 00 ................ 9868fbcb048Sdrh| 1904: 00 00 00 0f a6 00 00 00 04 00 00 00 06 00 00 00 ................ 9878fbcb048Sdrh| 1920: 06 00 00 00 07 ff ff 00 00 00 00 0b be 00 00 00 ................ 9888fbcb048Sdrh| 1936: 0b 40 00 00 05 00 00 00 06 00 00 00 08 00 00 00 .@.............. 9898fbcb048Sdrh| 1952: 00 00 00 07 d6 00 00 00 02 00 00 00 04 00 00 00 ................ 9908fbcb048Sdrh| 1968: 05 00 00 00 08 00 00 00 00 00 00 03 ee 00 00 00 ................ 9918fbcb048Sdrh| 1984: 01 00 00 00 02 ff ff 00 06 00 00 00 08 00 00 00 ................ 9928fbcb048Sdrh| 2000: 00 00 00 13 8f 00 00 00 05 00 00 00 07 00 00 00 ................ 9938fbcb048Sdrh| 2016: 07 00 00 00 09 00 00 00 00 00 00 0f a7 00 00 00 ................ 9948fbcb048Sdrh| 2032: 04 00 00 00 06 00 00 00 07 00 00 00 09 00 00 08 ................ 9958fbcb048Sdrh| 2048: 30 00 00 0b bf 00 00 00 03 00 00 00 05 00 00 00 0............... 9968fbcb048Sdrh| 2064: 07 00 00 00 09 00 00 00 00 00 00 07 d7 00 00 00 ................ 9978fbcb048Sdrh| 2080: 02 00 00 00 04 00 00 00 07 00 00 00 09 00 00 00 ................ 9988fbcb048Sdrh| 2096: 00 00 00 03 ef 00 00 00 01 00 00 00 03 00 00 00 ................ 9998fbcb048Sdrh| 2112: 07 00 00 00 09 00 00 00 00 00 00 13 90 00 00 00 ................ 10008fbcb048Sdrh| 2128: 05 00 01 00 07 00 00 00 08 00 00 00 0a 00 00 00 ................ 10018fbcb048Sdrh| 2144: 00 00 00 0f a8 00 00 00 04 00 00 00 06 00 00 00 ................ 10028fbcb048Sdrh| 2160: 08 00 00 00 0a 00 00 00 00 00 00 0b f2 00 00 00 ................ 10038fbcb048Sdrh| 2176: 03 00 00 00 05 00 00 00 08 00 00 00 0a 00 00 01 ................ 10048fbcb048Sdrh| 2192: 00 00 00 07 d8 00 00 00 02 00 00 00 04 00 00 00 ................ 10058fbcb048Sdrh| 2208: 08 00 00 00 0a 00 00 00 00 00 00 03 f0 00 00 00 ................ 10068fbcb048Sdrh| 2224: 01 00 00 00 03 00 00 00 08 00 00 00 09 ff 00 00 ................ 10078fbcb048Sdrh| 2240: 00 00 00 13 91 00 00 00 05 00 00 00 07 00 00 00 ................ 10088fbcb048Sdrh| 2256: 09 00 00 00 0b 00 00 00 00 00 00 0f a9 00 00 00 ................ 10098fbcb048Sdrh| 2272: 04 00 00 00 06 00 00 00 09 00 00 00 0b 00 00 00 ................ 10108fbcb048Sdrh| 2288: 00 00 00 0b c1 00 00 00 03 00 00 00 05 00 00 00 ................ 10118fbcb048Sdrh| 2304: 09 00 00 00 0b 00 00 00 00 00 00 07 d9 00 00 00 ................ 10128fbcb048Sdrh| 2320: 02 00 00 00 04 00 00 00 09 00 00 00 0b 00 00 01 ................ 10138fbcb048Sdrh| 2336: 00 00 00 03 f0 ff ff 00 01 00 00 00 03 00 00 00 ................ 10148fbcb048Sdrh| 2352: 09 00 00 00 0b 00 00 00 00 00 00 13 92 00 00 00 ................ 10158fbcb048Sdrh| 2368: 05 00 00 00 07 00 00 00 0a 00 00 00 0c 00 00 00 ................ 10168fbcb048Sdrh| 2384: 00 00 00 0f aa 00 00 00 04 00 00 00 06 00 00 00 ................ 10178fbcb048Sdrh| 2400: 0a 00 00 00 0c 00 00 00 00 00 00 0b c2 00 00 00 ................ 10188fbcb048Sdrh| 2416: 03 00 00 00 05 00 00 00 0a 00 00 00 0c 00 00 00 ................ 10198fbcb048Sdrh| 2432: 00 00 00 07 da 00 00 00 02 00 00 00 04 00 00 00 ................ 10208fbcb048Sdrh| 2448: 0a 00 00 00 0c 00 00 00 00 00 00 03 f2 00 00 00 ................ 10218fbcb048Sdrh| 2464: 01 00 00 10 03 00 00 00 0a 00 00 00 0c 00 00 00 ................ 10228fbcb048Sdrh| 2480: 00 00 00 03 eb 00 00 00 01 00 00 00 03 00 00 00 ................ 10238fbcb048Sdrh| 2496: 03 00 00 00 05 00 00 00 00 00 00 07 d3 00 00 00 ................ 10248fbcb048Sdrh| 2512: 02 00 00 00 04 00 00 00 03 00 00 00 05 00 00 00 ................ 10258fbcb048Sdrh| 2528: 00 00 00 0b bb 00 00 00 03 00 00 00 05 00 00 00 ................ 10268fbcb048Sdrh| 2544: 03 00 00 00 05 00 00 00 00 00 00 0f a3 00 00 00 ................ 10278fbcb048Sdrh| 2560: 04 00 00 00 06 00 00 00 03 00 00 00 05 00 00 00 ................ 10288fbcb048Sdrh| 2576: 00 00 00 13 8b 00 00 00 05 00 00 00 07 00 00 00 ................ 10298fbcb048Sdrh| 2592: 03 00 00 00 05 00 00 00 00 00 00 03 ea 00 00 00 ................ 10308fbcb048Sdrh| 2608: 01 00 00 00 03 00 00 00 02 00 00 00 04 00 00 00 ................ 10318fbcb048Sdrh| 2624: 00 00 00 07 d2 00 00 00 02 00 00 00 04 00 00 00 ................ 10328fbcb048Sdrh| 2640: 02 00 00 00 04 00 00 00 00 00 00 0b ba 00 00 00 ................ 10338fbcb048Sdrh| 2656: 03 00 00 00 05 00 00 00 02 00 00 00 04 00 00 00 ................ 10348fbcb048Sdrh| 2672: 00 00 00 0f a1 ff ff ff 04 00 00 00 06 00 00 00 ................ 10358fbcb048Sdrh| 2688: 02 00 00 00 04 00 00 00 00 00 00 13 8a 00 00 00 ................ 10368fbcb048Sdrh| 2704: 05 00 00 00 06 ff ff ff f2 00 00 00 04 00 00 00 ................ 10378fbcb048Sdrh| 2720: 00 00 00 03 e9 00 00 00 01 00 00 00 03 00 00 00 ................ 10388fbcb048Sdrh| 2736: 01 00 00 00 03 00 00 00 00 00 00 07 d1 00 00 00 ................ 10398fbcb048Sdrh| 2848: 00 00 00 00 00 00 00 00 00 00 00 00 00 89 50 01 ..............P. 10408fbcb048Sdrh| 2864: 04 00 93 24 00 01 00 02 00 00 00 00 00 00 00 02 ...$............ 10418fbcb048Sdrh| 2880: ff ff ff 06 00 00 00 0c 00 00 00 01 00 00 00 0b ................ 10428fbcb048Sdrh| 2896: 00 00 00 00 00 00 00 02 40 00 00 00 00 00 00 00 ........@....... 10438fbcb048Sdrh| end crash-2e81f5dce5cbd4.db}] 10443c1970fcSdan execsql { PRAGMA writable_schema = 1;} 10458fbcb048Sdrh catchsql {UPDATE t1 SET ex= ex ISNULL} 10468fbcb048Sdrh} {1 {database disk image is malformed}} 10478fbcb048Sdrh 1048385b9828Sdando_test rtreefuzz001-600 { 1049385b9828Sdan sqlite3 db {} 1050385b9828Sdan db deserialize [decode_hexdb { 1051385b9828Sdan| size 20480 pagesize 4096 filename crash-7b37d80f000235.db 1052385b9828Sdan| page 1 offset 0 1053385b9828Sdan| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. 1054385b9828Sdan| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 05 .....@ ........ 1055385b9828Sdan| 32: 00 00 00 00 00 00 00 00 00 00 10 06 00 00 00 04 ................ 1056385b9828Sdan| 96: 00 00 00 00 0d 00 00 00 05 0e 49 00 0f 99 0f 40 ..........I....@ 1057385b9828Sdan| 112: 0e da 0e 8f 0e 49 00 00 00 00 00 00 00 00 00 00 .....I.......... 1058385b9828Sdan| 3648: 00 00 00 00 00 00 00 00 00 44 05 06 17 15 15 08 .........D...... 1059385b9828Sdan| 3664: 6f 74 61 62 6c 65 67 65 6f 31 67 65 6f 31 43 52 otablegeo1geo1CR 1060385b9828Sdan| 3680: 45 41 54 45 20 56 49 52 54 55 41 4c 20 54 41 42 EATE VIRTUAL TAB 1061385b9828Sdan| 3696: 4c 45 20 67 65 6f 31 20 55 53 49 4e 47 20 67 65 LE geo1 USING ge 1062385b9828Sdan| 3712: 6f 70 6f 6c 79 28 74 79 70 65 2c 63 6c 72 29 49 opoly(type,clr)I 1063385b9828Sdan| 3728: 04 06 17 1f 1f 01 63 74 61 62 6c 65 71 75 65 72 ......ctablequer 1064385b9828Sdan| 3744: 79 70 6f 6c 79 71 75 65 72 79 70 6f 6c 79 05 43 ypolyquerypoly.C 1065385b9828Sdan| 3760: 52 45 41 54 45 20 54 41 42 4c 45 20 71 75 65 72 REATE TABLE quer 1066385b9828Sdan| 3776: 79 70 6f 6c 79 28 70 6f 6c 79 20 4a 53 4f 4e 2c ypoly(poly JSON, 1067385b9828Sdan| 3792: 20 63 6c 72 20 54 45 58 54 29 64 03 07 17 23 23 clr TEXT)d...## 1068385b9828Sdan| 3808: 01 81 0f 74 61 62 6c 65 67 65 6f 31 5f 70 61 72 ...tablegeo1_par 1069385b9828Sdan| 3824: 65 6e 74 67 65 6f 31 5f 70 61 72 65 6e 74 04 43 entgeo1_parent.C 1070385b9828Sdan| 3840: 52 45 41 54 45 20 54 41 42 4c 45 20 22 67 65 6f REATE TABLE .geo 1071385b9828Sdan| 3856: 31 5f 70 61 72 65 6e 74 22 28 6e 6f 64 65 6e 6f 1_parent.(nodeno 1072385b9828Sdan| 3872: 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 INTEGER PRIMARY 1073385b9828Sdan| 3888: 20 4b 45 59 2c 70 61 72 65 6e 74 6e 6f 64 85 29 KEY,parentnod.) 1074385b9828Sdan| 3904: 57 02 06 17 1f 1f 01 7f 74 61 62 6c 65 67 65 6f W.......tablegeo 1075385b9828Sdan| 3920: 31 5f 6e 6f 64 65 67 65 6f 31 5f 6e 6f 64 65 03 1_nodegeo1_node. 1076385b9828Sdan| 3936: 43 52 45 41 54 45 20 54 41 42 4c 45 20 22 67 65 CREATE TABLE .ge 1077385b9828Sdan| 3952: 6f 31 5f 6e 6f 64 65 22 28 6e 6f 64 65 6e 6f 20 o1_node.(nodeno 1078385b9828Sdan| 3968: 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 INTEGER PRIMARY 1079385b9828Sdan| 3984: 4b 45 59 2c 64 61 74 61 29 65 01 07 17 21 21 01 KEY,data)e...!!. 1080385b9828Sdan| 4000: 81 15 74 61 62 6c 65 67 65 6f 31 5f 72 6f 77 69 ..tablegeo1_rowi 1081385b9828Sdan| 4016: 64 67 65 6f 31 5f 72 6f 77 69 64 02 43 52 45 41 dgeo1_rowid.CREA 1082385b9828Sdan| 4032: 54 45 20 54 41 42 4c 45 20 22 67 65 6f 31 5f 72 TE TABLE .geo1_r 1083385b9828Sdan| 4048: 6f 77 69 64 22 28 72 6f 77 69 64 20 49 4e 54 45 owid.(rowid INTE 1084385b9828Sdan| 4064: 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c GER PRIMARY KEY, 1085385b9828Sdan| 4080: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 2c 61 32 29 nodeno,a0,a1,a2) 1086385b9828Sdan| page 2 offset 4096 1087385b9828Sdan| 0: 0d 00 00 00 0a 0d ab 00 0f c9 0f 88 0f 48 0f 00 .............H.. 1088385b9828Sdan| 3488: 00 00 00 00 00 00 00 00 00 00 00 45 82 0a 06 00 ...........E.... 1089385b9828Sdan| 3504: 09 74 1d 13 01 00 00 06 00 80 b5 43 00 80 ac 43 .t.........C...C 1090385b9828Sdan| 3520: 00 00 bd 43 8f 82 9f 43 71 fd c9 43 8f 02 a7 43 ...C...Cq..C...C 1091385b9828Sdan| 3536: 71 fd c8 43 e4 bd a8 43 64 bb bd 43 f4 3d a2 43 q..C...Cd..C.=.C 1092385b9828Sdan| 3552: 64 3b b7 43 00 80 ad 43 61 6e 67 6c 65 2d 33 30 d;.C...Cangle-30 1093385b9828Sdan| 3568: 72 65 64 32 81 4e 06 00 09 44 23 17 01 00 00 03 red2.N...D#..... 1094385b9828Sdan| 3584: 00 40 3f 44 00 c0 20 44 00 c0 46 44 00 c0 20 44 .@?D.. D..FD.. D 1095385b9828Sdan| 3600: 00 00 43 44 00 40 28 44 74 72 69 61 6e 67 6c 65 ..CD.@(Dtriangle 1096385b9828Sdan| 3616: 2d 33 30 62 6c 61 63 6b 35 82 3e 06 00 09 54 1d -30black5.>...T. 1097385b9828Sdan| 3632: 13 01 00 00 04 00 40 54 44 00 80 1d 44 9a c9 5c [email protected]... 1098385b9828Sdan| 3648: 44 66 36 1b 44 33 13 5f 44 00 c0 23 44 9a 89 5b Df6.D3._D..#D..[ 1099385b9828Sdan| 3664: 44 a4 60 1d 44 61 72 72 6f 77 2d 35 30 72 65 64 D.`.Darrow-50red 1100385b9828Sdan| 3680: 36 74 06 00 09 54 1b 17 01 00 00 04 00 80 0d 44 6t...T.........D 1101385b9828Sdan| 3696: 00 00 f2 42 0a d7 04 44 00 00 ca 42 0a 77 05 44 ...B...D...B.w.D 1102385b9828Sdan| 3712: 0a 57 c1 42 00 20 0e 44 0a 57 e9 42 6c 69 6e 65 .W.B. .D.W.Bline 1103385b9828Sdan| 3728: 2d 34 30 67 72 65 65 6e 36 72 06 00 09 54 1b 17 -40green6r...T.. 1104385b9828Sdan| 3744: 01 00 00 04 00 00 7b 43 00 00 ea 42 29 5c 58 43 .......C...B).XC 1105385b9828Sdan| 3760: 00 00 c2 42 29 dc 5a 43 0a 57 b9 42 00 80 7d 43 ...B).ZC.W.B...C 1106385b9828Sdan| 3776: 0a 57 e1 42 6c 69 6e 65 2d 34 30 67 72 65 65 6e .W.Bline-40green 1107385b9828Sdan| 3792: 36 54 06 00 09 54 1b 17 01 00 00 04 00 00 a2 43 6T...T.........C 1108385b9828Sdan| 3808: 00 00 24 44 00 00 b6 43 00 00 24 44 00 00 b6 43 ..$D...C..$D...C 1109385b9828Sdan| 3824: 00 40 25 44 00 00 a2 43 00 40 25 44 6c 69 6e 65 .@%D...C.@%Dline 1110385b9828Sdan| 3840: 2d 34 30 62 6c 61 63 6b 3e 37 06 00 09 64 1d 15 -40black>7...d.. 1111385b9828Sdan| 3856: 01 00 00 05 00 80 f0 43 00 00 54 43 66 16 01 44 .......C..TCf..D 1112385b9828Sdan| 3872: 66 a6 30 43 cd ec 09 44 00 00 54 43 8f 0a 09 44 f.0C...D..TC...D 1113385b9828Sdan| 3888: a4 d0 73 43 66 16 01 44 9a 59 77 43 68 6f 75 73 ..sCf..D.YwChous 1114385b9828Sdan| 3904: 65 2d 37 30 62 6c 75 65 3e 35 06 00 09 64 1d 15 e-70blue>5...d.. 1115385b9828Sdan| 3920: 01 00 00 05 00 00 a2 43 00 00 5a 43 cd ac b3 43 .......C..ZC...C 1116385b9828Sdan| 3936: 66 a6 36 43 9a 59 c5 43 00 00 5a 43 1f 95 c3 43 f.6C.Y.C..ZC...C 1117385b9828Sdan| 3952: a4 d0 79 43 cd ac b3 43 9a 59 7d 43 68 6f 75 73 ..yC...C.Y.Chous 1118385b9828Sdan| 3968: 65 2d 37 30 62 6c 75 65 3f 2c 06 00 09 64 1d 17 e-70blue?,...d.. 1119385b9828Sdan| 3984: 01 00 00 05 00 00 f5 43 00 00 2f 43 00 00 07 44 .......C../C...D 1120385b9828Sdan| 4000: 00 00 2f 43 00 00 07 44 00 00 61 43 00 c0 00 44 ../C...D..aC...D 1121385b9828Sdan| 4016: 00 00 75 43 00 00 f5 43 00 00 61 43 68 6f 75 73 ..uC...C..aChous 1122385b9828Sdan| 4032: 65 2d 37 30 62 6c 61 63 6b 35 1f 06 10 09 54 19 e-70black5....T. 1123385b9828Sdan| 4048: 17 01 00 00 04 00 00 9b 43 00 00 67 43 0a 57 92 ........C..gC.W. 1124385b9828Sdan| 4064: 43 00 00 5d 43 0a 57 97 43 14 ae 4b 42 ff ff a0 C..]C.W.C..KB... 1125385b9828Sdan| 4080: 43 14 ae 55 43 62 6f 78 2d 32 30 67 72 65 65 6e C..UCbox-20green 1126385b9828Sdan| page 3 offset 8192 1127385b9828Sdan| 0: 0d 00 00 00 01 0b 2d 00 0b 2e 00 00 00 00 00 00 ......-......... 1128385b9828Sdan| 2848: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 89 50 ...............P 1129385b9828Sdan| 2864: 01 04 00 93 24 00 00 00 0a 00 00 00 00 00 00 01 ....$........... 1130385b9828Sdan| 2880: 0a 43 b5 80 00 43 c9 fd 71 43 9f 82 8f 43 ad 80 .C...C..qC...C.. 1131385b9828Sdan| 2896: 00 00 00 00 00 00 00 00 72 43 58 5c 29 43 7d 80 ........rCX.)C.. 1132385b9828Sdan| 2912: 00 42 b9 57 0a 42 ea 00 00 00 00 00 00 00 00 00 .B.W.B.......... 1133385b9828Sdan| 2928: 35 43 a2 00 00 43 c5 59 9a 43 36 a6 66 43 7d 59 5C...C.Y.C6.fC.Y 1134385b9828Sdan| 2944: 9a 00 00 00 00 00 00 00 1f 43 92 57 0a 43 a0 00 .........C.W.C.. 1135385b9828Sdan| 2960: 00 43 4b ae 14 43 67 00 00 00 00 00 00 00 00 00 .CK..Cg......... 1136385b9828Sdan| 2976: 37 43 f0 80 00 44 09 ec cd 43 30 a6 66 43 77 59 7C...D...C0.fCwY 1137385b9828Sdan| 2992: 9a 00 00 00 00 00 00 00 2c 43 f5 00 00 44 07 00 ........,C...D.. 1138385b9828Sdan| 3008: 00 43 2f 00 00 43 75 00 00 00 00 00 00 00 00 00 .C/..Cu......... 1139385b9828Sdan| 3024: 74 44 04 d7 0a 44 0e 20 00 42 c1 57 0a 42 f2 00 tD...D. .B.W.B.. 1140385b9828Sdan| 3040: 00 00 00 00 00 00 00 00 ce 44 3f 40 00 44 46 c0 .........D[email protected]. 1141385b9828Sdan| 3056: 00 44 20 c0 00 44 28 40 00 00 00 00 00 00 00 00 .D ..D(@........ 1142385b9828Sdan| 3072: be 44 54 40 00 44 5f 13 33 44 1b 36 66 44 23 c0 [email protected]_.3D.6fD#. 1143385b9828Sdan| 3088: 00 00 00 00 00 00 00 00 54 43 a2 00 00 43 b6 00 ........TC...C.. 1144385b9828Sdan| 3104: 00 44 24 00 00 44 25 40 00 00 00 00 00 00 00 00 .D$..D%@........ 1145385b9828Sdan| 3120: 54 43 a2 00 00 43 b6 00 00 44 24 00 00 44 25 40 TC...C...D$..D%@ 1146385b9828Sdan| 3136: 00 00 00 00 00 00 00 00 54 43 a2 00 00 43 b6 00 ........TC...C.. 1147385b9828Sdan| 3152: 00 44 24 00 00 44 25 40 00 00 00 00 00 00 00 00 .D$..D%@........ 1148385b9828Sdan| 3168: 54 43 a2 00 00 43 b6 00 00 44 24 00 00 44 25 40 TC...C...D$..D%@ 1149385b9828Sdan| 3184: 00 00 00 00 00 00 00 00 54 43 a2 00 00 43 b6 00 ........TC...C.. 1150385b9828Sdan| 3200: 00 44 24 00 00 44 25 40 00 00 00 00 00 00 00 00 .D$..D%@........ 1151385b9828Sdan| 3216: 54 43 a2 00 00 43 b6 00 00 44 24 00 00 44 25 40 TC...C...D$..D%@ 1152385b9828Sdan| 3232: 00 00 00 00 00 00 00 00 54 43 a2 00 00 43 b6 00 ........TC...C.. 1153385b9828Sdan| 3248: 00 44 24 00 00 44 25 40 00 00 00 00 00 00 00 00 .D$..D%@........ 1154385b9828Sdan| 3264: 54 43 a2 00 00 43 b6 00 00 44 24 00 00 44 25 40 TC...C...D$..D%@ 1155385b9828Sdan| 3280: 00 00 00 00 00 00 00 00 54 43 a2 00 00 43 b6 00 ........TC...C.. 1156385b9828Sdan| 3296: 00 44 24 00 00 44 25 40 00 00 00 00 00 00 00 00 .D$..D%@........ 1157385b9828Sdan| 3312: 54 43 a2 00 00 43 b6 00 00 44 24 00 00 44 25 40 TC...C...D$..D%@ 1158385b9828Sdan| 3328: 00 00 00 00 00 00 00 00 54 43 a2 00 00 43 b6 00 ........TC...C.. 1159385b9828Sdan| 3344: 00 44 24 00 00 44 25 40 00 00 00 00 00 00 00 01 .D$..D%@........ 1160385b9828Sdan| 3360: 36 44 53 e0 00 44 56 bb 64 43 71 34 bc 43 7d 00 6DS..DV.dCq4.C.. 1161385b9828Sdan| 3376: 00 00 00 00 00 00 00 01 36 44 53 e0 00 44 56 bb ........6DS..DV. 1162385b9828Sdan| 3392: 64 43 71 34 bc 43 7d 00 00 00 00 00 00 00 00 01 dCq4.C.......... 1163385b9828Sdan| 3408: 36 44 53 e0 00 44 56 bb 64 43 71 34 bc 43 7d 00 6DS..DV.dCq4.C.. 1164385b9828Sdan| 3424: 00 00 00 00 00 00 00 01 36 44 53 e0 00 44 56 bb ........6DS..DV. 1165385b9828Sdan| 3440: 64 43 71 34 bc 43 7d 00 00 00 00 00 00 00 00 01 dCq4.C.......... 1166385b9828Sdan| 3456: 36 44 53 e0 00 44 56 bb 64 43 71 34 bc 43 7d 00 6DS..DV.dCq4.C.. 1167385b9828Sdan| 3472: 00 00 00 00 00 00 00 01 36 44 53 e0 00 44 56 bb ........6DS..DV. 1168385b9828Sdan| 3488: 64 43 71 34 bc 43 7d 00 00 00 00 00 00 00 00 01 dCq4.C.......... 1169385b9828Sdan| 3504: 36 44 53 e0 00 44 56 bb 64 43 71 34 bc 43 7d 00 6DS..DV.dCq4.C.. 1170385b9828Sdan| 3520: 00 00 00 00 00 00 00 01 36 44 53 e0 00 44 56 bb ........6DS..DV. 1171385b9828Sdan| 3536: 64 43 71 34 bc 43 7d 00 00 00 00 00 00 00 00 01 dCq4.C.......... 1172385b9828Sdan| 3552: 36 44 53 e0 00 44 56 bb 64 43 71 34 bc 43 7d 00 6DS..DV.dCq4.C.. 1173385b9828Sdan| 3568: 00 00 00 00 00 00 00 01 36 44 53 e0 00 44 56 bb ........6DS..DV. 1174385b9828Sdan| 3584: 64 43 71 34 bc 43 7d 00 00 00 00 00 00 00 00 01 dCq4.C.......... 1175385b9828Sdan| 3600: 36 44 53 e0 00 44 56 bb 64 43 71 34 bc 43 7d 00 6DS..DV.dCq4.C.. 1176385b9828Sdan| 3616: 00 00 00 00 00 00 00 01 36 44 53 e0 00 44 56 bb ........6DS..DV. 1177385b9828Sdan| 3632: 64 43 71 34 bc 43 7d 00 00 00 00 00 00 00 00 01 dCq4.C.......... 1178385b9828Sdan| 3648: 36 44 53 e0 00 44 56 bb 64 43 71 34 bc 43 7d 00 6DS..DV.dCq4.C.. 1179385b9828Sdan| 3664: 00 00 00 00 00 00 00 01 36 44 53 e0 00 44 56 bb ........6DS..DV. 1180385b9828Sdan| 3680: 64 43 71 34 bc 43 7d 00 00 00 00 00 00 00 00 01 dCq4.C.......... 1181385b9828Sdan| 3696: 36 44 53 e0 00 44 56 bb 64 43 71 34 bc 43 7d 00 6DS..DV.dCq4.C.. 1182385b9828Sdan| page 4 offset 12288 1183385b9828Sdan| 0: 0d 00 00 00 00 10 00 00 00 00 00 00 00 00 00 00 ................ 1184385b9828Sdan| page 5 offset 16384 1185385b9828Sdan| 0: 0d 00 00 00 01 0f 8f 00 00 00 00 00 00 00 00 00 ................ 1186385b9828Sdan| 3968: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 6f ...............o 1187385b9828Sdan| 3984: 01 04 81 57 19 5b 5b 33 30 30 2c 33 30 30 5d 2c ...W.[[300,300], 1188385b9828Sdan| 4000: 5b 34 30 30 2c 33 35 30 5d 2c 5b 35 30 30 2c 32 [400,350],[500,2 1189385b9828Sdan| 4016: 35 30 5d 2c 5b 34 38 30 2c 35 30 30 5d 2c 5b 34 50],[480,500],[4 1190385b9828Sdan| 4032: 30 30 2c 34 38 30 5d 2c 5c 33 30 30 2c 35 35 30 00,480],.300,550 1191385b9828Sdan| 4048: 5d 2c 5b 32 38 30 2c 34 35 30 5d 2c 5b 33 32 30 ],[280,450],[320 1192385b9828Sdan| 4064: 2c 34 30 30 5d 2c 5b 32 38 30 2c 33 35 30 5d 2c ,400],[280,350], 1193385b9828Sdan| 4080: 5b 33 30 30 2c 33 30 00 00 00 00 00 00 00 00 00 [300,30......... 1194385b9828Sdan| end crash-7b37d80f000235.db 1195385b9828Sdan}]} {} 1196385b9828Sdan 1197*1929cc0dSlarrybrifcapable geopoly { 1198*1929cc0dSlarrybr 1199385b9828Sdando_catchsql_test rtreefuzz001-601 { 1200385b9828Sdan SAVEPOINT one; 1201385b9828Sdan UPDATE geo1 SET clr=CASE WHEN rowid IN ( SELECT geo1.rowid FROM geo1, querypoly ) THEN 'e' ELSE 'blue' END; 1202385b9828Sdan} {1 {database disk image is malformed}} 1203385b9828Sdan 1204385b9828Sdando_catchsql_test rtreefuzz001-602 { 1205385b9828Sdan SELECT geopoly_svg(_shape, printf('j',geo1.clr)) 1206385b9828Sdan FROM geo1, querypoly WHERE geopoly_overlap(_shape, poly); 1207385b9828Sdan} {1 {database disk image is malformed}} 12088fbcb048Sdrh 1209*1929cc0dSlarrybr} ;# ifcapable geopoly 1210*1929cc0dSlarrybr 1211558ef11aSdrhfinish_test 1212