File:  [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test / vacuum4.test
Revision 1.1.1.1 (vendor branch): download - view: text, annotated - select for diffs - revision graph
Tue Feb 21 17:04:16 2012 UTC (12 years, 10 months ago) by misho
Branches: sqlite3, MAIN
CVS tags: v3_7_10, HEAD
sqlite3

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

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>