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 48
