[TAJO-1101] Broadcast join with a zero-length file table returns wrong result data.

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Assignee: Hyoungjun Kim
• Reporter: Hyoungjun Kim
• Created: 07/Oct/14 08:55
• Updated: 15/Oct/14 09:35
• Resolved: 08/Oct/14 14:17

Description

If a table has several data files and some files are empty, Broadcast join with that table returns wrong data.

select * from customer_large a
 left outer join nation_multifile b on a.c_nationkey = b.n_nationkey
 where b.n_nationkey is null

The above query should return empty rows but return many rows with null n_nationkey value.

Issue Links

• relates to: TAJO-1075 unexpected join output from input of consecutive query results including 0-size tuple segment