Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1468

Implement DECIMAL data type

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      Implement the DECIMAL data type, and test for all built-in operators.

      Do it using shifted integer values (or long, or short, depending on the required precision). For example, to represent 1234.56 as a DECIMAL(10, 2) we would use a 123456L (a long value because signed 10^10 requires 34.2 bits) and divide by 100 (2^10) on the way out.

      In SqlOperatorBaseTest, convert public static final boolean DECIMAL = false to true, and fix the 9 tests where that constant is used.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-1467 SqlFunctions power

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-1908 Mod function got exception in MOD(34.5,3), MOD(19,6.7) situation.

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              julianhyde Julian Hyde
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: