[MCOL-4456] INSERT..SELECT for all BLOB datatypes gives wrong results Created: 2020-12-17  Updated: 2021-01-21  Resolved: 2021-01-21

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 5.5.1, 6.1.1
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Bharath Bokka (Inactive) Assignee: Bharath Bokka (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

Artifacts: https://cspkg.s3.amazonaws.com/develop-5/pull_request/1351/centos7/

CREATE TABLE t1(col BLOB)ENGINE=Columnstore;
 
INSERT INTO t1 VALUES('cxyz'), ('4863'), ('*abc');
 
INSERT INTO t1 SELECT * FROM t1;
 
SELECT * FROM t1;
 
+------+
 
| col  |
 
+------+
 
| cxyz |
 
| 4863 |
 
| *abc |
 
| cdef |
 
| 4567 |
 
| *+,- |
 
+------+

This is a regression.

 Comments   
Comment by Roman [ 2021-01-20 ]

Plz review.

Comment by Bharath Bokka (Inactive) [ 2021-01-21 ]

Artifacts: https://cspkg.s3.amazonaws.com/develop-5/pull_request/1507
Closing the issue as this works fine on the above build.

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