|
1
by brian
clean slate |
1 |
#
|
2 |
# system functions
|
|
3 |
#
|
|
4 |
||
5 |
select database(); |
|
6 |
select database() = "test"; |
|
|
908.1.5
by Monty Taylor
Fixed func_system.test after version number change. |
7 |
|
8 |
select user() like "%@%"; |
|
9 |
||
10 |
select version() > "2009.01.756"; |
|
|
1
by brian
clean slate |
11 |
explain extended select database(), user(); |
12 |
||
13 |
create table t1 (version char(60)) select database(), user(), version() as 'version'; |
|
|
942.3.1
by Vladimir Kolesnikov
test generalizations |
14 |
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/ |
|
1
by brian
clean slate |
15 |
show create table t1; |
16 |
drop table t1; |
|
17 |
||
18 |
select TRUE,FALSE,NULL; |
|
19 |
||
20 |
#
|
|
21 |
# Bug#12351: CONCAT with USER()/DATEBASE() and
|
|
22 |
# a constant and a column gets strange results
|
|
23 |
#
|
|
|
699
by Brian Aker
Enable func_system |
24 |
create table t1 (c1 char(5)); |
|
1
by brian
clean slate |
25 |
insert into t1 values('row 1'); |
26 |
insert into t1 values('row 2'); |
|
27 |
insert into t1 values('row 3'); |
|
|
701
by Brian Aker
Make the test portable. |
28 |
select concat(SUBSTRING(user(), 0, 4), '--', c1) from t1; |
|
1
by brian
clean slate |
29 |
select concat(database(), '--', c1) from t1; |
30 |
drop table t1; |
|
31 |
||
32 |
#
|
|
33 |
# Bug#8291 Illegal collation mix with USER() function
|
|
34 |
#
|
|
|
699
by Brian Aker
Enable func_system |
35 |
create table t1 (a char(10)); |
|
1
by brian
clean slate |
36 |
select * from t1 where a=version(); |
37 |
select * from t1 where a=database(); |
|
38 |
select * from t1 where a=user(); |
|
39 |
insert into t1 values ('a'); |
|
40 |
select left(concat(a,version()),1) from t1; |
|
41 |
drop table t1; |
|
42 |
||
43 |
# End of 4.1 tests
|