summaryrefslogtreecommitdiff
path: root/mysql-test/main/func_default.test
diff options
context:
space:
mode:
authorLena Startseva <lena.startseva@mariadb.com>2022-09-28 09:40:17 +0700
committerLena Startseva <lena.startseva@mariadb.com>2022-09-28 09:40:17 +0700
commitf9bf41632e8ae9506a64d179e65a491317326eff (patch)
tree812fdf4c22f41e83ac0810227b6e476b31ac8620 /mysql-test/main/func_default.test
parent5e996fbad9e2326a197731c594c11ade8a3c2492 (diff)
parent8bc9ee9571e19286f6706c38fb2afac13f9ea8a4 (diff)
downloadmariadb-git-f9bf41632e8ae9506a64d179e65a491317326eff.tar.gz
Merge branch 'bb-10.9-all-builders' into bb-10.10-all-builders
Diffstat (limited to 'mysql-test/main/func_default.test')
-rw-r--r--mysql-test/main/func_default.test5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/main/func_default.test b/mysql-test/main/func_default.test
index 3cb88b7b597..ebd4f6e7b1e 100644
--- a/mysql-test/main/func_default.test
+++ b/mysql-test/main/func_default.test
@@ -142,6 +142,9 @@ DROP TABLE t1;
--echo #
--echo # MDEV-21028 Server crashes in Query_arena::set_query_arena upon SELECT from view
--echo #
+#view protocol generates additional statistics
+--disable_view_protocol
+
create table t1 (a datetime default current_timestamp);
insert into t1 () values (),();
create algorithm=temptable view v1 as select * from t1;
@@ -151,6 +154,8 @@ select default(a) = now() from v2;
drop view v1, v2;
drop table t1;
+--enable_view_protocol
+
create table t1 (v1 timestamp not null default now() on update now()) select 'x';
show create table t1;
select default(v1) from (select v1 from t1) dt;