[teiid-issues] [JBoss JIRA] (TEIID-5410) Incorrect result from timestampadd with 1 billion or more fractional seconds
Steven Hawkins (JIRA)
issues at jboss.org
Fri Jul 6 14:05:00 EDT 2018
[ https://issues.jboss.org/browse/TEIID-5410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-5410.
-----------------------------------
Fix Version/s: 11.1
11.0.1
10.3.3
Resolution: Done
Corrected the logic to appropriately handle both positive and negative fractional second counts along with correcting the overflow logic.
> Incorrect result from timestampadd with 1 billion or more fractional seconds
> ----------------------------------------------------------------------------
>
> Key: TEIID-5410
> URL: https://issues.jboss.org/browse/TEIID-5410
> Project: Teiid
> Issue Type: Sub-task
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 11.1, 11.0.1, 10.3.3
>
>
> A query such as:
> Select TimestampAdd(SQL_TSI_FRAC_SECOND, 999999999 + 1, Cast(CurDate() as timestamp));
> Returns a result with the incorrect amount of factional seconds.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list