~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/catalog/tests/r/create.result

  • Committer: Brian Aker
  • Date: 2011-01-11 07:12:09 UTC
  • mfrom: (2068.5.6 catalogs)
  • Revision ID: brian@gir-3-20110111071209-ntbex8btgayoq00v
MergeĀ inĀ catalogs.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
SELECT CREATE_CATALOG("foo");
 
2
CREATE_CATALOG("foo")
 
3
1
 
4
SELECT DROP_CATALOG("foo");
 
5
DROP_CATALOG("foo")
 
6
1
 
7
SELECT CREATE_CATALOG("foo1");
 
8
CREATE_CATALOG("foo1")
 
9
1
 
10
SELECT CREATE_CATALOG("foo2");
 
11
CREATE_CATALOG("foo2")
 
12
1
 
13
SELECT CREATE_CATALOG("foo3");
 
14
CREATE_CATALOG("foo3")
 
15
1
 
16
SELECT CREATE_CATALOG("foo4");
 
17
CREATE_CATALOG("foo4")
 
18
1
 
19
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS ORDER BY CATALOG_NAME;
 
20
CATALOG_NAME
 
21
foo1
 
22
foo2
 
23
foo3
 
24
foo4
 
25
LOCAL
 
26
SELECT DROP_CATALOG("foo1");
 
27
DROP_CATALOG("foo1")
 
28
1
 
29
SELECT DROP_CATALOG("foo2");
 
30
DROP_CATALOG("foo2")
 
31
1
 
32
SELECT DROP_CATALOG("foo3");
 
33
DROP_CATALOG("foo3")
 
34
1
 
35
SELECT DROP_CATALOG("foo4");
 
36
DROP_CATALOG("foo4")
 
37
1
 
38
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
 
39
CATALOG_NAME
 
40
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOG_CACHE WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
 
41
CATALOG_NAME