Details
-
Sub-task
-
Status: Closed
-
Blocker
-
Resolution: Done
-
1.20.0
Description
This describes how to verify FLINK-34914 FLIP-436: Introduce Catalog-related Syntax.
The verification steps are as follows.
1. Start the sql client.
bin/sql-client.sh
2. Execute the following DDL statements.
create catalog c1 comment 'comment for ''c1''' with ('type'='generic_in_memory', 'default-database'='db1'); create catalog if not exists c1 comment 'new' with ('type'='generic_in_memory'); create catalog if not exists c2 with ('type'='generic_in_memory'); create catalog c2 with ('type'='generic_in_memory', 'default-database'='db2');
Verify whether only the last statement is supposed to throw an exception and messages such as `Catalog c2 already exists.`
3. Execute the following statements.
show catalogs; show create catalog c1; describe catalog c1; desc catalog extended c1; show create catalog c2; describe catalog c2; desc catalog extended c2;
Verify whether they are the same as the given results.
4. Execute the following DDL statements.
alter catalog c1 reset ('default-database'); alter catalog c1 comment ''; alter catalog c2 set ('default-database'='db2'); alter catalog c2 reset ('type'); alter catalog c2 reset (); alter catalog c2 comment 'hello catalog ''c2''';
Verify whether the forth statement is supposed to throw an exception and messages such as `ALTER CATALOG RESET does not support changing 'type'`.
Verify whether the fifth statement is supposed to throw an exception and messages such as `ALTER CATALOG RESET does not support empty key`.
5. Execute the following statements.
show create catalog c1; describe catalog c1; desc catalog extended c1; show create catalog c2; describe catalog c2; desc catalog extended c2;
Verify whether they are the same as the given results.