summaryrefslogtreecommitdiff
path: root/mysql-test/t/default.test
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2016-06-10 11:34:31 +0400
committerSergei Golubchik <serg@mariadb.org>2016-06-30 11:43:02 +0200
commit2654eabbe023a4bbb3637ef6f69c421478eafc08 (patch)
treebb7323d587c237563d90946edf6f868bef3e3f4a /mysql-test/t/default.test
parent111c0f14236ac68dca8b18d1adce4fbea3608329 (diff)
downloadmariadb-git-2654eabbe023a4bbb3637ef6f69c421478eafc08.tar.gz
More test for MDEV-10134 Add full support for DEFAULT
Miscelaneous functions: LIKE_RANGE_MIN(), LIKE_RANGE_MAX(), WEIGHT_STRING(), GET_FORMAT(), FORMAT(), LOAD_FILE().
Diffstat (limited to 'mysql-test/t/default.test')
-rw-r--r--mysql-test/t/default.test31
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/t/default.test b/mysql-test/t/default.test
index f5ac7049b05..ed9a4d491b5 100644
--- a/mysql-test/t/default.test
+++ b/mysql-test/t/default.test
@@ -1474,6 +1474,37 @@ INSERT INTO t1 (a) VALUES (64);
SELECT * FROM t1;
DROP TABLE t1;
+# QQ: this depends on @@lc_time_names
+CREATE TABLE t1 (a INT, b INT, c VARCHAR(30) DEFAULT FORMAT(a,b));
+INSERT INTO t1 (a,b) VALUES (10000,3);
+SELECT * FROM t1;
+DROP TABLE t1;
+
+CREATE TABLE t1 (a INT, b INT, l VARCHAR(10), c VARCHAR(30) DEFAULT FORMAT(a,b,l));
+INSERT INTO t1 (a,b,l) VALUES (10000,2,'no_NO'),(10000,2,'ru_RU'),(10000,2,'ar_BH');
+SELECT * FROM t1;
+DROP TABLE t1;
+
+CREATE TABLE t1 (a VARCHAR(10), b VARCHAR(20) DEFAULT GET_FORMAT(DATE,a));
+INSERT INTO t1 (a) VALUES ('EUR'),('USA'),('JIS'),('ISO'),('INTERNAL');
+SELECT * FROM t1;
+DROP TABLE t1;
+
+CREATE TABLE t1 (
+ bits INT,
+ v_on VARCHAR(10),
+ v_off VARCHAR(10),
+ v_separator VARCHAR(10),
+ number_of_bits INT,
+ x VARCHAR(30) DEFAULT EXPORT_SET(bits, v_on, v_off, v_separator, number_of_bits)
+);
+INSERT INTO t1 VALUES (0x50006,'Y','N','',64,DEFAULT);
+SELECT * FROM t1;
+DROP TABLE t1;
+
+--error ER_VIRTUAL_COLUMN_FUNCTION_IS_NOT_ALLOWED
+CREATE TABLE t1 (a VARCHAR(30), b BLOB DEFAULT LOAD_FILE(a));
+
--echo #
--echo # Predicates
--echo #