Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4361

Replace pow(10.0, (double)scale) expressions with a static dictionary lookup.

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 6.1.1
    • PrimProc
    • None

    Description

      We need to find and replace expressions like pow(10.0, (double)scale) related to DECIMALS(<19) processing and replace them with a static dictionary lookup.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4600 CAST(decimal AS SIGNED/UNSIGNED) returns a wrong result

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4604 CHAR(negativeWideDecimal) not behaving as InnoDB

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4609 TreeNode::getIntVal() does not round: implicit DECIMAL->INT cast is not MariaDB compatible

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4610 TreeNode::getUintVal() looses precision for narrow decimal

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4614 calShowPartitions() precision loss for huge narrow decimal

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4615 GROUP_CONCAT() precision loss for huge narrow decimal

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4618 FLOOR(-9999.0) returns a bad result

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4619 TreeNode::getUintVal() does not round: Implicit DECIMAL->UINT conversion is not like in InnoDB

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4629 Add a helper method mcsv1_UDAF::toDouble()

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4631 CAST(double AS SIGNED) returns 0 or NULL

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4633 Remove duplicate code for DECIMAL to int64_t rounding conversion

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4640 Narrow DECIMAL precision loss in CAST(AS SIGNED) and CHAR()

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4647 SEC_TO_TIME(double_or_float) returns a wrong result

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4649 CAST(double AS UNSIGNED) returns 0

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4650 TreeNode::getIntVal() looses precision for narrow decimal

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4651 SEC_TO_TIME(hugePositiveDecimal) returns a negative time

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4653 CEIL(negativeNarrowDecimal) inside another function returns a wrong result

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4660 Narow decimal to string conversion is inconsistent about zero integral

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4668 PERIOD_DIFF(dec_or_double1,dec_or_double2) is not as in InnoDB

          • Major - Major loss of function.
          • Closed
          is part of

          New Feature - A new feature of the product, which has yet to be developed. MCOL-641 Full DECIMAL support in ColumnStore

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4611 MOD loses precision on huge narrow decimal

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4627 SET int_col=decimal_col returns an error

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4628 SET double_col=decimal_col returns an error

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4655 CAST(ROUND(magicInWideDecimal) AS SIGNED) returns NULL

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4667 Precision loss on AVG(decimal)

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25174 DOUBLE columns do not accept large hex hybrids

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4601 MOD and DIV operators not behaving as InnoDB

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4605 FROM_UNIXTIME(negativeDecimal) not behaving as InnoDB

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4607 SEC_TO_TIME(wideDecimal) returns 0 in DECIMAL context

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4608 SET_TO_TIME(decimal) does not preserve microseconds

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4612 A subquery with a union for DECIMAL and BIGINT returns zeros

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4613 Garbage result of a union between huge narrow DECIMAL and BIGINT

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4622 Implicit FLOAT->INT and DOUBLE->INT conversion is not like in InnoDB

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4623 sec_to_time() does not support FLOAT/DOUBLE UNSIGNED

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4632 CAST(hugeNegativeWideDecimal AS SIGNED) returns 0 or NULL

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4648 CAST(UBIGINTNULL_inWideDecimal AS UNSIGNED) returns 0 or NULL

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4671 LEFT(str, negativeInt) returns a wrong result

          • Major - Major loss of function.
          • Open

          Activity

            People

              bar Alexander Barkov
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.