summaryrefslogtreecommitdiff
path: root/mysql-test/main/func_default.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2022-04-21 10:04:04 +0200
committerSergei Golubchik <serg@mariadb.org>2022-04-21 10:05:50 +0200
commit6f6c74b0d18d5d4fa8a112a6793653ef5242726d (patch)
tree0410c1f500341283233dbb9cb39511aab9baf123 /mysql-test/main/func_default.test
parent4730314a70119ae5857edffe2d1bec86960ef22b (diff)
parent5ba77222e9fe7af8ff403816b5338b18b342053c (diff)
downloadmariadb-git-6f6c74b0d18d5d4fa8a112a6793653ef5242726d.tar.gz
Merge branch '10.2' into 10.3
Diffstat (limited to 'mysql-test/main/func_default.test')
-rw-r--r--mysql-test/main/func_default.test27
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/main/func_default.test b/mysql-test/main/func_default.test
index cba7842c68f..daa99f1f459 100644
--- a/mysql-test/main/func_default.test
+++ b/mysql-test/main/func_default.test
@@ -140,5 +140,32 @@ SELECT a FROM t1 WHERE CASE WHEN a THEN DEFAULT(a) END IS FALSE;
DROP TABLE t1;
--echo #
+--echo # MDEV-21028 Server crashes in Query_arena::set_query_arena upon SELECT from view
+--echo #
+create table t1 (a datetime default current_timestamp);
+insert into t1 () values (),();
+create algorithm=temptable view v1 as select * from t1;
+create algorithm=merge view v2 as select * from t1;
+select default(a) = now() from v1;
+select default(a) = now() from v2;
+--sorted_result
+select table_name,is_updatable from information_schema.views;
+drop view v1, v2;
+drop table t1;
+
+create table t1 (v1 timestamp) select 'x';
+show create table t1;
+select default(v1) from (select v1 from t1) dt;
+select default(v1) from (select v1 from t1 group by v1) dt;
+drop table t1;
+
+create table t1 (a text default '');
+create algorithm=temptable view v1 as select * from t1;
+insert into t1 values ('a');
+select default(a) from v1;
+drop view v1;
+drop table t1;
+
+--echo #
--echo # End of 10.2 tests
--echo #