[
https://issues.apache.org/jira/browse/OODT-546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13537533#comment-13537533
]
Chris A. Mattmann commented on OODT-546:
----------------------------------------
One thing that this did bring up though is that the default example of the
xmlps config checked in is misleading in that the first <table... identified
under the <tables> block is named the same name "Table1" as the default table.
I'll commit an update to the examples to address this.
Longer term, it might also make sense to introduce in some protection on the
method #getRequiredTables to make sure that it doesn't add required tables that
are defined as the default table.
> XMLPS inner-joins default table with itself
> -------------------------------------------
>
> Key: OODT-546
> URL: https://issues.apache.org/jira/browse/OODT-546
> Project: OODT
> Issue Type: Bug
> Components: xmlps
> Affects Versions: 0.5
> Reporter: Michael Joyce
> Fix For: 0.6
>
> Attachments: dump.sql, ps.xml
>
>
> When the default table is set to an existing table name, XMLPS tries to inner
> join the default table with itself, resulting in a failed query.
> Example
> With the following ps.xml file
> {code:xml}
> <oodt:xmlps xmlns:oodt="http://incubator.apache.org/oodt/0.1-incubating";
> name="CERC Query Handler" id="EDRN.CERC.CancerData">
> <!--<tables default="Table1">-->
> <tables default="Cancer_Data">
> <table name="Cancer_Data" join="STUDY_PARTICIPANT_ID_SITE_TEXT"
> tofld="STUDY_PARTICIPANT_ID_SITE_TEXT"/>
> </tables>
> <field type="dynamic" name="STUDY_PARTICIPANT_ID"
> dbname="STUDY_PARTICIPANT_ID_SITE_TEXT" />
>
> <field type="constant" name="BASELINE_CANCER-CONFIRMATION_CODE" value="1"/>
> </oodt:xmlps>
> {code}
> A query to
> {noformat}
> http://localhost:8080/web-grid/prod?q=RETURN%3DSTUDY_PARTICIPANT_ID
> {noformat}
> Results in the following:
> {noformat}
> WARNING: Error executing sql: [SELECT
> Cancer_Data.STUDY_PARTICIPANT_ID_SITE_TEXT as STUDY_PARTICIPANT_ID FROM
> Cancer_Data INNER JOIN Cancer_Data ON
> Cancer_Data.STUDY_PARTICIPANT_ID_SITE_TEXT =
> Cancer_Data.STUDY_PARTICIPANT_ID_SITE_TEXT ]: Message: Not unique
> table/alias: 'Cancer_Data'
> {noformat}
> If the default table is changed to "Participant_Data" then the query
> functions fine.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
