summaryrefslogtreecommitdiff
path: root/mysql-test/t/statistics.test
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2016-06-10 12:10:17 +0400
committerSergei Golubchik <serg@mariadb.org>2016-06-30 11:43:02 +0200
commit6c626117e7eab8c088f3f4afaadb098a16638918 (patch)
tree5ecca16ada6b5845c2af220b32d2cec8a4981a9f /mysql-test/t/statistics.test
parent2654eabbe023a4bbb3637ef6f69c421478eafc08 (diff)
downloadmariadb-git-6c626117e7eab8c088f3f4afaadb098a16638918.tar.gz
More test for MDEV-10134 Add full support for DEFAULT
Miscelaneous functions: BENCHMARK(), SLEEP(), ROW_COUNT(), FOUND_ROWS(), GET_LOCK(), RELEASE_LOCK(), IS_USED_LOCK(), IS_FREE_LOCK(), MASTER_POS_WAIT(), MASTER_GTID_WAIT(), BINLOG_GTID_POS(), ST_GIS_DEBUG(), DECODE_HISTOGRAM(),
Diffstat (limited to 'mysql-test/t/statistics.test')
-rw-r--r--mysql-test/t/statistics.test17
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/statistics.test b/mysql-test/t/statistics.test
index 805c169b2a4..7908fda0ced 100644
--- a/mysql-test/t/statistics.test
+++ b/mysql-test/t/statistics.test
@@ -741,3 +741,20 @@ analyze table t1;
drop table t1;
set use_stat_tables=@save_use_stat_tables;
+
+--echo #
+--echo # Start of 10.2 tests
+--echo #
+
+--echo #
+--echo # MDEV-10134 Add full support for DEFAULT
+--echo #
+
+CREATE TABLE t1 (a BLOB, b TEXT DEFAULT DECODE_HISTOGRAM('SINGLE_PREC_HB',a));
+INSERT INTO t1 (a) VALUES (0x0000000000000000000000000101010101010101010202020303030304040404050505050606070707080809090A0A0B0C0D0D0E0E0F10111213131415161718191B1C1E202224292A2E33373B4850575F6A76818C9AA7B9C4CFDADFE5EBF0F4F8FAFCFF);
+SELECT b FROM t1;
+DROP TABLE t1;
+
+--echo #
+--echo # End of 10.2 tests
+--echo #