[FLINK-20734] SQL client error when running joining query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 1.12.0
• Component/s: Table SQL / Client
• Labels: stale-major
• Assignee: Unassigned
• Reporter: owr
• Created: 23/Dec/20 01:56
• Updated: 29/Apr/21 08:07
• Resolved: 29/Apr/21 08:07

Description

Run into the following errors when performing join query in SQL client.

01:52:46.189 [main] ERROR org.apache.flink.table.client.SqlClient - SQL Client must stop. Unexpected exception. This is a bug. Please consider filing an issue.01:52:46.189 [main] ERROR org.apache.flink.table.client.SqlClient - SQL Client must stop. Unexpected exception. This is a bug. Please consider filing an issue.java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.rangeCheck(ArrayList.java:659) ~[?:1.8.0_272] at java.util.ArrayList.get(ArrayList.java:435) ~[?:1.8.0_272] at org.apache.flink.table.client.cli.CliResultView.openRow(CliResultView.java:149) ~[flink-sql-client_2.11-1.12.0.jar:1.12.0] at org.apache.flink.table.client.cli.CliTableResultView.evaluate(CliTableResultView.java:154) ~[flink-sql-client_2.11-1.12.0.jar:1.12.0] at org.apache.flink.table.client.cli.CliTableResultView.evaluate(CliTableResultView.java:52) ~[flink-sql-client_2.11-1.12.0.jar:1.12.0] at org.apache.flink.table.client.cli.CliView.open(CliView.java:125) ~[flink-sql-client_2.11-1.12.0.jar:1.12.0] at org.apache.flink.table.client.cli.CliClient.callSelect(CliClient.java:661) ~[flink-sql-client_2.11-1.12.0.jar:1.12.0] at org.apache.flink.table.client.cli.CliClient.callCommand(CliClient.java:324) ~[flink-sql-client_2.11-1.12.0.jar:1.12.0] at java.util.Optional.ifPresent(Optional.java:159) ~[?:1.8.0_272] at org.apache.flink.table.client.cli.CliClient.open(CliClient.java:216) ~[flink-sql-client_2.11-1.12.0.jar:1.12.0] at org.apache.flink.table.client.SqlClient.openCli(SqlClient.java:141) ~[flink-sql-client_2.11-1.12.0.jar:1.12.0] at org.apache.flink.table.client.SqlClient.start(SqlClient.java:114) ~[flink-sql-client_2.11-1.12.0.jar:1.12.0] at org.apache.flink.table.client.SqlClient.main(SqlClient.java:196) [flink-sql-client_2.11-1.12.0.jar:1.12.0]Exception in thread "main" org.apache.flink.table.client.SqlClientException: Unexpected exception. This is a bug. Please consider filing an issue. at org.apache.flink.table.client.SqlClient.main(SqlClient.java:208)Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.rangeCheck(ArrayList.java:659) at java.util.ArrayList.get(ArrayList.java:435) at org.apache.flink.table.client.cli.CliResultView.openRow(CliResultView.java:149) at org.apache.flink.table.client.cli.CliTableResultView.evaluate(CliTableResultView.java:154) at org.apache.flink.table.client.cli.CliTableResultView.evaluate(CliTableResultView.java:52) at org.apache.flink.table.client.cli.CliView.open(CliView.java:125) at org.apache.flink.table.client.cli.CliClient.callSelect(CliClient.java:661) at org.apache.flink.table.client.cli.CliClient.callCommand(CliClient.java:324) at java.util.Optional.ifPresent(Optional.java:159) at org.apache.flink.table.client.cli.CliClient.open(CliClient.java:216) at org.apache.flink.table.client.SqlClient.openCli(SqlClient.java:141) at org.apache.flink.table.client.SqlClient.start(SqlClient.java:114) at org.apache.flink.table.client.SqlClient.main(SqlClient.java:196)