diff options
author | Alexander Barkov <bar@mariadb.org> | 2016-06-10 11:34:31 +0400 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2016-06-30 11:43:02 +0200 |
commit | 2654eabbe023a4bbb3637ef6f69c421478eafc08 (patch) | |
tree | bb7323d587c237563d90946edf6f868bef3e3f4a /mysql-test/t/default.test | |
parent | 111c0f14236ac68dca8b18d1adce4fbea3608329 (diff) | |
download | mariadb-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.test | 31 |
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 # |