[teiid-issues] [JBoss JIRA] (TEIID-3116) Teiid Partial Results Mode: unavailability of datasource causes error (which is not masked)

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12999382#comment-12999382 ] 

Steven Hawkins commented on TEIID-3116:
---------------------------------------

That's because the features were not directly connected, but of course can be updated to include a note.  

Unfortunately given the lack of specificity in how partial results operates you can get different partial results depending upon the capabilities as it can make a difference how much of the query is pushed to the source.

> Teiid Partial Results Mode: unavailability of datasource causes error (which is not masked)
> -------------------------------------------------------------------------------------------
>
>                 Key: TEIID-3116
>                 URL: https://issues.jboss.org/browse/TEIID-3116
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 8.7.1
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>            Priority: Critical
>
> Description of problem:
> Querying a vdb-table which is formed as union of two tables from different datasources. Even though "set partialresultsmode true" is run as initial query, instead of retreiving 0 rows from a datasources that is down, exception is promoted.
> Version-Release number of selected component (if applicable):
> DV 6.1 ER1
> How reproducible:
> Every time
> Steps to Reproduce:
> 1. Define one valid and one invalid datasource(invalid connection-url).
> 2. Create vdb which maps tables from both datasources.
> 3. Set partialresultsmode to true
> 4. Execute query on the given vdb-table
> Actual results:
> TeiidSQLException
> TEIID30498 Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for ORBQT were not avaialable.  The command could not be planned properly.
> Expected results:
> 0 rows from invalid datasource.



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)