[FLINK-10172] Inconsistency in ExpressionParser and ExpressionDsl for order by asc/desc

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.3, 1.4.2, 1.5.3, 1.6.0, 1.7.0
• Fix Version/s: 1.3.3, 1.4.3, 1.5.4, 1.6.1, 1.7.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Rong Rong
• Reporter: Rong Rong
• Created: 19/Aug/18 21:39
• Updated: 19/Sep/19 19:18
• Resolved: 21/Nov/18 17:03

Description

The following expression throws an exception in parsing "id.asc" term.

Table allOrders = orderTable
        .select("id,order_date,amount,customer_id")
        .orderBy("id.asc");

while it is correctly parsed for Scala:

val allOrders:Table = orderTable
        .select('id, 'order_date, 'amount, 'customer_id)
        .orderBy('id.asc)

Anticipated some inconsistency between ExpressionParser and ExpressionDsl

Issue Links

• links to: GitHub Pull Request #6585