Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 5.6.1, 6.1.1
-
Fix Version/s: 23.02
-
Component/s: PrimProc
-
Labels:None
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a TINYINT) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES (-1); |
SELECT LEFT('abc',a) FROM t1; |
+---------------+
|
| LEFT('abc',a) |
|
+---------------+
|
| abc |
|
+---------------+
|
Looks wrong. The expected result is:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a TINYINT) ENGINE=InnoDB; |
INSERT INTO t1 VALUES (-1); |
SELECT LEFT('abc',a) FROM t1; |
+---------------+
|
| LEFT('abc',a) |
|
+---------------+
|
| |
|
+---------------+
|
The same problem is repeatable with functions:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a TINYINT) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES (-1); |
SELECT LEFT('abc',COALESCE(a,a)) FROM t1; |
+---------------------------+
|
| LEFT('abc',COALESCE(a,a)) |
|
+---------------------------+
|
| abc |
|
+---------------------------+
|