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

[Van Halbert (JIRA)]

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

Van Halbert commented on TEIID-3116:
------------------------------------

I'm looking at the doc's:  https://docs.jboss.org/author/display/TEIID/Partial+Results+Mode
and there's nothing mentioned about having to  the database version in order for partial results behavior to work.

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