1select database(); 2database() 3test 4select charset(database()); 5charset(database()) 6utf8 7select database() = "test"; 8database() = "test" 91 10select database() = _utf8"test"; 11database() = _utf8"test" 121 13select database() = _latin1"test"; 14database() = _latin1"test" 151 16select user() like "%@%"; 17user() like "%@%" 181 19select user() like _utf8"%@%"; 20user() like _utf8"%@%" 211 22select user() like _latin1"%@%"; 23user() like _latin1"%@%" 241 25select charset(user()); 26charset(user()) 27utf8 28select version()>="03.23.29"; 29version()>="03.23.29" 301 31select version()>=_utf8"03.23.29"; 32version()>=_utf8"03.23.29" 331 34select version()>=_latin1"03.23.29"; 35version()>=_latin1"03.23.29" 361 37select charset(version()); 38charset(version()) 39utf8 40explain extended select database(), user(); 41id select_type table type possible_keys key key_len ref rows filtered Extra 421 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used 43Warnings: 44Note 1003 select database() AS `database()`,user() AS `user()` 45create table t1 (version char(60)) select database(), user(), version() as 'version'; 46show create table t1; 47Table Create Table 48t1 CREATE TABLE `t1` ( 49 `database()` varchar(64) CHARACTER SET utf8 DEFAULT NULL, 50 `user()` varchar(141) CHARACTER SET utf8 DEFAULT NULL, 51 `version` char(60) DEFAULT NULL 52) ENGINE=MyISAM DEFAULT CHARSET=latin1 53drop table t1; 54select charset(charset(_utf8'a')), charset(collation(_utf8'a')); 55charset(charset(_utf8'a')) charset(collation(_utf8'a')) 56utf8 utf8 57select collation(charset(_utf8'a')), collation(collation(_utf8'a')); 58collation(charset(_utf8'a')) collation(collation(_utf8'a')) 59utf8_general_ci utf8_general_ci 60create table t1 select charset(_utf8'a'), collation(_utf8'a'); 61show create table t1; 62Table Create Table 63t1 CREATE TABLE `t1` ( 64 `charset(_utf8'a')` varchar(64) CHARACTER SET utf8 DEFAULT NULL, 65 `collation(_utf8'a')` varchar(64) CHARACTER SET utf8 DEFAULT NULL 66) ENGINE=MyISAM DEFAULT CHARSET=latin1 67drop table t1; 68select TRUE,FALSE,NULL; 69TRUE FALSE NULL 701 0 NULL 71create table t1 (c1 char(5)) character set=latin1; 72insert into t1 values('row 1'); 73insert into t1 values('row 2'); 74insert into t1 values('row 3'); 75select concat(user(), '--', c1) from t1; 76concat(user(), '--', c1) 77root@localhost--row 1 78root@localhost--row 2 79root@localhost--row 3 80select concat(database(), '--', c1) from t1; 81concat(database(), '--', c1) 82test--row 1 83test--row 2 84test--row 3 85drop table t1; 86create table t1 (a char(10)) character set latin1; 87select * from t1 where a=version(); 88a 89select * from t1 where a=database(); 90a 91select * from t1 where a=user(); 92a 93insert into t1 values ('a'); 94select left(concat(a,version()),1) from t1; 95left(concat(a,version()),1) 96a 97drop table t1; 98# 99# Start of 10.2 tests 100# 101 102MDEV-27544 database() function under UNION ALL truncates results to 34 characters 103 104 105SET NAMES utf8; 106create database betäubungsmittelverschreibungsverordnung; 107use betäubungsmittelverschreibungsverordnung; 108select database() as "database" union all select database(); 109database 110betäubungsmittelverschreibungsverordnung 111betäubungsmittelverschreibungsverordnung 112drop database betäubungsmittelverschreibungsverordnung; 113# 114# End of 10.2 tests 115# 116