Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5413

insert into blob (text) with enabled columnstore_cache_use_import not working in some cases (result:NULL)

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.2.3, 22.08.7
    • 23.10.0
    • N/A

    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;

      Attachments

        Activity

          Richard Richard Stracke added a comment -

          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)

          Richard Richard Stracke added a comment - 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)

          People

            Unassigned Unassigned
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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