25 lines
797 B
Plaintext
25 lines
797 B
Plaintext
# TestRenameViewOverDifferentSchemaError
|
|
drop database if exists ddl__ddl_error2;
|
|
drop table if exists table_1;
|
|
drop view if exists view_1;
|
|
create database test_2;
|
|
create table table_1 (a int);
|
|
create view view_1 as select a from table_1;
|
|
-- error 1450
|
|
rename table ddl__ddl_error.view_1 to ddl__ddl_error2.view_1;
|
|
-- error 1450
|
|
rename table ddl__ddl_error.view_1 to ddl__ddl_error2.view_1;
|
|
-- error 1450
|
|
rename table ddl__ddl_error.view_1 to ddl__ddl_error2.view_1;
|
|
rename table ddl__ddl_error.view_1 to ddl__ddl_error.view_1000;
|
|
|
|
# issue 53176
|
|
-- error 1351
|
|
create view sql_mode_view as select @@sql_mode;
|
|
-- error 1351
|
|
create view sql_mode_view as select @@global.sql_mode;
|
|
-- error 1351
|
|
create view sql_mode_view as select @a;
|
|
-- error 1351
|
|
create view sql_mode_view as select 1 where @a = 4;
|