Return to tkt3630.test CVS log

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

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

1.1     ! misho       1: # 2009 February 2
        !             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 checks to make sure the "TEMP" or "TEMPORARY" keyword is
        !            13: # omitted from the schema of a table that is created using that
        !            14: # keyword.  Ticket #3630.
        !            15: #
        !            16: # $Id: tkt3630.test,v 1.1 2009/02/02 18:03:22 drh Exp $
        !            17: #
        !            18: 
        !            19: set testdir [file dirname $argv0]
        !            20: 
        !            21: source $testdir/tester.tcl
        !            22: 
        !            23: do_test tkt3630-1 {
        !            24:   db eval {
        !            25:     CREATE TEMP TABLE temp1(a,b,c);
        !            26:     SELECT * FROM sqlite_temp_master WHERE sql GLOB '*TEMP*';
        !            27:   }
        !            28: } {}
        !            29: do_test tkt3630-2 {
        !            30:   db eval {
        !            31:     CREATE TABLE main1(a,b,c);
        !            32:     CREATE TEMP TABLE temp2 AS SELECT * FROM main1;
        !            33:     SELECT * FROM sqlite_temp_master WHERE sql GLOB '*TEMP*';
        !            34:   }
        !            35: } {}
        !            36: 
        !            37: ifcapable altertable {
        !            38:   do_test tkt3630-3 {
        !            39:     db eval {
        !            40:       ALTER TABLE temp2 ADD COLUMN d;
        !            41:       ALTER TABLE temp2 RENAME TO temp2rn;
        !            42:       SELECT name FROM sqlite_temp_master WHERE name LIKE 'temp2%';
        !            43:     }
        !            44:   } {temp2rn}
        !            45: }
        !            46: 
        !            47: finish_test