1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOG_CACHE WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
SELECT CREATE_CATALOG("foo");
SELECT DROP_CATALOG("foo");
--error ER_CATALOG_NO_DROP_LOCAL
SELECT drop_catalog("local");
--error ER_CATALOG_DOES_NOT_EXIST
SELECT drop_catalog("does_not_exist");
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOGS WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
SELECT CATALOG_NAME FROM DATA_DICTIONARY.CATALOG_CACHE WHERE CATALOG_NAME != "local" ORDER BY CATALOG_NAME;
|