[TAJO-388] limit clause does not work properly

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Planner/Optimizer
• Assignee: Hyunsik Choi
• Reporter: Jinho Kim
• Created: 06/Dec/13 05:24
• Updated: 06/Dec/13 23:50
• Resolved: 06/Dec/13 14:03

Description

The schema does not match.

Query: select l_returnflag from lineitem_100 limit 10
 
Distributed Query Plan

-------------------------------------------------------------------------------
Execution Block Graph (TERMINAL - eb_1386296972441_0012_000003)
-------------------------------------------------------------------------------
|-eb_1386296972441_0012_000003
   |-eb_1386296972441_0012_000002
      |-eb_1386296972441_0012_000001
-------------------------------------------------------------------------------

=======================================================
Block Id: eb_1386296972441_0012_000001 [LEAF]
=======================================================

[Outgoing]
[q_1386296972441_0012] 1 => 2 (type=HASH_PARTITION, key=, num=1)

Limit (10)
  "out schema: {lineitem_100.l_returnflag (TEXT(0))}
  "in schema: {lineitem_100.l_returnflag (TEXT(0))}
"Scan" : {"table":"lineitem_100", "target list": lineitem_100.l_returnflag (TEXT(0)),
  "out schema": {lineitem_100.l_returnflag (TEXT(0))}
  "in schema": {lineitem_100.l_orderkey (INT8(0)),lineitem_100.l_partkey (INT8(0)),lineitem_100.l_suppkey (INT8(0)),lineitem_100.l_linenumber (INT8(0)),lineitem_100.l_quantity (FLOAT8(0)),lineitem_100.l_extendedprice (FLOAT8(0)),lineitem_100.l_discount (FLOAT8(0)),lineitem_100.l_tax (FLOAT8(0)),lineitem_100.l_returnflag (TEXT(0)),lineitem_100.l_linestatus (TEXT(0)),lineitem_100.l_shipdate (TEXT(0)),lineitem_100.l_commitdate (TEXT(0)),lineitem_100.l_receiptdate (TEXT(0)),lineitem_100.l_shipinstruct (TEXT(0)),lineitem_100.l_shipmode (TEXT(0)),lineitem_100.l_comment (TEXT(0))}
=======================================================
Block Id: eb_1386296972441_0012_000002 [ROOT]
=======================================================

[Incoming]
[q_1386296972441_0012] 1 => 2 (type=HASH_PARTITION, key=, num=1)

[Outgoing]

"Projection": {"targets": ["lineitem_100.l_returnflag (TEXT(0))"],
  "out schema": {lineitem_100.l_returnflag (TEXT(0))},
  "in schema": {lineitem_100.l_returnflag (TEXT(0))}}
Limit (10)
  "out schema: {lineitem_100.l_returnflag (TEXT(0))}
  "in schema: {lineitem_100.l_returnflag (TEXT(0))}
"Scan" : {"table":"lineitem_100", "target list": lineitem_100.l_returnflag (TEXT(0)),
  "out schema": {lineitem_100.l_returnflag (TEXT(0))}
  "in schema": {lineitem_100.l_orderkey (INT8(0)),lineitem_100.l_partkey (INT8(0)),lineitem_100.l_suppkey (INT8(0)),lineitem_100.l_linenumber (INT8(0)),lineitem_100.l_quantity (FLOAT8(0)),lineitem_100.l_extendedprice (FLOAT8(0)),lineitem_100.l_discount (FLOAT8(0)),lineitem_100.l_tax (FLOAT8(0)),lineitem_100.l_returnflag (TEXT(0)),lineitem_100.l_linestatus (TEXT(0)),lineitem_100.l_shipdate (TEXT(0)),lineitem_100.l_commitdate (TEXT(0)),lineitem_100.l_receiptdate (TEXT(0)),lineitem_100.l_shipinstruct (TEXT(0)),lineitem_100.l_shipmode (TEXT(0)),lineitem_100.l_comment (TEXT(0))}
=======================================================
Block Id: eb_1386296972441_0012_000003 [TERMINAL]
=======================================================