[STORM-2113] [Storm SQL] 'OR' and 'AND' operators cannot handle more than 2 operands

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: storm-sql
• Epic Link: Storm SQL - cover the page 'SQL Reference' on Calcite
• Assignee: Jungtaek Lim
• Reporter: Jungtaek Lim
• Created: 22/Sep/16 00:06
• Updated: 26/Sep/16 02:11
• Resolved: 26/Sep/16 02:11

Description

When we use 'IN' statement, Calcite is converting this statement of 'OR' with multiple arguments.

While testing I found current 'OR' implementation cannot handle more than 2 parameters, which effectively introduce a bug on 'IN' (and 'NOT IN').

It should be fixed to support 'IN' properly. Also need to consider applying 'short curcuit' on that.

Issue Links

• is superceded by: STORM-2125 Use Calcite's implementation of Rex Compiler
• links to: GitHub Pull Request #1707