~drizzle-developers/debian/sid/drizzle/nightly

« back to all changes in this revision

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

  • Committer: Hudson Drizzle
  • Date: 2011-01-11 17:18:09 UTC
  • mfrom: (1273.1109.11 drizzle)
  • Revision ID: hudson@drizzle.org-20110111171809-ubsplmojxz37uu7i
* Non-maintainer upload.
* Merged from trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
 
2
CATALOG_NAME
 
3
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOG_CACHE WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
 
4
CATALOG_NAME
 
5
SELECT CREATE_CATALOG("foo");
 
6
CREATE_CATALOG("foo")
 
7
1
 
8
SELECT DROP_CATALOG("foo");
 
9
DROP_CATALOG("foo")
 
10
1
 
11
SELECT drop_catalog("local");
 
12
ERROR HY000: You can not drop the 'local' catalog.
 
13
SELECT drop_catalog("does_not_exist");
 
14
ERROR HY000: Catalog 'does_not_exist' does not exist.
 
15
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
 
16
CATALOG_NAME
 
17
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOG_CACHE WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
 
18
CATALOG_NAME