[ https://issues.apache.org/jira/browse/FLINK-35621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17855267#comment-17855267 ]
Yubin Li commented on FLINK-35621: ---------------------------------- This describes how to verify FLINK-34914 FLIP-436: Introduce Catalog-related Syntax. The verification steps are as follows. 1. Start the standalone session cluster and sql client. 2. Execute the following DDL statements. {code:java} 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'); {code} 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. {code:java} show catalogs; show create catalog c1; describe catalog c1; desc catalog extended c1; show create catalog c2; describe catalog c2; desc catalog extended c2; {code} Verify whether they are the same as the given results. !image-2024-06-16-09-30-16-983.png|width=671,height=788! 4. Execute the following DDL statements. {code:java} 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''';{code} 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. {code:java} show create catalog c1; describe catalog c1; desc catalog extended c1; show create catalog c2; describe catalog c2; desc catalog extended c2; {code} Verify whether they are the same as the given results. !image-2024-06-16-09-47-27-956.png|width=679,height=680! > Release Testing Instructions: Verify FLIP-436: Introduce Catalog-related > Syntax > ------------------------------------------------------------------------------- > > Key: FLINK-35621 > URL: https://issues.apache.org/jira/browse/FLINK-35621 > Project: Flink > Issue Type: Sub-task > Components: Table SQL / API > Reporter: Weijie Guo > Assignee: Yubin Li > Priority: Blocker > Labels: release-testing > Fix For: 1.20.0 > > Attachments: image-2024-06-16-09-30-16-983.png, > image-2024-06-16-09-40-05-959.png, image-2024-06-16-09-47-27-956.png > > > Follow up the test for https://issues.apache.org/jira/browse/FLINK-34914 -- This message was sent by Atlassian Jira (v8.20.10#820010)