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

     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 temp.sqlite_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 temp.sqlite_master WHERE name LIKE 'temp2%';
    43      }
    44    } {temp2rn}
    45  }
    46  
    47  finish_test