← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to plugin/information_schema_dictionary/tests/r/schemata.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-12-21 16:39:40 UTC
  • mfrom: (1.2.4 upstream)
  • Revision ID: james.westby@ubuntu.com-20101221163940-c1pfo1jjvx7909xq
Tags: 2010.12.06-0ubuntu1
* New upstream release.
* Added libaio-dev build depend for InnoDB.
* Removed libpcre patch - applied upstream.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/information_schema_dictionary/tests/r/schemata.result
1
1
select * from INFORMATION_SCHEMA.SCHEMATA;
2
2
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
3
 
        data_dictionary                         
4
 
        information_schema                              
5
 
        mysql                           
6
 
        test                            
 
3
        data_dictionary NULL    NULL    NULL    NULL
 
4
        information_schema      NULL    NULL    NULL    NULL
 
5
        mysql   NULL    NULL    NULL    NULL
 
6
        test    NULL    NULL    NULL    NULL
7
7
use information_schema;
8
8
show schemas;
9
9
Database
13
13
test
14
14
select * from INFORMATION_SCHEMA.SCHEMATA;
15
15
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
16
 
        data_dictionary                         
17
 
        information_schema                              
18
 
        mysql                           
19
 
        test                            
 
16
        data_dictionary NULL    NULL    NULL    NULL
 
17
        information_schema      NULL    NULL    NULL    NULL
 
18
        mysql   NULL    NULL    NULL    NULL
 
19
        test    NULL    NULL    NULL    NULL
20
20
select * from INFORMATION_SCHEMA.SCHEMATA WHERE CATALOG_NAME=NULL;
21
21
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
22
22
select * from INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_OWNER=NULL;
29
29
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
30
30
select * from INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME="data_dictionary";
31
31
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
32
 
        data_dictionary                         
 
32
        data_dictionary NULL    NULL    NULL    NULL
33
33
select * from INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME="information_schema";
34
34
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
35
 
        information_schema                              
 
35
        information_schema      NULL    NULL    NULL    NULL
36
36
select * from INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
37
37
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
38
 
        data_dictionary                         
39
 
        information_schema                              
40
 
        mysql                           
41
 
        test                            
 
38
        data_dictionary NULL    NULL    NULL    NULL
 
39
        information_schema      NULL    NULL    NULL    NULL
 
40
        mysql   NULL    NULL    NULL    NULL
 
41
        test    NULL    NULL    NULL    NULL
42
42
select * from INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME,CATALOG_NAME;
43
43
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
44
 
        data_dictionary                         
45
 
        information_schema                              
46
 
        mysql                           
47
 
        test                            
 
44
        data_dictionary NULL    NULL    NULL    NULL
 
45
        information_schema      NULL    NULL    NULL    NULL
 
46
        mysql   NULL    NULL    NULL    NULL
 
47
        test    NULL    NULL    NULL    NULL
48
48
select * from INFORMATION_SCHEMA.SCHEMATA ORDER BY CATALOG_NAME,SCHEMA_NAME;
49
49
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
50
 
        data_dictionary                         
51
 
        information_schema                              
52
 
        mysql                           
53
 
        test                            
 
50
        data_dictionary NULL    NULL    NULL    NULL
 
51
        information_schema      NULL    NULL    NULL    NULL
 
52
        mysql   NULL    NULL    NULL    NULL
 
53
        test    NULL    NULL    NULL    NULL
54
54
create schema a;
55
55
create schema b;
56
56
create schema c;
59
59
create schema aa;
60
60
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME="a";
61
61
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
62
 
        a                               
 
62
        a       NULL    NULL    NULL    NULL
63
63
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME like "a%";
64
64
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
65
 
        a                               
66
 
        aa                              
 
65
        a       NULL    NULL    NULL    NULL
 
66
        aa      NULL    NULL    NULL    NULL
67
67
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME like "%a";
68
68
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
69
 
        a                               
70
 
        aa                              
71
 
        information_schema                              
 
69
        a       NULL    NULL    NULL    NULL
 
70
        aa      NULL    NULL    NULL    NULL
 
71
        information_schema      NULL    NULL    NULL    NULL
72
72
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME like "%s";
73
73
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
74
 
        ds                              
 
74
        ds      NULL    NULL    NULL    NULL
75
75
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;
76
76
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
77
 
        a                               
78
 
        aa                              
79
 
        b                               
80
 
        c                               
81
 
        d                               
82
 
        data_dictionary                         
83
 
        ds                              
84
 
        information_schema                              
85
 
        mysql                           
86
 
        test                            
 
77
        a       NULL    NULL    NULL    NULL
 
78
        aa      NULL    NULL    NULL    NULL
 
79
        b       NULL    NULL    NULL    NULL
 
80
        c       NULL    NULL    NULL    NULL
 
81
        d       NULL    NULL    NULL    NULL
 
82
        data_dictionary NULL    NULL    NULL    NULL
 
83
        ds      NULL    NULL    NULL    NULL
 
84
        information_schema      NULL    NULL    NULL    NULL
 
85
        mysql   NULL    NULL    NULL    NULL
 
86
        test    NULL    NULL    NULL    NULL
87
87
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
88
88
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
89
 
        a                               
90
 
        aa                              
91
 
        b                               
92
 
        c                               
93
 
        d                               
94
 
        data_dictionary                         
95
 
        ds                              
96
 
        information_schema                              
97
 
        mysql                           
98
 
        test                            
 
89
        a       NULL    NULL    NULL    NULL
 
90
        aa      NULL    NULL    NULL    NULL
 
91
        b       NULL    NULL    NULL    NULL
 
92
        c       NULL    NULL    NULL    NULL
 
93
        d       NULL    NULL    NULL    NULL
 
94
        data_dictionary NULL    NULL    NULL    NULL
 
95
        ds      NULL    NULL    NULL    NULL
 
96
        information_schema      NULL    NULL    NULL    NULL
 
97
        mysql   NULL    NULL    NULL    NULL
 
98
        test    NULL    NULL    NULL    NULL
99
99
drop schema a;
100
100
drop schema b;
101
101
drop schema c;