Affects Version/s: None
Fix Version/s: None
Component/s: Storage - JSON
AFFECTED_FUNCTIONALITY: INNER JOIN
ISSUE_DESCRIPTION: There were added new Json data types in
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 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
This result seems to be correct.
- Query2 returns No result found, not expected:
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