← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/character_collation_dictionary.result

Update for test split.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/character_collation_dictionary.result
 
1
CREATE SCHEMA data_dictionary;
 
2
use data_dictionary;
 
3
show create table CHARACTER_SETS ;
 
4
Table   Create Table
 
5
CHARACTER_SETS  CREATE TABLE `character_sets` (
 
6
  `CHARACTER_SET_NAME` varchar(64) NOT NULL DEFAULT '',
 
7
  `DEFAULT_COLLATE_NAME` varchar(64) NOT NULL DEFAULT '',
 
8
  `DESCRIPTION` varchar(64) NOT NULL DEFAULT '',
 
9
  `MAXLEN` bigint NOT NULL DEFAULT '0'
 
10
) ENGINE=FunctionEngine
 
11
show create table COLLATIONS ;
 
12
Table   Create Table
 
13
COLLATIONS      CREATE TABLE `collations` (
 
14
  `CHARACTER_SET_NAME` varchar(64) NOT NULL DEFAULT '',
 
15
  `COLLATION_NAME` varchar(64) NOT NULL DEFAULT '',
 
16
  `DESCRIPTION` varchar(64) NOT NULL DEFAULT '',
 
17
  `ID` bigint NOT NULL DEFAULT '0',
 
18
  `IS_DEFAULT` varchar(5) NOT NULL DEFAULT '',
 
19
  `IS_COMPILED` varchar(5) NOT NULL DEFAULT '',
 
20
  `SORTLEN` bigint NOT NULL DEFAULT '0'
 
21
) ENGINE=FunctionEngine
 
22
SELECT * FROM character_sets ORDER BY CHARACTER_SET_NAME;
 
23
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
 
24
binary  binary  UTF-8 Unicode   1
 
25
utf8    utf8_general_ci UTF-8 Unicode   4
 
26
SELECT * FROM collations ORDER BY COLLATION_NAME;
 
27
CHARACTER_SET_NAME      COLLATION_NAME  DESCRIPTION     ID      IS_DEFAULT      IS_COMPILED     SORTLEN
 
28
binary  binary  binary  63      TRUE    TRUE    1
 
29
utf8_general_ci utf8_bin        utf8    46      FALSE   TRUE    1
 
30
utf8_general_ci utf8_czech_ci   utf8    234     FALSE   TRUE    8
 
31
utf8_general_ci utf8_danish_ci  utf8    235     FALSE   TRUE    8
 
32
utf8_general_ci utf8_esperanto_ci       utf8    241     FALSE   TRUE    8
 
33
utf8_general_ci utf8_estonian_ci        utf8    230     FALSE   TRUE    8
 
34
utf8_general_ci utf8_general_ci utf8    45      TRUE    TRUE    1
 
35
utf8_general_ci utf8_hungarian_ci       utf8    242     FALSE   TRUE    8
 
36
utf8_general_ci utf8_icelandic_ci       utf8    225     FALSE   TRUE    8
 
37
utf8_general_ci utf8_latvian_ci utf8    226     FALSE   TRUE    8
 
38
utf8_general_ci utf8_lithuanian_ci      utf8    236     FALSE   TRUE    8
 
39
utf8_general_ci utf8_persian_ci utf8    240     FALSE   TRUE    8
 
40
utf8_general_ci utf8_polish_ci  utf8    229     FALSE   TRUE    8
 
41
utf8_general_ci utf8_romanian_ci        utf8    227     FALSE   TRUE    8
 
42
utf8_general_ci utf8_roman_ci   utf8    239     FALSE   TRUE    8
 
43
utf8_general_ci utf8_sinhala_ci utf8    243     FALSE   TRUE    8
 
44
utf8_general_ci utf8_slovak_ci  utf8    237     FALSE   TRUE    8
 
45
utf8_general_ci utf8_slovenian_ci       utf8    228     FALSE   TRUE    8
 
46
utf8_general_ci utf8_spanish2_ci        utf8    238     FALSE   TRUE    8
 
47
utf8_general_ci utf8_spanish_ci utf8    231     FALSE   TRUE    8
 
48
utf8_general_ci utf8_swedish_ci utf8    232     FALSE   TRUE    8
 
49
utf8_general_ci utf8_turkish_ci utf8    233     FALSE   TRUE    8
 
50
utf8_general_ci utf8_unicode_ci utf8    224     FALSE   TRUE    8
 
51
CREATE SCHEMA drizzleslap;
 
52
DROP SCHEMA drizzleslap;
 
53
DROP SCHEMA data_dictionary;