[JBoss JIRA] Created: (TEIID-1322) Stored procedures are not pre-evaluating scalar subquery arguments.
12:55 p.m.
Stored procedures are not pre-evaluating scalar subquery arguments.
-------------------------------------------------------------------
Key: TEIID-1322
URL: https://jira.jboss.org/browse/TEIID-1322
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.1.1
Our current code is not pre-evaluating scalar subqueries used as arguments to stored
procedures. This should have started working in 6.x.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:14 a.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1322) Stored procedures are not pre-evaluating scalar subquery arguments.
[
https://jira.jboss.org/browse/TEIID-1322?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins resolved TEIID-1322.
-----------------------------------
Resolution: Done
This is really a broader problem that hasn't gotten much attention. I expanded this
fix to also validate that subqueries are not used in virtual update procedure criteria
(since it is non-translatable). And to prevent pushdown non-query commands from having
non-pushdown constructs (which could fail in unpredictable ways with alias generation or
translation) - but that if a scalar subquery can be pre-evaluated it will be.
Stored procedures are not pre-evaluating scalar subquery arguments.
-------------------------------------------------------------------
Key: TEIID-1322
URL: https://jira.jboss.org/browse/TEIID-1322
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.1.1
Our current code is not pre-evaluating scalar subqueries used as arguments to stored
procedures. This should have started working in 6.x.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:37 p.m.
New subject: [JBoss JIRA] Closed: (TEIID-1322) Stored procedures are not pre-evaluating scalar subquery arguments.
[
https://jira.jboss.org/browse/TEIID-1322?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins closed TEIID-1322.
---------------------------------
Stored procedures are not pre-evaluating scalar subquery arguments.
-------------------------------------------------------------------
Key: TEIID-1322
URL: https://jira.jboss.org/browse/TEIID-1322
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.1.1
Our current code is not pre-evaluating scalar subqueries used as arguments to stored
procedures. This should have started working in 6.x.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5191
days inactive
5202
days old
2 comments
1 participants
participants (1)
-
Steven Hawkins (JIRA)