For the following expressions, the order of operations for arithmetic and logical operators is not respected, and instead is applied left to right:
SELECT 3+5*6 FROM range(1, 2) -> returns 48, should instead return 33SELECT * FROM T WHERE a > 0 or b > 0 AND c > 0 -> applies the AND operator to a > 0 or b > 0 and c > 0 instead of b > 0 and c > 0.
In both cases if parenthesis are added to the operators with the higher precedence , the result is correct.
For the following expressions, the order of operations for arithmetic and logical operators is not respected, and instead is applied left to right:
SELECT 3+5*6 FROM range(1, 2)-> returns 48, should instead return 33SELECT * FROM T WHERE a > 0 or b > 0 AND c > 0-> applies theANDoperator toa > 0 or b > 0andc > 0instead ofb > 0andc > 0.In both cases if parenthesis are added to the operators with the higher precedence , the result is correct.