github.com/jdgcs/sqlite3@v1.12.1-0.20210908114423-bc5f96e4dd51/testdata/tcl/vacuum4.test (about)

     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