summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_system.test
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-03-09 14:05:35 +0200
committerMonty <monty@mariadb.org>2018-03-29 13:59:44 +0300
commita7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch)
tree70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/func_system.test
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/t/func_system.test')
-rw-r--r--mysql-test/t/func_system.test57
1 files changed, 0 insertions, 57 deletions
diff --git a/mysql-test/t/func_system.test b/mysql-test/t/func_system.test
deleted file mode 100644
index fa09e81a300..00000000000
--- a/mysql-test/t/func_system.test
+++ /dev/null
@@ -1,57 +0,0 @@
-#
-# system functions
-#
-
-select database();
-select charset(database());
-select database() = "test";
-select database() = _utf8"test";
-select database() = _latin1"test";
-
-select user() like "%@%";
-select user() like _utf8"%@%";
-select user() like _latin1"%@%";
-select charset(user());
-
-select version()>="03.23.29";
-select version()>=_utf8"03.23.29";
-select version()>=_latin1"03.23.29";
-select charset(version());
-explain extended select database(), user();
-
-create table t1 (version char(60)) select database(), user(), version() as 'version';
-show create table t1;
-drop table t1;
-
-select charset(charset(_utf8'a')), charset(collation(_utf8'a'));
-select collation(charset(_utf8'a')), collation(collation(_utf8'a'));
-create table t1 select charset(_utf8'a'), collation(_utf8'a');
-show create table t1;
-drop table t1;
-
-select TRUE,FALSE,NULL;
-
-#
-# Bug#12351: CONCAT with USER()/DATEBASE() and
-# a constant and a column gets strange results
-#
-create table t1 (c1 char(5)) character set=latin1;
-insert into t1 values('row 1');
-insert into t1 values('row 2');
-insert into t1 values('row 3');
-select concat(user(), '--', c1) from t1;
-select concat(database(), '--', c1) from t1;
-drop table t1;
-
-#
-# Bug#8291 Illegal collation mix with USER() function
-#
-create table t1 (a char(10)) character set latin1;
-select * from t1 where a=version();
-select * from t1 where a=database();
-select * from t1 where a=user();
-insert into t1 values ('a');
-select left(concat(a,version()),1) from t1;
-drop table t1;
-
-# End of 4.1 tests