[teiid-issues] [JBoss JIRA] (TEIID-2246) Incorrect results with TIMESTAMPDIFF

[ https://issues.jboss.org/browse/TEIID-2246?page=com.atlassian.jira.plugin... ] Van Halbert edited comment on TEIID-2246 at 10/5/12 2:16 PM: ------------------------------------------------------------- After doing some testing on the 7.4.x branch, it appears there's an overflow issue. I'll attach 2 patches that do: - use some suggested code that test for overflow - added unit tests that confirms the above issue When running the tests, you should see 3 error: Tests in error: testTimestampDiffTimeStamp_ErrorUsingEndDate(org.teiid.query.function.TestFunction): Long overflow testTimestampDiffTimeStamp_ErrorUsingEndDate2304(org.teiid.query.function.TestFunction): Long overflow testTimestampDiffTimeStamp_ErrorUsingEndDate2262(org.teiid.query.function.TestFunction): Long overflow The one added test: testTimestampDiffTimeStamp_ErrorUsingEndDate2261 was the determined boundary before 2262 starts producing the problem was (Author: van.halbert): After doing some testing on the 7.4.x branch, it appears there's an overflow issue. I'll attach 2 patches that do: - use some suggested code that test for overflow - added unit tests that confirms the above issue -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira