diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-03-29 11:13:18 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-03-29 11:13:18 +0300 |
| commit | ae6e214fd851a8a9d079494eec9903c89dd10fb2 (patch) | |
| tree | b206f873d02a5a2027671bb1cd900b77d1a3b820 /mysql-test/main/view.test | |
| parent | 97f237e66dc58a617b6293d6a2624378333e8065 (diff) | |
| parent | 020e7d89ebdcded3355c82cec93e0abef2898258 (diff) | |
| download | mariadb-git-ae6e214fd851a8a9d079494eec9903c89dd10fb2.tar.gz | |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/view.test')
| -rw-r--r-- | mysql-test/main/view.test | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/main/view.test b/mysql-test/main/view.test index 6c079c48b00..5b813b45a62 100644 --- a/mysql-test/main/view.test +++ b/mysql-test/main/view.test @@ -6578,6 +6578,32 @@ Drop View v1; Drop table t1; --echo # +--echo # MDEV-24281: Execution of PREPARE from CREATE VIEW statement +--echo # + +create table t1 (s1 int); +insert into t1 values (3), (7), (1); + +prepare stmt from " +create view v1 as select 's1', s1, 1 as My_exp_s1 from t1; +"; +execute stmt; +deallocate prepare stmt; +show create view v1; +select * from v1; +drop view v1; + +prepare stmt from " +create view v1 as select 's1', s1, 1 as My_exp_s1 from t1; +"; +execute stmt; +--error ER_TABLE_EXISTS_ERROR +execute stmt; +deallocate prepare stmt; +drop view v1; +drop table t1; + +--echo # --echo # End of 10.3 tests --echo # |