Zhiyong Liu created DRILL-714:
---------------------------------
Summary: verification fails for self-join on varchar columns
Key: DRILL-714
URL: https://issues.apache.org/jira/browse/DRILL-714
Project: Apache Drill
Issue Type: Bug
Reporter: Zhiyong Liu
git.commit.id=e7a486d784c072458d44b7692ea0262da368f001
2014-05-13 11:26:56 INFO QuerySubmitter:89 - Submitting query:
select count(*)
from part p1, part p2
where p1.p_name = p2.p_name
and p1.p_mfgr = p2.p_mfgr
2014-05-13 11:27:02 INFO DrillTestBase:201 - Query submit end time: 2014/05/13
11:27:02.0002
2014-05-13 11:27:02 INFO DrillTestBase:202 - The execution time for the query:
6 seconds.
2014-05-13 11:27:02 INFO TestVerifier:203 - These rows are not expected:
2014-05-13 11:27:02 INFO TestVerifier:206 - 1998 : 1 time(s).
2014-05-13 11:27:02 INFO TestVerifier:213 - Total number of unexpected rows: 1
2014-05-13 11:27:02 INFO TestVerifier:217 - These rows are expected but are
not in result set:
2014-05-13 11:27:02 INFO TestVerifier:220 - 2000 : 1 time(s).
2014-05-13 11:27:02 INFO TestVerifier:227 - Total number of expected but
missing: 1
also, inconsistent resultset in split file tables.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
