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
|
# name: test/sql/catalog/view/test_view_delete_update.test
# description: Test deleting/updating views
# group: [view]
# create a table
statement ok
CREATE TABLE t1(i INTEGER)
statement ok
INSERT INTO t1 VALUES (41), (42), (43)
# create a view
statement ok
CREATE VIEW v1 AS SELECT i AS j FROM t1 WHERE i < 43
# try to delete from the view
statement error
DELETE FROM v1;
----
<REGEX>:.*Binder Error: Can only delete.*
# try to update the view
statement error
UPDATE v1 SET j=1;
----
<REGEX>:.*Binder Error: Can only update.*
|
