blob: 84a7f45ace556e747bb5636ec0a7bfe02a52f846 [file] [log] [blame]
drhff78bd22002-02-27 01:47:11 +00001# 2002 February 26
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. The
12# focus of this file is testing VIEW statements.
13#
14# $Id: view.test,v 1.1 2002/02/27 01:47:12 drh Exp $
15set testdir [file dirname $argv0]
16source $testdir/tester.tcl
17
18do_test view-1.0 {
19 execsql {
20 CREATE TABLE t1(a,b,c);
21 INSERT INTO t1 VALUES(1,2,3);
22 INSERT INTO t1 VALUES(4,5,6);
23 INSERT INTO t1 VALUES(7,8,9);
24 SELECT * FROM t1;
25 }
26} {1 2 3 4 5 6 7 8 9}
27
28do_test view-1.1 {
29 execsql {
30 BEGIN;
31 CREATE VIEW v1 AS SELECT a,b FROM t1;
32 SELECT * FROM v1 ORDER BY a;
33 }
34} {1 2 4 5 7 8}
35do_test view-1.2 {
36 catchsql {
37 ROLLBACK;
38 SELECT * FROM v1 ORDER BY a;
39 }
40} {1 {no such table: v1}}
41do_test view-1.3 {
42 execsql {
43 CREATE VIEW v1 AS SELECT a,b FROM t1;
44 SELECT * FROM v1 ORDER BY a;
45 }
46} {1 2 4 5 7 8}
47do_test view-1.4 {
48 catchsql {
49 DROP VIEW v1;
50 SELECT * FROM v1 ORDER BY a;
51 }
52} {1 {no such table: v1}}
53do_test view-1.5 {
54 execsql {
55 CREATE VIEW v1 AS SELECT a,b FROM t1;
56 SELECT * FROM v1 ORDER BY a;
57 }
58} {1 2 4 5 7 8}
59do_test view-1.6 {
60 catchsql {
61 DROP TABLE t1;
62 SELECT * FROM v1 ORDER BY a;
63 }
64} {1 {no such table: t1}}
65do_test view-1.7 {
66 execsql {
67 CREATE TABLE t1(x,a,b,c);
68 INSERT INTO t1 VALUES(1,2,3,4);
69 INSERT INTO t1 VALUES(4,5,6,7);
70 INSERT INTO t1 VALUES(7,8,9,10);
71 SELECT * FROM v1 ORDER BY a;
72 }
73} {2 3 5 6 8 9}
74
75finish_test