Yubin Li created FLINK-35663:
--------------------------------
Summary: 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
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!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
