[jira] [Comment Edited] (FLINK-35621) Release Testing Instructions: Verify FLIP-436: Introduce Catalog-related Syntax
[ https://issues.apache.org/jira/browse/FLINK-35621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855267#comment-17855267 ] Yubin Li edited comment on FLINK-35621 at 6/16/24 1:53 AM: --- 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=671,height=788! 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=679,height=680! was (Author: liyubin117): 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=671,height=788! 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=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
[jira] [Comment Edited] (FLINK-35621) Release Testing Instructions: Verify FLIP-436: Introduce Catalog-related Syntax
[ https://issues.apache.org/jira/browse/FLINK-35621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855267#comment-17855267 ] Yubin Li edited comment on FLINK-35621 at 6/16/24 1:51 AM: --- 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=671,height=788! 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=679,height=680! was (Author: liyubin117): 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