[
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-43-58-460.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
>
>
> 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)
