44 lines
1.0 KiB
Plaintext
44 lines
1.0 KiB
Plaintext
CREATE SCHEMA xtest;
|
|
CREATE TABLE xtest.xtable (first INT, second JSON);
|
|
CREATE VIEW xtest.xview AS SELECT first FROM xtest.xtable;
|
|
SHOW CREATE VIEW xtest.xview;
|
|
View Create View character_set_client collation_connection
|
|
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
|
|
|
|
Drop view (success)
|
|
-------------------
|
|
Mysqlx.Ok {
|
|
}
|
|
|
|
|
|
Drop view (error: view removed)
|
|
-------------------------------
|
|
Mysqlx.Error {
|
|
severity: ERROR
|
|
code: 1051
|
|
msg: "Unknown table \'xtest.xview\'"
|
|
sql_state: "42S02"
|
|
}
|
|
|
|
|
|
Drop view (if exists)
|
|
---------------------
|
|
Mysqlx.Notice.Frame {
|
|
type: 1
|
|
scope: LOCAL
|
|
payload: "Mysqlx.Notice.Warning { level: NOTE\ncode: 1051\nmsg: \"Unknown table \\\'xtest.xview\\\'\"\n }"
|
|
}
|
|
|
|
Mysqlx.Ok {
|
|
}
|
|
|
|
Variable_name Value
|
|
Mysqlx_crud_drop_view 3
|
|
0 rows affected
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
include/assert.inc [Global status of 'Mysqlx_crud_drop_view']
|
|
DROP SCHEMA IF EXISTS xtest;
|