[teiid-issues] [JBoss JIRA] Commented: (TEIID-493) Define a new modeling construct that can create a defaulted parameter.
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Thu Apr 16 11:20:35 EDT 2009
[ https://jira.jboss.org/jira/browse/TEIID-493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12462607#action_12462607 ]
Steven Hawkins commented on TEIID-493:
--------------------------------------
We currently have no concept of an access pattern with a default value. And only procedures invoked through named parameter syntax make use of default values. It seems more appropriate for salesforce to expose two tables rather than implying a default criteria value on a single unified table. The default criteria approach has a serious drawback in determining when the appropriate criteria has not been set - for example if the isDeleted column could be used in an non-pushdown function or predicate. In this case you would assume that the user intended for isDeleted to be false, but that was not the intent of the query.
> Define a new modeling construct that can create a defaulted parameter.
> ----------------------------------------------------------------------
>
> Key: TEIID-493
> URL: https://jira.jboss.org/jira/browse/TEIID-493
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: John Doyle
> Assignee: Steven Hawkins
> Priority: Minor
>
> I would like to be able to define on a physical model a defaulted parameter value for a column, much like an access pattern with a default value. At runtime the default value would be sent as a parameter if the user did not supply a value in the query.
> The use case that brought this to mind is the Salesforce connector. Each Salesforce object exposes a isDeleted column and since most uses of the connector do not want to see deleted objects, the user will have to know that they need to have isDeleted=false in the query. Having a 'defaulted access pattern' would allow us to encapsulate this SF API leakage better.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list