diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-03-13 08:15:06 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-03-13 08:15:06 +0200 |
| commit | 7fb03d7abf4e668d76aded38378120361c218ba4 (patch) | |
| tree | ab6a8f7d29479970e5d3b48b0d671d1dc07c166e /mysql-test/r/query_cache.result | |
| parent | 09c5c335e3e8447e7d07c987293042175b51b495 (diff) | |
| parent | 1c4b6afbaaf7dbcee4b035d1bf79156fa68a6475 (diff) | |
| download | mariadb-git-7fb03d7abf4e668d76aded38378120361c218ba4.tar.gz | |
Merge bb-10.2-ext into 10.3
Diffstat (limited to 'mysql-test/r/query_cache.result')
| -rw-r--r-- | mysql-test/r/query_cache.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result index bb8703b4185..9c010cbffc7 100644 --- a/mysql-test/r/query_cache.result +++ b/mysql-test/r/query_cache.result @@ -2168,6 +2168,25 @@ show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 drop table t1; +# +# MDEV-15328: MariaDB 10.2.13 Crashes upon CALL PROCEDURE PARAM +# LAST_INSERT_ID () +# (part 2, part 1 is in sp.test) +# +create table t1 (a int); +insert into t1 values (1); +CREATE FUNCTION foo (i INT UNSIGNED ) RETURNS int deterministic RETURN 1; +show status like "Qcache_queries_in_cache"; +Variable_name Value +Qcache_queries_in_cache 0 +SELECT foo( LAST_INSERT_ID() ) from t1; +foo( LAST_INSERT_ID() ) +1 +show status like "Qcache_queries_in_cache"; +Variable_name Value +Qcache_queries_in_cache 0 +DROP FUNCTION foo; +drop table t1; restore defaults SET GLOBAL query_cache_type= default; SET GLOBAL query_cache_size= default; |