[MCOL-4707] Columnstore Bugs 5.4.1 Created: 2021-05-03  Updated: 2023-07-01

Status: Open
Project: MariaDB ColumnStore
Component/s: Columnstore Select Handler
Affects Version/s: 5.4.1
Fix Version/s: Icebox

Type: Task Priority: Major
Reporter: andreas eschbacher Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Columnstore, int
Environment:

RHEL 8.2


Attachments: Zip Archive Columnstore_bugs.zip    
Issue Links:
Blocks
blocks MCOL-4672 MariaDB 10.5.8 Columnstore utf8mb4 su... Closed

 Description   

https://jira.mariadb.org/browse/MCOL-4672?filter=-2

As an addition to our utf8mb4 ticket we wanted to share some other bugs we found with you.


Preparation:
============

  • use the correct password for the database named ebi
  • use the correct path for "PizzaInput.csv" inside "insert_sql.sql"

Bug-Exposal:
============
1) execute "pizza.sh" when in "create_table.sql" "ENGINE=Columnstore" is used
2) "select * from ebi.bulk_table;" shows the data as in "Columnstore_does_NOT_work.png"

Two bugs can be seen:
bug1: the second varchar is null
bug2: the default value of the int "someInt" is ignored

3) change to ENGINE=InnoDB in create_table.sql
4) execute "pizza.sh" when in "create_table.sql" "ENGINE=InnoDB" is used
5) "select * from ebi.bulk_table;" shows the correct data as in "InnoDB_works.png"



 Comments   
Comment by andreas eschbacher [ 2021-05-05 ]

Upgrading to Columnstore Version 5.5.1 solved all our issues.

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