[teiid-issues] [JBoss JIRA] (TEIID-4908) Access Pattern Messaging

[Steve Tran (JIRA)]

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

Steve Tran updated TEIID-4908:
------------------------------
    Description: 
When accessing a table that has an Access Pattern defined, the columns defined in the access pattern don't necessarily match the columns being exposed by the view.

I'm aliasing the output of the query with friendly column names, while the Access Pattern defines the access based on the real column names.  When the user sees the Access Pattern warning message, it can be confusing as to what columns they actually need to supply.

Here's a real error message.  In my view, I didn't define any of my columns with an underscore, I camel-cased everything.
{code}
<error xmlns="http://docs.oasis-open.org/odata/ns/metadata">
<code>TEIID30278</code>
<message>
TEIID30278 Group has an access pattern which has not been met: group(s) [TDSA.V_RPT_T_MER_ADDN]; access pattern(s) [Access Pattern: Unsatisfied [TDSA.V_RPT_T_MER_ADDN.MID_TAG] History [[TDSA.V_RPT_T_MER_ADDN.MID_TAG], [MID_TAG], [g0.midTag]], Access Pattern: Unsatisfied [TDSA.V_RPT_T_MER_ADDN.MID_GROUP] History [[TDSA.V_RPT_T_MER_ADDN.EXTERNAL_MID, TDSA.V_RPT_T_MER_ADDN.MID_GROUP], [MID_GROUP, EXTERNAL_MID], [g0.midGroup, g0.mid]]]
</message>
</error>
{code}


  was:
When accessing a table that has an Access Pattern defined, the columns defined in the access pattern don't necessarily match the columns being exposed by the view.

I'm aliasing the output of the query with friendly column names, while the Access Pattern defines the access based on the real column names.  When the user sees the Access Pattern warning message, it can be confusing as to what columns they actually need to supply.





> Access Pattern Messaging
> ------------------------
>
>                 Key: TEIID-4908
>                 URL: https://issues.jboss.org/browse/TEIID-4908
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.12.8.6_3
>         Environment: JDV 6.3.2
> Windows 7
>            Reporter: Steve Tran
>            Assignee: Steven Hawkins
>
> When accessing a table that has an Access Pattern defined, the columns defined in the access pattern don't necessarily match the columns being exposed by the view.
> I'm aliasing the output of the query with friendly column names, while the Access Pattern defines the access based on the real column names.  When the user sees the Access Pattern warning message, it can be confusing as to what columns they actually need to supply.
> Here's a real error message.  In my view, I didn't define any of my columns with an underscore, I camel-cased everything.
> {code}
> <error xmlns="http://docs.oasis-open.org/odata/ns/metadata">
> <code>TEIID30278</code>
> <message>
> TEIID30278 Group has an access pattern which has not been met: group(s) [TDSA.V_RPT_T_MER_ADDN]; access pattern(s) [Access Pattern: Unsatisfied [TDSA.V_RPT_T_MER_ADDN.MID_TAG] History [[TDSA.V_RPT_T_MER_ADDN.MID_TAG], [MID_TAG], [g0.midTag]], Access Pattern: Unsatisfied [TDSA.V_RPT_T_MER_ADDN.MID_GROUP] History [[TDSA.V_RPT_T_MER_ADDN.EXTERNAL_MID, TDSA.V_RPT_T_MER_ADDN.MID_GROUP], [MID_GROUP, EXTERNAL_MID], [g0.midGroup, g0.mid]]]
> </message>
> </error>
> {code}



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)