[FLINK-35663] Release Testing: FLIP-436: Introduce Catalog-related Syntax

• Type: Sub-task
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Affects Version/s: 1.20.0
• Component/s: Table SQL / API
• Assignee: Unassigned
• Reporter: Yubin Li
• Created: 21/Jun/24 01:40
• Updated: Yesterday 07:58

Description

This describes how to verify FLINK-34914 FLIP-436: Introduce Catalog-related Syntax.

The verification steps are as follows.

1. Start the sql client.

bin/sql-client.sh

2. Execute the following DDL statements.

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'); 

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.

show catalogs;

show create catalog c1;

describe catalog c1;

desc catalog extended c1;

show create catalog c2;

describe catalog c2;

desc catalog extended c2; 

Verify whether they are the same as the given results.

4. Execute the following DDL statements.

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''';

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.

show create catalog c1;

describe catalog c1;

desc catalog extended c1;

show create catalog c2;

describe catalog c2;

desc catalog extended c2;  

Verify whether they are the same as the given results.