~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

• browse files at revision 2073
• compare with another revision
• download diff
• download tarball
• view history from revision 2073

Show diffs side-by-side

added

removed

plugin/catalog/tests/r/drop.result

 

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

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1