[FLINK-32043] SqlClient session unrecoverable once one wrong setting occurred

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.17.0, 1.18.0
• Component/s: Table SQL / Client
• Assignee: Shengkai Fang
• Reporter: lincoln lee
• Created: 10/May/23 08:33
• Updated: 25/May/23 11:51
• Resolved: 25/May/23 11:51

Description

In sql client, it can not work normally once one wrong setting occurred

// wrong setting here

Flink SQL> SET table.sql-dialect = flink;
[INFO] Execute statement succeed.

Flink SQL> select '' AS f1, a from t1;
[ERROR] Could not execute SQL statement. Reason:
java.lang.IllegalArgumentException: No enum constant org.apache.flink.table.api.SqlDialect.FLINK

Flink SQL> SET table.sql-dialect = default;
[ERROR] Could not execute SQL statement. Reason:
java.lang.IllegalArgumentException: No enum constant org.apache.flink.table.api.SqlDialect.FLINK

Flink SQL> RESET table.sql-dialect;
[ERROR] Could not execute SQL statement. Reason:
java.lang.IllegalArgumentException: No enum constant org.apache.flink.table.api.SqlDialect.FLINK

Flink SQL> RESET;
[ERROR] Could not execute SQL statement. Reason:
java.lang.IllegalArgumentException: No enum constant org.apache.flink.table.api.SqlDialect.FLINK 

Issue Links

• links to: Github Pull Request #22633