[MCOL-4622] Implicit FLOAT->INT and DOUBLE->INT conversion is not like in InnoDB Created: 2021-03-19  Updated: 2023-07-02

Status: Open
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: 5.5.1, 5.6.1, 6.1.1
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-4361 Replace pow(10.0, (double)scale) expr... Closed
relates to MCOL-4619 TreeNode::getUintVal() does not round... Closed
relates to MCOL-641 Full DECIMAL support in ColumnStore Closed
relates to MCOL-4628 SET double_col=decimal_col returns an... Open

 Description   

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 |
 
+-------------------+-------------------+


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