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

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: } {}