[MCOL-4622] Implicit FLOAT->INT and DOUBLE->INT conversion is not like in InnoDB - Jira

XML

Word

Printable

The problem reported in ~~MCOL-4619~~ (for DECIMAL) is also repeatable with implicit FLOAT->INT and DOUBLE->INT conversion:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(32), d FLOAT) ENGINE=ColumnStore;

INSERT INTO t1 VALUES ('aaaa', 1.5);

SELECT LEFT(a, d) FROM t1;

+------------+

| LEFT(a, d) |

+------------+

| a          |

+------------+

Looks wrong. It returns 'aa' with InnoDB.

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(32), d DOUBLE) ENGINE=ColumnStore;

INSERT INTO t1 VALUES ('aaaa', 1.5);

SELECT LEFT(a, d) FROM t1;

+------------+

| LEFT(a, d) |

+------------+

| a          |

+------------+

Looks wrong. It returns 'aa' with InnoDB.

Note, the problem is not repeatable with explicit CASTs:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (f FLOAT, d DOUBLE) ENGINE=ColumnStore;

INSERT INTO t1 VALUES (1.5, 1.5);

SELECT CAST(f AS SIGNED), CAST(d AS SIGNED) FROM t1;

+-------------------+-------------------+

| CAST(f AS SIGNED) | CAST(d AS SIGNED) |

+-------------------+-------------------+

|                 2 |                 2 |

+-------------------+-------------------+

relates to

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

MCOL-4619 TreeNode::getUintVal() does not round: Implicit DECIMAL->UINT conversion is not like in InnoDB

MCOL-641 Full DECIMAL support in ColumnStore

MCOL-4628 SET double_col=decimal_col returns an error

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