← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_system.result

  • Committer: Brian Aker
  • Date: 2009-01-17 02:46:52 UTC
  • Revision ID: brian@gir-3.local-20090117024652-4ducefje08ajbs1q
Refactor append_identifier and remove dead OPTION_QUOTE_SHOW_CREATE option
(we always quote).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_system.result
4
4
select database() = "test";
5
5
database() = "test"
6
6
1
 
7
select database() = _utf8"test";
 
8
database() = _utf8"test"
 
9
1
7
10
select user() like "%@%";
8
11
user() like "%@%"
9
12
1
10
 
select version() > "2009.01.756";
11
 
version() > "2009.01.756"
 
13
select user() like _utf8"%@%";
 
14
user() like _utf8"%@%"
 
15
1
 
16
select version()>="3.23.29";
 
17
version()>="3.23.29"
 
18
1
 
19
select version()>=_utf8"3.23.29";
 
20
version()>=_utf8"3.23.29"
12
21
1
13
22
explain extended select database(), user();
14
23
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
19
28
show create table t1;
20
29
Table   Create Table
21
30
t1      CREATE TABLE `t1` (
22
 
  `database()` varbinary(136) DEFAULT NULL,
23
 
  `user()` varbinary(308) DEFAULT NULL,
24
 
  `version` varchar(60) DEFAULT NULL
25
 
) ENGINE=DEFAULT
 
31
  `database()` varchar(34),
 
32
  `user()` varchar(77),
 
33
  `version` varchar(60)
 
34
) ENGINE=InnoDB
26
35
drop table t1;
27
36
select TRUE,FALSE,NULL;
28
37
TRUE    FALSE   NULL