[jira] [Commented] (OODT-333) XMLPS query doesn't quote literal string

["Chris A. Mattmann (Commented) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OODT-333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13126770#comment-13126770 ] 

Chris A. Mattmann commented on OODT-333:
----------------------------------------

Guys, does it matter if you reformulate:

{noformat}
RETURN = foo AND RETURN = bar AND baz = 'yes' OR baz = 'no'
{noformat}

as

{noformat}
baz = 'yes' OR baz = 'no' AND RETURN = foo AND RETURN = bar 
{noformat}

?
                
> XMLPS query doesn't quote literal string
> ----------------------------------------
>
>                 Key: OODT-333
>                 URL: https://issues.apache.org/jira/browse/OODT-333
>             Project: OODT
>          Issue Type: Bug
>          Components: xmlps
>    Affects Versions: 0.4
>            Reporter: Ricky Nguyen
>            Priority: Minor
>             Fix For: 0.4
>
>
> 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')

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira