summaryrefslogtreecommitdiff
path: root/mysql-test/main/second_frac-9175.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/second_frac-9175.test')
-rw-r--r--mysql-test/main/second_frac-9175.test5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/main/second_frac-9175.test b/mysql-test/main/second_frac-9175.test
index 91baf997459..4cda672b820 100644
--- a/mysql-test/main/second_frac-9175.test
+++ b/mysql-test/main/second_frac-9175.test
@@ -2,8 +2,13 @@
# MDEV-9175 Query parser tansforms MICROSECOND into SECOND_FRAC, which does not work
#
+#enable after fix MDEV-27871
+--disable_view_protocol
+
select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456');
explain extended select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456');
create view v1 as select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456');
select * from v1;
drop view v1;
+
+--enable_view_protocol