diff options
author | Sergei Golubchik <serg@mariadb.org> | 2022-04-21 10:04:04 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2022-04-21 10:05:50 +0200 |
commit | 6f6c74b0d18d5d4fa8a112a6793653ef5242726d (patch) | |
tree | 0410c1f500341283233dbb9cb39511aab9baf123 /mysql-test/main/func_default.test | |
parent | 4730314a70119ae5857edffe2d1bec86960ef22b (diff) | |
parent | 5ba77222e9fe7af8ff403816b5338b18b342053c (diff) | |
download | mariadb-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.test | 27 |
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 # |