This result is incorrect, one row is missing
Explain plan for the wrong result:
If you turn off merge join, query returns correct result:
This test has been running and passing in regression test suite until framework was switched to a new code, where JSON parsing was replaced with jackson and for a brief period ( I believe Friday afternoon until now ) this suite was not executed.
We already have a merge join bug
DRILL-2010, but this one seems to be different (small data set) and feels like a recent regression.
For QA: test Functional/Passing/aggregation/sanity/q18.sql will be running with merge join disabled until this issue is fixed. Will need to remove alter session from this file.