You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@oodt.apache.org by "Ricky Nguyen (Updated) (JIRA)" <ji...@apache.org> on 2011/10/13 20:41:11 UTC
[jira] [Updated] (OODT-333) XMLPS query doesn't quote literal
string
[ https://issues.apache.org/jira/browse/OODT-333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ricky Nguyen updated OODT-333:
------------------------------
Description:
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}
was:
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')
> 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:
> {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