[ https://issues.apache.org/jira/browse/FLINK-35663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yubin Li updated FLINK-35663: ----------------------------- Attachment: image-2024-06-21-09-44-26-213.png > Release Testing: FLIP-436: Introduce Catalog-related Syntax > ----------------------------------------------------------- > > Key: FLINK-35663 > URL: https://issues.apache.org/jira/browse/FLINK-35663 > Project: Flink > Issue Type: Sub-task > Components: Table SQL / API > Affects Versions: 1.20.0 > Reporter: Yubin Li > Priority: Major > Attachments: image-2024-06-21-09-43-47-391.png, > image-2024-06-21-09-43-58-460.png, image-2024-06-21-09-44-26-213.png > > > This describes how to verify FLINK-34914 FLIP-436: Introduce Catalog-related > Syntax. > The verification steps are as follows. > h3. 1. Start the sql client. > bin/sql-client.sh > h3. 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.` > h3. 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=768,height=902! > h3. 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`. > h3. 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=712,height=713! -- This message was sent by Atlassian Jira (v8.20.10#820010)