summaryrefslogtreecommitdiff
path: root/mysql-test/suite/versioning/t
diff options
context:
space:
mode:
authorAleksey Midenkov <midenok@gmail.com>2018-04-28 14:18:02 +0300
committerSergei Golubchik <serg@mariadb.org>2018-05-12 10:16:46 +0200
commitce2cf855bfc0d9c8adb64f02a7b32ddd81f9948a (patch)
tree2c68efc046ca8a4c2de8f1e10d4b1c09fe8a4cb2 /mysql-test/suite/versioning/t
parent8b2fa0ab25976bceb88a949ef1cc2c0b62de3df0 (diff)
downloadmariadb-git-ce2cf855bfc0d9c8adb64f02a7b32ddd81f9948a.tar.gz
MDEV-16043 Assertion thd->Item_change_list::is_empty() failed in mysql_parse upon SELECT from a view reading from a versioned table
Lost restore_active_arena(). Using of Query_arena_stmt is suggested instead.
Diffstat (limited to 'mysql-test/suite/versioning/t')
-rw-r--r--mysql-test/suite/versioning/t/select2.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/t/select2.test b/mysql-test/suite/versioning/t/select2.test
index 7caec784e27..d1b73fa799b 100644
--- a/mysql-test/suite/versioning/t/select2.test
+++ b/mysql-test/suite/versioning/t/select2.test
@@ -202,6 +202,14 @@ select * from (select * from t1 for system_time all, t2 for system_time all) for
--error ER_PARSE_ERROR
select * from (t1 for system_time all join t2 for system_time all) for system_time all;
+--echo # MDEV-16043 Assertion thd->Item_change_list::is_empty() failed in mysql_parse upon SELECT from a view reading from a versioned table
+create or replace table t1 (a int) with system versioning;
+create or replace view v1 as select * from t1;
+prepare stmt from "select * from t1 where exp( '20010609211642053929' )";
+--error ER_DATA_OUT_OF_RANGE
+execute stmt;
+select a from v1;
+
drop view v1;
drop table t1, t2;