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

Access Pattern Messaging ------------------------ Key: TEIID-4908 URL: https://issues.jboss.org/browse/TEIID-4908 Project: Teiid Issue Type: Enhancement 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}