[
https://issues.apache.org/jira/browse/FLINK-35621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 https://issues.apache.org/jira/browse/FLINK-34914
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
