With SQLParser 5.3, parsing:
SELECT * FROM record WHERE status IN ('CONFIRMED') AND start_datetime >= CURRENT_TIMESTAMP
The PlainSelect.getWhere() return an InExpression having a RightExpression of type AndExpression
In this case, the PlainSelect.getWhere() should return an AndExpression having a LeftExpression of type InExpression
With SQLParser 5.3, parsing:
SELECT * FROM record WHERE status IN ('CONFIRMED') AND start_datetime >= CURRENT_TIMESTAMPThe PlainSelect.getWhere() return an InExpression having a RightExpression of type AndExpression
In this case, the PlainSelect.getWhere() should return an AndExpression having a LeftExpression of type InExpression