[FLINK-35935] CREATE TABLE AS doesn't work with LIMIT

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.18.1
• Fix Version/s: 1.19.2, 1.20.1, 2.0-preview
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: xuyang
• Reporter: Xingcan Cui
• Created: 30/Jul/24 22:56
• Updated: 02/Sep/24 09:35
• Resolved: 15/Aug/24 11:24

Description

CREATE TABLE WITH (foo) AS (SELECT * FROM bar LIMIT 5)

The above statement throws "Caused by: java.lang.AssertionError: not a query: " exception.

A workaround is to wrap the query with CTE.

CREATE TABLE WITH (foo) AS (WITH R AS (SELECT * FROM bar LIMIT 5) SELECT * FROM R)

Issue Links

• links to: GitHub Pull Request #25185
• links to: GitHub Pull Request #25201
• links to: GitHub Pull Request #25202