sqllogictest

Check-in [eaf2c620e1]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Some evidence testing for views;
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: eaf2c620e17ecbaa1fcfe2c1b1d11eb917180912
User & Date: shaneh 2010-08-10 04:29:09.000
Context
2010-09-01
18:52
Basic evidence tests for REPLACE. check-in: 9b2ad097cb user: shaneh tags: trunk
2010-08-10
04:29
Some evidence testing for views; check-in: eaf2c620e1 user: shaneh tags: trunk
04:23
Added evidence testing for triggers; check-in: 15543e896a user: shaneh tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Changes to test/evidence/slt_lang_createview.test.
︙︙
21
22
23
24
25
26
27










28
29
30
31
32
33
34


statement ok
CREATE VIEW view1 AS SELECT x FROM t1 WHERE x>0

# already exists
statement error
CREATE VIEW view1 AS SELECT x FROM t1 WHERE x>0











# TBD-EVIDENCE-OF: R-63075-15970 Once the view is created, it can be used in
# the FROM clause of another SELECT in place of a table name.

# PARTIAL-EVIDENCE-OF: R-48816-31606 If the "TEMP" or "TEMPORARY" keyword occurs
# in between "CREATE" and "VIEW" then the view that is created is only
# visible to the process that opened the database and is automatically








>
>
>
>
>
>
>
>
>
>








21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44


statement ok
CREATE VIEW view1 AS SELECT x FROM t1 WHERE x>0

# already exists
statement error
CREATE VIEW view1 AS SELECT x FROM t1 WHERE x>0

query I rowsort label-0
SELECT x FROM t1 WHERE x>0
----
1

query I rowsort label-0
SELECT x FROM view1
----
1

# TBD-EVIDENCE-OF: R-63075-15970 Once the view is created, it can be used in
# the FROM clause of another SELECT in place of a table name.

# PARTIAL-EVIDENCE-OF: R-48816-31606 If the "TEMP" or "TEMPORARY" keyword occurs
# in between "CREATE" and "VIEW" then the view that is created is only
# visible to the process that opened the database and is automatically
︙︙
Added test/evidence/slt_lang_dropview.test. 
















































































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

hash-threshold 8

statement ok
CREATE TABLE t1( x INTEGER, y VARCHAR(8) )

statement ok
INSERT INTO t1 VALUES(1,'true')

statement ok
INSERT INTO t1 VALUES(0,'false')

statement ok
INSERT INTO t1 VALUES(NULL,'NULL')

statement ok
CREATE INDEX t1i1 ON t1(x)


# EVIDENCE-OF: R-27002-52307 The DROP VIEW statement removes a view
# created by the CREATE VIEW statement.

# EVIDENCE-OF: R-31903-25381 The name specified is the view name.

statement ok
CREATE VIEW view1 AS SELECT x FROM t1 WHERE x>0

statement ok
DROP VIEW view1

# already dropped
statement error
DROP VIEW view1

# never existed
statement error
DROP VIEW viewX

statement ok
CREATE VIEW view2 AS SELECT x FROM t1 WHERE x=0

# EVIDENCE-OF: R-25468-11728 It is removed from the database schema, but
# no actual data in the underlying base tables is modified.

query I rowsort label-0
SELECT x FROM view2
----
0

statement ok
DROP VIEW view2

query I rowsort label-0
SELECT x FROM t1 WHERE x=0
----
0