Debian Codegraph @

mysql-test/suite/x/r/crud_drop_view.result

raw
1 CREATE SCHEMA xtest;
2 CREATE TABLE xtest.xtable (first INT, second JSON);
3 CREATE VIEW xtest.xview AS SELECT first FROM xtest.xtable;
4 SHOW CREATE VIEW xtest.xview;
5 View Create View character_set_client collation_connection
6 xview CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `xtest`.`xview` AS select `xtest`.`xtable`.`first` AS `first` from `xtest`.`xtable` utf8mb4 utf8mb4_0900_ai_ci
7
8 Drop view (success)
9 -------------------
10 Mysqlx.Ok {
11 }
12
13
14 Drop view (error: view removed)
15 -------------------------------
16 Mysqlx.Error {
17 severity: ERROR
18 code: 1051
19 msg: "Unknown table \'xtest.xview\'"
20 sql_state: "42S02"
21 }
22
23
24 Drop view (if exists)
25 ---------------------
26 Mysqlx.Notice.Frame {
27 type: 1
28 scope: LOCAL
29 payload: "Mysqlx.Notice.Warning { level: NOTE\ncode: 1051\nmsg: \"Unknown table \\\'xtest.xview\\\'\"\n }"
30 }
31
32 Mysqlx.Ok {
33 }
34
35 Variable_name Value
36 Mysqlx_crud_drop_view 3
37 0 rows affected
38 Mysqlx.Ok {
39 msg: "bye!"
40 }
41 ok
42 include/assert.inc [Global status of 'Mysqlx_crud_drop_view']