[CALCITE-5790] Query with "*" but no FROM clause should be invalid

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 20/Jun/23 21:05
• Updated: 27/Jul/23 10:22
• Resolved: 21/Jun/23 01:00

Description

The query

SELECT *

(which has a "*" indicating "all columns of all source tables" but no FROM clause to define source tables) should be invalid.

The validator should throw "SELECT * requires a FROM clause".