Bohdan Kazydub created DRILL-6606:
-------------------------------------
Summary: Hash Join returns incorrect data types when joining
subqueries with limit 0
Key: DRILL-6606
URL: https://issues.apache.org/jira/browse/DRILL-6606
Project: Apache Drill
Issue Type: Task
Reporter: Bohdan Kazydub
PreparedStatement for query
{code:sql}
SELECT l.l_quantity, l.l_shipdate, o.o_custkey
FROM (SELECT * FROM cp.`tpch/lineitem.parquet` LIMIT 0) l
JOIN (SELECT * FROM cp.`tpch/orders.parquet` LIMIT 0) o
ON l.l_orderkey = o.o_orderkey
LIMIT 0
{code}
is created with wrong types (nullable INTEGER) for all selected columns, no
matter what their actual type is. This behavior reproduces with hash join only
and is very likely to be caused by DRILL-6027 as the query works fine before
this feature was implemented.
To reproduce the problem you can put the aforementioned query into
TestPreparedStatementProvider#joinOrderByQuery() test method.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
