[JBoss JIRA] Created: (TEIID-1422) Limit pushing can result in inconsistent xml results
by Steven Hawkins (JIRA)
Limit pushing can result in inconsistent xml results
----------------------------------------------------
Key: TEIID-1422
URL: https://issues.jboss.org/browse/TEIID-1422
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.1.1, 7.3
A customer case (00393370) was using rowlimitexception and not actually triggering the exception when expected. This is due to our logic in rulepushlimit that allows an unordered limit to be pushed through union not all, select nodes, or dup removal. While the results may be consistent for some ordering of results there are many situations when you will get back far less results than the limit specifies. The intent was to more broadly push the limit rather than to apply it in a fully consistent manner. However this is problematic for situations, like the rowlimitexception logic that expect an exceptional condition to be triggered if the limit is exceeded.
The best fix would be to just not push an unordered limit in these situations, then if the more aggressive pushing is desired by a user we can look at using a hint or some other mechanism to allow the pushing.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 9 months
[JBoss JIRA] Created: (TEIID-1406) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
by Paul Nittel (JIRA)
Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1406
URL: https://issues.jboss.org/browse/TEIID-1406
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: sfQueryError.txt
As part of testing the SalesForce connector, I executed the following query:
Select Subject, ClosedDate from Case_ where ClosedDate > {ts'2003-03-11 11:42:10.5'}
and got back:
Error: Remote org.teiid.core.TeiidProcessingException: MALFORMED_QUERY:
> 2003-03-11T11:42:10.500Z-05:00 LIMIT 100
^
ERROR at Row:1:Column:101
line 1:101 mismatched character ' ' expecting ':'
A more complete stack trace is attached.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 9 months