[MCOL-5413] insert into blob (text) with enabled columnstore_cache_use_import not working in some cases (result:NULL) Created: 2023-02-02  Updated: 2023-11-28  Resolved: 2023-11-10

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 6.2.3, 22.08.7
Fix Version/s: 23.10.0

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: triage


 Description   

To reproduce

Enabled insert cache
columnstore_cache_use_import = on

With disabled columnstore_cache_use_import
and with varchar it works fine.

Drop table if exists t1 ;
 
CREATE TABLE t1(
 
`c1` text DEFAULT NULL
 
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3
 
; 
 
 
 
 
insert into t1 (c1) values ('Monty');
 
insert into t1 (c1) values ('Widenius');
 
select * from t1;



 Comments   
Comment by Richard Stracke [ 2023-11-09 ]

With 23.10.0 testcase works.

MariaDB [d1]> show global status like 'columnstore_vers%';
 
+---------------------+---------+
 
| Variable_name       | Value   |
 
+---------------------+---------+
 
| Columnstore_version | 23.10.0 |
 
+---------------------+---------+
 
1 row in set (0.001 sec)
 
 
 
MariaDB [d1]> show global variables like 'columnstore_cache_ins%';
 
+---------------------------+-------+
 
| Variable_name             | Value |
 
+---------------------------+-------+
 
| columnstore_cache_inserts | ON    |
 
+---------------------------+-------+
 
1 row in set (0.001 sec) 
[..]
 
MariaDB [d1]> select * from t1;
 
+----------+
 
| c1       |
 
+----------+
 
| Monty    |
 
| Widenius |
 
+----------+
 
2 rows in set (0.118 sec)

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