[CALCITE-373] NULL values in NOT IN sub-queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.1-incubating
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 14/Aug/14 23:14
• Updated: 18/Oct/14 22:36
• Resolved: 28/Aug/14 01:44

Description

Write a test to check that NOT IN evaluates to unknown, and therefore returns all rows, if the sub-query returns a null.

Fix if necessary. Also test composite keys.