Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5406 Allow usage of long datatype as the increment parameter in TimestampAdd function
  3. TEIID-5410

Incorrect result from timestampadd with 1 billion or more fractional seconds

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: