[jira] [Created] (DRILL-6121) Nan/Inf data types: strange query result with INNER JOIN operator when selecting 1 column

["Alexander Malashevsky (JIRA)" <ji...@apache.org>]

Alexander Malashevsky created DRILL-6121:
--------------------------------------------

             Summary: Nan/Inf data types: strange query result with INNER JOIN operator when selecting 1 column
                 Key: DRILL-6121
                 URL: https://issues.apache.org/jira/browse/DRILL-6121
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JSON
            Reporter: Alexander Malashevsky
            Assignee: Volodymyr Tkach
         Attachments: ObjsX.json

*AFFECTED_VERSION:* drill-1.13.0-SNAPSHOT

*AFFECTED_FUNCTIONALITY:* INNER JOIN

*ISSUE_DESCRIPTION:* There were added new Json data types in MD-2745/DRILL-5919: *NaN, Infinity, -Infinity*. 
During testing activities, it was detected a bit strange behavior of INNER JOIN operator - different query results in almost the same queries. 
*Query1* {code} select distinct t.name, tt.name from dfs.tmp.`ObjsX.json` t inner join dfs.tmp.`ObjsX.json` tt on t.attr4 = tt.attr4 {code}
*Query2* {code} select distinct t.name from dfs.tmp.`ObjsX.json` t inner join dfs.tmp.`ObjsX.json` tt on t.attr4 = tt.attr4 {code}

*Query1* differs from *Query2* by 1 columns only:
- In *Query1* - 2 columns are selected - t.name, tt.name
- In *Query2* - 1 column is selected - t.name

However *Query1*/*Query2* return completely different results:
- *Query1* returns
	{code}
	name         name0
	object2 	object2
	object2 	object3
	object2 	object4
	object3 	object2
	object3 	object3
	object3 	object4
	object4 	object2
	object4 	object3
	object4 	object4
	{code}
This result seems to be correct.

- *Query2* returns _*No result found*_, not expected:

	*EXPECTED_RESULT:*
	{code}
	name
	object2
	object3
	object4
	{code}
	
	*ACTUAL_RESULT*: {code}No result found{code}

*NB!:* the issue appears only if tables are _*JOINed by a column which contains newly-added data types (NaN, Infinity, -Infinity)*_. The issue is not reproducible is a user is JOINing tables by a column containing other data types



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)