diff options
author | Sergei Golubchik <serg@mariadb.org> | 2022-10-02 14:38:13 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2022-10-02 14:38:13 +0200 |
commit | 3a2116241b128b811ee2455845ff9710da3115ac (patch) | |
tree | 7de53fc50126f7a19251303bd1d2a0f6cdb42069 /mysql-test/main/view.result | |
parent | e29fb956145cfa1f4f8c41cafcddea36a20b23aa (diff) | |
parent | d4f6d2f08f228778fd7744554d8b12be05b6a114 (diff) | |
download | mariadb-git-3a2116241b128b811ee2455845ff9710da3115ac.tar.gz |
Merge branch '10.4' into 10.5
Diffstat (limited to 'mysql-test/main/view.result')
-rw-r--r-- | mysql-test/main/view.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/main/view.result b/mysql-test/main/view.result index 442c024d357..ccc2fb26e11 100644 --- a/mysql-test/main/view.result +++ b/mysql-test/main/view.result @@ -6823,6 +6823,34 @@ r drop view v1; drop table t1; # +# MDEV-17124: mariadb 10.1.34, views and prepared statements: +# ERROR 1615 (HY000): Prepared statement needs to be re-prepared +# +set @tdc= @@table_definition_cache, @tc= @@table_open_cache; +set global table_definition_cache= 400, table_open_cache= 400; +create table tt (a int, primary key(a)) engine=MyISAM; +create view v as select * from tt; +insert into tt values(1),(2),(3),(4); +prepare stmt from 'select * from tt'; +#fill table definition cache +execute stmt; +a +1 +2 +3 +4 +prepare stmt from 'select * from v'; +execute stmt; +a +1 +2 +3 +4 +drop database db; +drop view v; +drop table tt; +set global table_definition_cache= @tdc, table_open_cache= @tc; +# # End of 10.2 tests # # |