[MCOL-3286] zerofill not working for engine columstore Created: 2019-04-25  Updated: 2023-10-25  Resolved: 2023-10-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: Columnstore Select Handler
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Minor
Reporter: Catalin Dumitriu Assignee: Todd Stoffel (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None

Epic Link: ColumnStore Compatibility Improvements

 Description   

Hello,

I''m using Server version: 10.3.11-MariaDB-log Columnstore 1.2.2-1 in single mode and when i try to create a column with zerofill i receive "The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types."

Example:

create table test(
order_num int zerofill
) ENGINE=ColumnStore DEFAULT CHARSET=utf8mb4;



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-04-25 ]

Changed to Feature Request as we explicitly do not support this.

Comment by Catalin Dumitriu [ 2019-04-25 ]

Thanks for reply , so if i understand well the zerofill is not suported for engine columstore but only for innodb ?

Comment by Andrew Hutchings (Inactive) [ 2019-04-25 ]

Correct, other engines support it as well. Unfortunately ColumnStore's predecessor (InfiniDB) did not implement it so we don't have it. We need to have an engine specific implementation so that tools such as cpimport and our bulk write API can support it whereas most engines would not require this.

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