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 19set testdir [file dirname $argv0] 20 21source $testdir/tester.tcl 22 23do_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} {} 29do_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 37ifcapable 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 47finish_test 48