[teiid-issues] [JBoss JIRA] (TEIID-4463) No results with cross source outer join and offset only
Steven Hawkins (JIRA)
issues at jboss.org
Thu Sep 22 17:45:00 EDT 2016
Steven Hawkins created TEIID-4463:
-------------------------------------
Summary: No results with cross source outer join and offset only
Key: TEIID-4463
URL: https://issues.jboss.org/browse/TEIID-4463
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 9.1, 8.13.7, 9.0.5
TEIID-3568 introduced a regression where when only an offset is used, the pushed limit will effectively prevent any results.
So a query like:
select ... sourcea.tbl left outer join sourceb.tbl ... offset 1 row
will push a limit 1 to the sourcea.tbl query, effectively eliminating all results.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list