diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2018-03-15 01:32:09 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2018-03-15 01:32:09 +0300 |
| commit | 9fed7d43a58e2e2279afb8ac0a321f9db090420a (patch) | |
| tree | dfa2a094f40f911d302e08e72467e2f0ff12fcc8 /mysql-test/t/query_cache.test | |
| parent | 2b7e3ffd31672c908fe8f612f9b261f80235328b (diff) | |
| download | mariadb-git-bb-10.2-compatibility-mdev15509-debug.tar.gz | |
Apply this commit to bb-10.2-compatibility-mdev15509-debug:bb-10.2-compatibility-mdev15509-debug
commit 5511e8ed5941e3b5a7687f87a1fb4fa75815ee7b
Author: Oleksandr Byelkin <sanja@mariadb.com>
Date: Mon Mar 5 17:43:30 2018 +0100
MDEV-15328: MariaDB 10.2.13 Crashes upon CALL PROCEDURE PARAM LAST_INSERT_ID ()
There is not current SELECT during assigning SP parameters, do not use it if current_select is empty.
Diffstat (limited to 'mysql-test/t/query_cache.test')
| -rw-r--r-- | mysql-test/t/query_cache.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index c354032bc36..1b1e24bc6f4 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -1767,6 +1767,21 @@ show status like "Qcache_inserts"; show status like "Qcache_hits"; drop table t1; +--echo # +--echo # MDEV-15328: MariaDB 10.2.13 Crashes upon CALL PROCEDURE PARAM +--echo # LAST_INSERT_ID () +--echo # (part 2, part 1 is in sp.test) +--echo # + +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"; +SELECT foo( LAST_INSERT_ID() ) from t1; +show status like "Qcache_queries_in_cache"; +DROP FUNCTION foo; +drop table t1; + --echo restore defaults SET GLOBAL query_cache_type= default; SET GLOBAL query_cache_size= default; |