diff options
Diffstat (limited to 'mysql-test/t/func_system.test')
-rw-r--r-- | mysql-test/t/func_system.test | 57 |
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 |