Searched refs:view (Results 1 – 25 of 110) sorted by relevance
12345
19 ifcapable !view {24 do_test view-1.0 {34 do_test view-1.1 {61 } {v1 view}63 do_test view-1.2 {69 do_test view-1.3 {82 do_test view-1.4 {88 do_test view-1.5 {94 do_test view-1.6 {100 do_test view-1.7 {[all …]
45 } {table t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}50 } {table t1 {} | index i1 t1 | view v2 v2 | trigger r1 t1 |}60 } {table t1 tx | index i1 t1 | view v2 v2 | trigger r1 t1 |}69 } {tabl t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}78 } {table t9 t9 | index i1 t1 | view v2 v2 | trigger r1 t1 |}88 } {table t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}97 UPDATE sqlite_master SET type='view' WHERE name='t1';99 } {view t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}133 } {table t1 t1 | view i1 t1 | view v2 v2 | trigger r1 t1 |}166 UPDATE sqlite_master SET type='view' WHERE name='r1';[all …]
73 # -- syntax diagram drop-view-stmt97 CREATE VIEW "new view" AS SELECT * FROM t1 AS x, t1 AS y;98 SELECT * FROM "new view";101 SELECT * FROM sqlite_master WHERE name = 'new view';103 view {new view} {new view} 0 104 {CREATE VIEW "new view" AS SELECT * FROM t1 AS x, t1 AS y}107 DROP VIEW "new view";108 SELECT * FROM sqlite_master WHERE name = 'new view';111 SELECT * FROM "new view"112 } {1 {no such table: new view}}[all …]
41 create view direct_debits as44 create view monthly_direct_debits as50 create view energy as56 create view phone_internet as64 create view credit_cards as71 create view expense_overview as78 create view jan as82 create view nov as86 create view summary as
73 ifcapable view {76 create view v as select * from t1;80 } ;# ifcapable view172 ifcapable {view && trigger} {208 } ;# ifcapable (view && trigger)255 ifcapable {view && trigger} {291 } ;# ifcapable (view && trigger)297 ifcapable {trigger && view && tempdb} {303 create temp view v1 as select * from t1;304 create temp view v2 as select * from t2;[all …]
17 ifcapable {!trigger || !view} {26 create view test as136 catchsql {drop table tbl; drop view vw}139 create view vw as select * from tbl;164 #test delete from view172 #test insert into view188 #test update of view
91 # If the library was compiled to omit view support, comment out the92 # create view in the script $sql_script before executing it. Similarly,94 ifcapable !view {232 # a view refers to. Omit this test if the library is not view-enabled.234 ifcapable view {260 } ;# ifcapable view
20 # Note 3: changes() is not changed by a change to a view (since everything209 # These tests cannot run if the library does not have view support enabled.211 ifcapable view&&tempdb {219 create temp view v1 as select * from t1;220 create temp view v2 as select * from t2;281 } ;# ifcapable view
133 # Create a view in the auxilary database.134 ifcapable view {144 } {view v1 v1 0 {CREATE VIEW v1 AS SELECT * FROM t3}}152 # Drop the view 163 } ;# ifcapable view
22 ifcapable !tempdb||!view {41 # the view changes.71 ifcapable view {
430 } {1 {error in view q: no such column: col1}}450 } {1 {error in view q: no such column: LEFT}}456 } {1 {error in view q: no such column: x3}}500 } {1 {error in view v2: view v2 is circularly defined}}509 } {1 {error in view v2: view v2 is circularly defined}}546 } {1 {view v2 is circularly defined}}553 } {1 {error in view v2: view v2 is circularly defined}}
67 sql2 { SELECT name FROM sqlite_master WHERE type = 'view' }111 sql2 { SELECT name FROM sqlite_master WHERE type = 'view' }172 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'view' }178 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'view' }
33 WHERE type IN ('table', 'view') AND name NOT LIKE 'sqlite_%'286 SELECT sql FROM sqlite_master WHERE type='view';297 SELECT sql FROM sqlite_master WHERE type='view';310 SELECT sql FROM sqlite_master WHERE type='view';344 } {1 {error in view zzz: no such column: george}}476 } {1 {error in view v1: no such module: echo}}508 } {1 {cannot rename columns of view "v1"}}511 } {1 {cannot rename columns of view "v2"}}671 SELECT sql FROM sqlite_master WHERE type='view';687 } {1 {error in view v4 after rename: ambiguous column name: a}}[all …]
14 # $Id: view.test,v 1.39 2008/12/14 14:45:21 danielk1977 Exp $19 ifcapable !view {
161 # Check that things also work for view-triggers163 ifcapable view {192 } ;# ifcapable view
215 ifcapable view {219 create view v1 as select * from t1;224 } {1 {cannot create BEFORE trigger on view: v1}}228 drop view v1;229 create view v1 as select * from t1;234 } {1 {cannot create AFTER trigger on view: v1}}235 } ;# ifcapable view409 ifcapable view {410 set view_v1 {view v1}
33 } {1 {view v1 cannot reference objects in database aux}}36 } {1 {view v2 cannot reference objects in database aux}}
379 # Make sure a left join where the right table is really a view that382 ifcapable view {410 } ;# ifcapable view442 ifcapable view {451 } ;# ifcapable view
172 # Ticket #1036. When creating tables from a SELECT on a view, use the175 ifcapable view {182 create view myview as select t4.a a from t4 inner join t5 on t4.a=t5.a;
34 ifcapable view {72 ifcapable view {
163 # EVIDENCE-OF: R-01515-49025 The column appears in a trigger or view.182 error in view v1 after drop column: no such column: w190 error in view v1 after drop column: no such column: w
172 # 2. Trying to open a view column.187 ifcapable view {191 } {1 {cannot open view: v1}}
38 foreach {tn view} {49 execsql $view
66 ifcapable view {229 # schema2-9.2: Test that if a view is dropped by one database connection,245 ifcapable view {
46 # Make sure ROWID works on a view and a subquery. Ticket #36465 ifcapable view {73 } ;# ifcapable view134 ifcapable view {