1# The author disclaims copyright to this source code. In place of 2# a legal notice, here is a blessing: 3# 4# May you do good and not evil. 5# May you find forgiveness for yourself and forgive others. 6# May you share freely, never taking more than you give. 7# 8#*********************************************************************** 9# This file implements regression tests for SQLite library. The 10# focus of this file is testing compute SELECT statements and nested 11# views. 12# 13# $Id: select7.test,v 1.2 2004/11/22 08:43:32 danielk1977 Exp $ 14 15 16set testdir [file dirname $argv0] 17source $testdir/tester.tcl 18 19# A 3-way INTERSECT. Ticket #875 20do_test select7-1.1 { 21 execsql { 22 create temp table t1(x); 23 insert into t1 values('amx'); 24 insert into t1 values('anx'); 25 insert into t1 values('amy'); 26 insert into t1 values('bmy'); 27 select * from t1 where x like 'a__' 28 intersect select * from t1 where x like '_m_' 29 intersect select * from t1 where x like '__x'; 30 } 31} {amx} 32 33 34# Nested views do not handle * properly. Ticket #826. 35# 36ifcapable view { 37do_test select7-2.1 { 38 execsql { 39 CREATE TABLE x(id integer primary key, a TEXT NULL); 40 INSERT INTO x (a) VALUES ('first'); 41 CREATE TABLE tempx(id integer primary key, a TEXT NULL); 42 INSERT INTO tempx (a) VALUES ('t-first'); 43 CREATE VIEW tv1 AS SELECT x.id, tx.id FROM x JOIN tempx tx ON tx.id=x.id; 44 CREATE VIEW tv1b AS SELECT x.id, tx.id FROM x JOIN tempx tx on tx.id=x.id; 45 CREATE VIEW tv2 AS SELECT * FROM tv1 UNION SELECT * FROM tv1b; 46 SELECT * FROM tv2; 47 } 48} {1 1} 49} ;# ifcapable view 50 51 52finish_test 53