Description
As reported by sheryljj:
(1) XMLQuery without parentheses:
RETURN = foo AND RETURN = bar AND baz = 'yes' OR baz = 'no'
Generates the following SQL query:
SELECT ... WHERE (baz = yes AND baz = 'no')
If AND has precedence, it is unclear what it means to "AND" "baz='yes'" with the RETURN values on the left.
If we assume that RETURN values are ignored, then (1) should be equivalent with (2) below.
(2) XMLQuery with parentheses:
RETURN = foo AND RETURN = bar AND (baz = 'yes' OR baz = 'no')
Generates the following SQL query:
SELECT ... WHERE (baz = yes OR baz = 'no')
The expected SQL query is:
SELECT ... WHERE (baz = 'yes' OR baz = 'no')