~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/collation_dictionary/tests/r/data_dictionary.result

Merging Stewart's show create table patch.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
use data_dictionary;
2
2
show create table CHARACTER_SETS ;
3
3
Table   Create Table
4
 
CHARACTER_SETS  CREATE TABLE `character_sets` (
 
4
CHARACTER_SETS  CREATE TABLE `CHARACTER_SETS` (
5
5
  `CHARACTER_SET_NAME` varchar(256) NOT NULL,
6
6
  `DEFAULT_COLLATE_NAME` varchar(256) NOT NULL,
7
7
  `DESCRIPTION` varchar(256) NOT NULL,
8
8
  `MAXLEN` bigint NOT NULL
9
 
) ENGINE=FunctionEngine
 
9
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
10
10
show create table COLLATIONS ;
11
11
Table   Create Table
12
 
COLLATIONS      CREATE TABLE `collations` (
 
12
COLLATIONS      CREATE TABLE `COLLATIONS` (
13
13
  `CHARACTER_SET_NAME` varchar(256) NOT NULL,
14
14
  `COLLATION_NAME` varchar(256) NOT NULL,
15
15
  `DESCRIPTION` varchar(256) NOT NULL,
17
17
  `IS_DEFAULT` varchar(5) NOT NULL,
18
18
  `IS_COMPILED` varchar(5) NOT NULL,
19
19
  `SORTLEN` bigint NOT NULL
20
 
) ENGINE=FunctionEngine
 
20
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
21
21
SELECT * FROM character_sets ORDER BY CHARACTER_SET_NAME;
22
22
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
23
23
binary  binary          1