[DRILL-715] verification fails for 2 join conditions on a compound primary key

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Unassigned
• Reporter: Zhiyong Liu
• Created: 13/May/14 18:32
• Updated: 31/Jul/14 06:33
• Resolved: 20/May/14 16:02

Description

2014-05-13 11:29:53 INFO QuerySubmitter:89 - Submitting query:
select count
from (select l.l_quantity
from lineitem l, partsupp ps
where l.l_partkey = ps.ps_partkey
and l.l_suppkey = ps.ps_suppkey) as foo
2014-05-13 11:30:08 INFO DrillTestBase:201 - Query submit end time: 2014/05/13 11:30:08.0008
2014-05-13 11:30:08 INFO DrillTestBase:202 - The execution time for the query: 14 seconds.
2014-05-13 11:30:08 INFO TestVerifier:203 - These rows are not expected:
2014-05-13 11:30:08 INFO TestVerifier:206 - 60164 : 1 time(s).
2014-05-13 11:30:08 INFO TestVerifier:213 - Total number of unexpected rows: 1
2014-05-13 11:30:08 INFO TestVerifier:217 - These rows are expected but are not in result set:
2014-05-13 11:30:08 INFO TestVerifier:220 - 60175 : 1 time(s).
2014-05-13 11:30:08 INFO TestVerifier:227 - Total number of expected but missing: 1

also, inconsistent resultset in split file tables.