drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-714) verification fails for self-join on varchar columns
Date Tue, 20 May 2014 16:02:45 GMT

     [ https://issues.apache.org/jira/browse/DRILL-714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau resolved DRILL-714.
----------------------------------

    Resolution: Fixed

> 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)

Mime
View raw message