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

Sql. Result of division doesn't match derived type

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • None
    • None
    • sql

    Description

      Try to execute following query:

      ignite.sql().execute(null, "SELECT CAST(? AS DECIMAL(32767, 32767)) / CAST(? AS DECIMAL(32767, 32767))", 1, 3)
      

      Although type of the division and therefore type of a single column of result provided in metadata is DECIMAL(32767, 0), actual value returned in result set has type DECIMAL(16, 16).

      Need to make execution to respect types derived during query planning.

      Attachments

        Activity

          People

            mzhuravkov Maksim Zhuravkov
            korlov Konstantin Orlov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: