[MCOL-5413] insert into blob (text) with enabled columnstore_cache_use_import not working in some cases (result:NULL) - Jira

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;

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)

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB ColumnStore