1 # 2005 September 19 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 # This file implements regression tests for SQLite library. 12 # 13 # This file implements tests to verify that ticket #1444 has been 14 # fixed. 15 # 16 17 set testdir [file dirname $argv0] 18 source $testdir/tester.tcl 19 20 ifcapable !compound||!view { 21 finish_test 22 return 23 } 24 25 # The use of a VIEW that contained an ORDER BY clause within a UNION ALL 26 # was causing problems. See ticket #1444. 27 # 28 do_test tkt1444-1.1 { 29 execsql { 30 CREATE TABLE DemoTable (x INTEGER, TextKey TEXT, DKey Real); 31 CREATE INDEX DemoTableIdx ON DemoTable (TextKey); 32 INSERT INTO DemoTable VALUES(9,8,7); 33 INSERT INTO DemoTable VALUES(1,2,3); 34 CREATE VIEW DemoView AS SELECT * FROM DemoTable ORDER BY TextKey; 35 SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView ORDER BY 1; 36 } 37 } {1 2 3.0 1 2 3.0 9 8 7.0 9 8 7.0} 38 do_test tkt1444-1.2 { 39 execsql { 40 SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView; 41 } 42 } {9 8 7.0 1 2 3.0 1 2 3.0 9 8 7.0} 43 do_test tkt1444-1.3 { 44 execsql { 45 DROP VIEW DemoView; 46 CREATE VIEW DemoView AS SELECT * FROM DemoTable; 47 SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView ORDER BY 1; 48 } 49 } {1 2 3.0 1 2 3.0 9 8 7.0 9 8 7.0} 50 do_test tkt1444-1.4 { 51 execsql { 52 SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView; 53 } 54 } {9 8 7.0 1 2 3.0 9 8 7.0 1 2 3.0} 55 56 finish_test 57
