| 1 |
# 2010 February 21 |
| 2 |
# |
| 3 |
# The author disclaims copyright to this source code. In place of |
| 4 |
# a legal notice, here is a blessing: |
| 5 |
# |
| 6 |
# May you do good and not evil. |
| 7 |
# May you find forgiveness for yourself and forgive others. |
| 8 |
# May you share freely, never taking more than you give. |
| 9 |
# |
| 10 |
#*********************************************************************** |
| 11 |
# |
| 12 |
# This file implements a test of ticket [da1151f97df244a1]: An |
| 13 |
# assertion fault while VACUUMing an auto_vacuumed database with |
| 14 |
# large schema. |
| 15 |
# |
| 16 |
|
| 17 |
set testdir [file dirname $argv0] |
| 18 |
source $testdir/tester.tcl |
| 19 |
|
| 20 |
# If the VACUUM statement is disabled in the current build, skip all |
| 21 |
# the tests in this file. |
| 22 |
# |
| 23 |
ifcapable !vacuum { |
| 24 |
finish_test |
| 25 |
return |
| 26 |
} |
| 27 |
|
| 28 |
do_test vacuum4-1.1 { |
| 29 |
db eval { |
| 30 |
PRAGMA auto_vacuum=FULL; |
| 31 |
CREATE TABLE t1( |
| 32 |
c000, c001, c002, c003, c004, c005, c006, c007, c008, c009, |
| 33 |
c010, c011, c012, c013, c014, c015, c016, c017, c018, c019, |
| 34 |
c020, c021, c022, c023, c024, c025, c026, c027, c028, c029, |
| 35 |
c030, c031, c032, c033, c034, c035, c036, c037, c038, c039, |
| 36 |
c040, c041, c042, c043, c044, c045, c046, c047, c048, c049, |
| 37 |
c050, c051, c052, c053, c054, c055, c056, c057, c058, c059, |
| 38 |
c060, c061, c062, c063, c064, c065, c066, c067, c068, c069, |
| 39 |
c070, c071, c072, c073, c074, c075, c076, c077, c078, c079, |
| 40 |
c080, c081, c082, c083, c084, c085, c086, c087, c088, c089, |
| 41 |
c090, c091, c092, c093, c094, c095, c096, c097, c098, c099, |
| 42 |
c100, c101, c102, c103, c104, c105, c106, c107, c108, c109, |
| 43 |
c110, c111, c112, c113, c114, c115, c116, c117, c118, c119, |
| 44 |
c120, c121, c122, c123, c124, c125, c126, c127, c128, c129, |
| 45 |
c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, |
| 46 |
c140, c141, c142, c143, c144, c145, c146, c147, c148, c149 |
| 47 |
); |
| 48 |
CREATE TABLE t2( |
| 49 |
c000, c001, c002, c003, c004, c005, c006, c007, c008, c009, |
| 50 |
c010, c011, c012, c013, c014, c015, c016, c017, c018, c019, |
| 51 |
c020, c021, c022, c023, c024, c025, c026, c027, c028, c029, |
| 52 |
c030, c031, c032, c033, c034, c035, c036, c037, c038, c039, |
| 53 |
c040, c041, c042, c043, c044, c045, c046, c047, c048, c049, |
| 54 |
c050, c051, c052, c053, c054, c055, c056, c057, c058, c059, |
| 55 |
c060, c061, c062, c063, c064, c065, c066, c067, c068, c069, |
| 56 |
c070, c071, c072, c073, c074, c075, c076, c077, c078, c079, |
| 57 |
c080, c081, c082, c083, c084, c085, c086, c087, c088, c089, |
| 58 |
c090, c091, c092, c093, c094, c095, c096, c097, c098, c099, |
| 59 |
c100, c101, c102, c103, c104, c105, c106, c107, c108, c109, |
| 60 |
c110, c111, c112, c113, c114, c115, c116, c117, c118, c119, |
| 61 |
c120, c121, c122, c123, c124, c125, c126, c127, c128, c129, |
| 62 |
c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, |
| 63 |
c140, c141, c142, c143, c144, c145, c146, c147, c148, c149 |
| 64 |
); |
| 65 |
VACUUM; |
| 66 |
} |
| 67 |
} {} |
| 68 |
|
| 69 |
finish_test |