Return to vacuum4.test CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test

Annotation of embedaddon/sqlite3/test/vacuum4.test, revision 1.1

1.1     ! misho       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: } {}