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

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

     [ https://issues.apache.org/jira/browse/OODT-333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris A. Mattmann reassigned OODT-333:
--------------------------------------

    Assignee: Chris A. Mattmann
    
> 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
>            Assignee: Chris A. Mattmann
>            Priority: Minor
>             Fix For: 0.4
>
>         Attachments: rickdn-oodt-333.patch
>
>
> As reported by sheryljj:
> (1) XMLQuery without parentheses:
> {code}
> RETURN = foo AND RETURN = bar AND baz = 'yes' OR baz = 'no'
> {code}
> Generates the following SQL query:
> {code}
> SELECT ... WHERE (baz = yes AND baz = 'no')
> {code}
> 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:
> {code}
> RETURN = foo AND RETURN = bar AND (baz = 'yes' OR baz = 'no')
> {code}
> Generates the following SQL query:
> {code}
> SELECT ... WHERE (baz = yes OR baz = 'no')
> {code}
> The expected SQL query is:
> {code}
> SELECT ... WHERE (baz = 'yes' OR baz = 'no')
> {code}

--
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