[DRILL-4495] IN operator does not work

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.6.0
• Component/s: SQL Parser
• Assignee: Unassigned
• Reporter: Stefán Baxter
• Created: 10/Mar/16 08:59
• Updated: 14/Mar/16 22:41
• Resolved: 14/Mar/16 22:41

Description

I noticed that using the IN operator with a sub structure has stopped working:

select s.client_ip.ip from dfs.asa.`/processed/venuepoint/transactions` as s where s.client_ip.ip in ("unknown") limit 2;
Error: PARSE ERROR: Encountered "\"" at line 1, column 103.
Was expecting one of:
...
SQL Query select s.client_ip.ip from dfs.asa.`/processed/venuepoint/transactions` as s where s.client_ip.ip in ("2.69.200.113","unknown") limit 2
^
(the hat should point at the _ip part of the where clause)

I will report this in Jira and mark it as a blocker.

The IN works with nothing here using the latest 1.6-SNAPSHOT