Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-20784

Sql. Derive correct type for numbers manipulations operations.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 3.0.0-beta1
    • None
    • sql

    Description

      Both:
       

      SELECT 2147483647 + 1 
SELECT (2147483647 + 1)::DECIMAL(18,0)

       
      returns:
      -2147483648

      due to incorrect derive type for type overflow operations.

      note: processing of mentioned cases differs between DB implementations.

      Attachments

        Issue Links

          is a clone of

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-18662 Sql. Numeric to/from decimal cast with overflow does not produce an error

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              zstan Evgeny Stanilovsky
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: