[teiid-issues] [JBoss JIRA] (TEIID-2052) Add Problem/Resolution to query problem using the query plan

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-2052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-2052.
-----------------------------------
    Fix Version/s:     (was: 13.x)
       Resolution: Out of Date


The docs have been updated as to reading query plans.  There are also a lot of annotations on the debug log that state things like predicate blank can't be pushed.  As for a resolution though that is a little more difficult as generally if there is a compensation that can be taken we'll do so automatically.  Otherwise the only option is for the user to modify their sql, typically to use different predicates.

> Add Problem/Resolution to query problem using the query plan
> ------------------------------------------------------------
>
>                 Key: TEIID-2052
>                 URL: https://issues.redhat.com/browse/TEIID-2052
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Documentation
>    Affects Versions: 7.7.1
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>            Priority: Optional
>         Attachments: INClauseNotPushedDown.odt
>
>
> Adding content that could be used for query problem resolution.   The initial attachment does the following:
> -  states the query problem (i.e., not pushing down the "IN" clause)
> -  provides the query plan (and debug log) for the query being submitted
> -  provides recommendations for resolving the problem
> -  then indicates how this problem was resolved and what the resulting query plan / debug log
> The idea here is to continue to add other problem scenarios so that this information is really useful for resolving issues.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)