[JBoss JIRA] Created: (TEIID-904) Error executing the Procedural releational query with out a where clause
4:05 p.m.
Error executing the Procedural releational query with out a where clause
------------------------------------------------------------------------
Key: TEIID-904
URL: https://jira.jboss.org/jira/browse/TEIID-904
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 6.2.0
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Fix For: 7.0
I have virtual stored procedure called "p1" which has no input parameters. When
I execute this procedure either via
select * from p1;
or
exec p1();
in both cases it fails with error
Group has an access pattern which has not been met: group(s) [vm.p1]; access pattern(s)
[Access Pattern: Unsatisfied [] History [[]]]
Procedures with no input parameters should not be tested for Access patterns.
--
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
4:15 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-904) Error executing the Procedural releational query with out a where clause
[
https://jira.jboss.org/jira/browse/TEIID-904?page=com.atlassian.jira.plug...
]
Ramesh Reddy updated TEIID-904:
-------------------------------
Description:
I have virtual stored procedure called "p1" which has no input parameters. When
I execute this procedure either via
select * from p1;
in both cases it fails with error
Group has an access pattern which has not been met: group(s) [vm.p1]; access pattern(s)
[Access Pattern: Unsatisfied [] History [[]]]
Procedures with no input parameters should not be tested for Access patterns.
was:
I have virtual stored procedure called "p1" which has no input parameters. When
I execute this procedure either via
select * from p1;
or
exec p1();
in both cases it fails with error
Group has an access pattern which has not been met: group(s) [vm.p1]; access pattern(s)
[Access Pattern: Unsatisfied [] History [[]]]
Procedures with no input parameters should not be tested for Access patterns.
Error executing the Procedural releational query with out a where
clause
------------------------------------------------------------------------
Key: TEIID-904
URL: https://jira.jboss.org/jira/browse/TEIID-904
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 6.2.0
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Fix For: 7.0
I have virtual stored procedure called "p1" which has no input parameters.
When I execute this procedure either via
select * from p1;
in both cases it fails with error
Group has an access pattern which has not been met: group(s) [vm.p1]; access pattern(s)
[Access Pattern: Unsatisfied [] History [[]]]
Procedures with no input parameters should not be tested for Access patterns.
--
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
5 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-904) Error executing the Procedural releational query with out a where clause
[
https://jira.jboss.org/jira/browse/TEIID-904?page=com.atlassian.jira.plug...
]
Steven Hawkins resolved TEIID-904.
----------------------------------
Resolution: Done
The issue is that an access pattern was being created even though there were no access
pattern elements. Updated SimpleQueryResolver, see TestProcedureRelational.
Error executing the Procedural releational query with out a where
clause
------------------------------------------------------------------------
Key: TEIID-904
URL: https://jira.jboss.org/jira/browse/TEIID-904
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 6.2.0
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Fix For: 7.0
I have virtual stored procedure called "p1" which has no input parameters.
When I execute this procedure either via
select * from p1;
in both cases it fails with error
Group has an access pattern which has not been met: group(s) [vm.p1]; access pattern(s)
[Access Pattern: Unsatisfied [] History [[]]]
Procedures with no input parameters should not be tested for Access patterns.
--
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
9:09 a.m.
New subject: [JBoss JIRA] Closed: (TEIID-904) Error executing the Procedural releational query with out a where clause
[
https://jira.jboss.org/browse/TEIID-904?page=com.atlassian.jira.plugin.sy...
]
Steve Hawkins closed TEIID-904.
-------------------------------
Error executing the Procedural releational query with out a where
clause
------------------------------------------------------------------------
Key: TEIID-904
URL: https://jira.jboss.org/browse/TEIID-904
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 6.2.0
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Fix For: 7.0
I have virtual stored procedure called "p1" which has no input parameters.
When I execute this procedure either via
select * from p1;
in both cases it fails with error
Group has an access pattern which has not been met: group(s) [vm.p1]; access pattern(s)
[Access Pattern: Unsatisfied [] History [[]]]
Procedures with no input parameters should not be tested for Access patterns.
--
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
5122
days inactive
5318
days old
3 comments
3 participants
participants (3)
-
Ramesh Reddy (JIRA) -
Steve Hawkins (JIRA)
-
Steven Hawkins (JIRA)