[TAJO-418] sort operator after Inline views consisting of unions can cause an incorrect distributed plan

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: distributed query plan
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 15/Dec/13 16:19
• Updated: 16/Dec/13 17:54
• Resolved: 16/Dec/13 17:47

Description

See the title. The following query is an example of this bug.

SELECT
  l_returnflag,
  l_linestatus

FROM (
  SELECT
    *
  FROM
    lineitem
  WHERE
    l_returnflag = 'O'

  UNION ALL

  SELECT
    *
  FROM
    lineitem
  WHERE
    l_returnflag = 'R'
) T

GROUP BY
  l_returnflag,
  l_linestatus

ORDER BY
  l_returnflag,
  l_linestatus

This patch adds an unit test to reproduce this case and includes the bug fix.