[MCOL-4485] INSERT..SELECT throws Internal error: Bulkload Read Created: 2020-12-31  Updated: 2023-10-27  Resolved: 2023-10-27

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

Type: Bug Priority: Major
Reporter: Bharath Bokka (Inactive) Assignee: Leonid Fedorov
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

Artifacts: https://cspkg.s3.amazonaws.com/develop/pull_request/1434/centos7/

drop table cs1;drop table i1;
 
create table cs1 (a varchar(1) CHARACTER SET utf16 NOT NULL)engine=columnstore;
 
create table i1 (a varchar(1) CHARACTER SET utf16 NOT NULL)engine=columnstore;
 
insert into i1 values ('a');
 
insert into cs1 select * from i1;
 
ERROR 1815 (HY000): Internal error: PM1 : Bulkload Read (thread 0) Failed for Table test.cs1.  Terminating this job.


drop table cs1;drop table i1;
 
create table cs1 (a varchar(5) CHARACTER SET utf8 NOT NULL, b varchar(6) CHARACTER SET latin1 NOT NULL)engine=columnstore;
 
create table i1 (a varchar(5) CHARACTER SET utf8 NOT NULL,  b varchar(6) CHARACTER SET latin1 NOT NULL)engine=columnstore;
 
insert into i1 values ('a','b');
 
insert into cs1 select * from i1;
 
ERROR 1815 (HY000): Internal error: PM1 : Bulkload Read (thread 0) Failed for Table test.cs1.  Terminating this job.

This works fine in develop-5.

 Comments   
Comment by David Hall (Inactive) [ 2022-07-08 ]

This works for some reason without the CHARACTER SET UTF16 phrase.
For me it works for latin1:

MariaDB [dhall]> create table cs1 (a varchar(5) CHARACTER SET latin1 NOT NULL, b varchar(6) CHARACTER SET latin1 NOT NULL)engine=columnstore;
 
MariaDB [dhall]> create table i1 (a varchar(5) CHARACTER SET latin1 NOT NULL,  b varchar(6) CHARACTER SET latin1 NOT NULL)engine=columnstore;
 
MariaDB [dhall]> insert into i1 values ('a','b');
 
MariaDB [dhall]> insert into cs1 select * from i1;
 
Query OK, 1 row affected (2.234 sec)
 
Records: 1  Duplicates: 0  Warnings: 0

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