[FLINK-6941] Selecting window start / end on over window causes field not resolve exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.0
• Fix Version/s: 1.3.1, 1.4.0
• Component/s: Table SQL / API
• Assignee: sunjincheng
• Reporter: sunjincheng
• Created: 18/Jun/17 23:10
• Updated: 19/Jun/17 22:20
• Resolved: 19/Jun/17 22:20

Description

Selecting window start / end on over window causes field not resolve exception.
The following program:

table
      .window(
        Over partitionBy 'c orderBy 'proctime preceding UNBOUNDED_ROW as 'w)
      .select('c, countFun('b) over 'w, 'w.start, 'w.end)

causes

org.apache.flink.table.api.ValidationException: Cannot resolve [w] given input [a, b, c, proctime].

	at org.apache.flink.table.plan.logical.LogicalNode.failValidation(LogicalNode.scala:143)
	at org.apache.flink.table.plan.logical.LogicalNode$$anonfun$validate$1.applyOrElse(LogicalNode.scala:86)
	at org.apache.flink.table.plan.logical.LogicalNode$$anonfun$validate$1.applyOrElse(LogicalNode.scala:83)
	at org.apache.flink.table.plan.TreeNode.postOrderTransform(TreeNode.scala:72)
	at org.apache.flink.table.plan.TreeNode$$anonfun$1.apply(TreeNode.scala:46)
	at scala.collection.Iterator$$anon$11.next(Iterator.scala:328)
	at scala.collection.Iterator$class.foreach(Iterator.scala:727)
	at scala.collection.AbstractIterator.foreach(Iterator.scala:1157)
	at scala.collection.generic.Growable$class.$plus$plus$eq(Growable.scala:48)

We should validate that the start and end window properties are not accessed on over windows.

Issue Links

• links to: GitHub Pull Request #4137