You don't explicitly create parenthesis. You just need to construct the conditions in the right order. Just construct the two parts of your OR separately and then create a new RexCall node with the OR operator where you pass in each of the two RexNodes you want to compare. -- Michael Mior [email protected]
Le jeu. 14 mars 2019 à 07:56, Rakesh Nair <[email protected]> a écrit : > > Hello, > Would you mind giving me some pointers on *creating parenthesis while > building a RelNode*. > For example, how to build RelNode for the sample query: > SELECT * FROM `persons` WHERE *(*`SALARY` >= 10 AND `SALARY` < 20*) *OR > *(*`SALARY` >= 30 AND `SALARY` < 40*)* > > P.S. Need to know how to build the parenthesis only, everything else is > fine.. > -- > Thanks & Regards, > Rakesh
