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: | eaf2c620e17ecbaa1fcfe2c1b1d11eb9 |
| User & Date: | shaneh 2010-08-10 04:29:09 |
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
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 |