[MCOL-4361] Replace pow(10.0, (double)scale) expressions with a static dictionary lookup. Created: 2020-10-15  Updated: 2021-04-13  Resolved: 2021-04-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: None
Fix Version/s: 6.1.1

Type: Task Priority: Minor
Reporter: Roman Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MCOL-4600 CAST(decimal AS SIGNED/UNSIGNED) retu... Closed
is blocked by MCOL-4604 CHAR(negativeWideDecimal) not behavin... Closed
is blocked by MCOL-4609 TreeNode::getIntVal() does not round:... Closed
is blocked by MCOL-4610 TreeNode::getUintVal() looses precisi... Closed
is blocked by MCOL-4614 calShowPartitions() precision loss fo... Closed
is blocked by MCOL-4615 GROUP_CONCAT() precision loss for hug... Closed
is blocked by MCOL-4618 FLOOR(-9999.0) returns a bad result Closed
is blocked by MCOL-4619 TreeNode::getUintVal() does not round... Closed
is blocked by MCOL-4629 Add a helper method mcsv1_UDAF::toDou... Closed
is blocked by MCOL-4631 CAST(double AS SIGNED) returns 0 or NULL Closed
is blocked by MCOL-4633 Remove duplicate code for DECIMAL to ... Closed
is blocked by MCOL-4640 Narrow DECIMAL precision loss in CAST... Closed
is blocked by MCOL-4647 SEC_TO_TIME(double_or_float) returns ... Closed
is blocked by MCOL-4649 CAST(double AS UNSIGNED) returns 0 Closed
is blocked by MCOL-4650 TreeNode::getIntVal() looses precisio... Closed
is blocked by MCOL-4651 SEC_TO_TIME(hugePositiveDecimal) retu... Closed
is blocked by MCOL-4653 CEIL(negativeNarrowDecimal) inside an... Closed
is blocked by MCOL-4660 Narow decimal to string conversion is... Closed
is blocked by MCOL-4668 PERIOD_DIFF(dec_or_double1,dec_or_dou... Closed
PartOf
is part of MCOL-641 Full DECIMAL support in ColumnStore Closed
Relates
relates to MCOL-4611 MOD loses precision on huge narrow de... Open
relates to MCOL-4627 SET int_col=decimal_col returns an error Open
relates to MCOL-4628 SET double_col=decimal_col returns an... Open
relates to MCOL-4655 CAST(ROUND(magicInWideDecimal) AS SIG... Open
relates to MCOL-4667 Precision loss on AVG(decimal) Open
relates to MDEV-25174 DOUBLE columns do not accept large he... Open
relates to MCOL-4601 MOD and DIV operators not behaving as... Open
relates to MCOL-4605 FROM_UNIXTIME(negativeDecimal) not be... Open
relates to MCOL-4607 SEC_TO_TIME(wideDecimal) returns 0 in... Open
relates to MCOL-4608 SET_TO_TIME(decimal) does not preserv... Open
relates to MCOL-4612 A subquery with a union for DECIMAL a... Closed
relates to MCOL-4613 Garbage result of a union between hug... Closed
relates to MCOL-4622 Implicit FLOAT->INT and DOUBLE->INT c... Open
relates to MCOL-4623 sec_to_time() does not support FLOAT/... Open
relates to MCOL-4632 CAST(hugeNegativeWideDecimal AS SIGNE... Closed
relates to MCOL-4648 CAST(UBIGINTNULL_inWideDecimal AS UNS... Closed
relates to MCOL-4671 LEFT(str, negativeInt) returns a wron... Open
Epic Link: ColumnStore Compatibility Improvements
Sprint: 2021-5, 2021-6

 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.


Generated at Thu Feb 08 02:49:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.