[MCOL-116] Casual partitioning flag for dictionary columns are incorrect after cpimport Created: 2016-06-10  Updated: 2016-06-10  Resolved: 2016-06-10

Status: Closed
Project: MariaDB ColumnStore
Component/s: cpimport
Affects Version/s: None
Fix Version/s: 1.0.0

Type: Bug Priority: Minor
Reporter: Daniel Lee (Inactive) Assignee: David Hall (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

mscadmin> getsoft
getsoftwareinfo Fri Jun 10 09:56:14 2016

Name : mariadb-columnstore-platform Relocations: (not relocatable)
Version : 1.0 Vendor: MariaDB Corporation Ab
Release : 0 Build Date: Thu 09 Jun 2016 11:04:20 AM EDT
Install Date: Thu 09 Jun 2016 12:00:38 PM EDT Build Host: srvbuilder
Group : Applications Source RPM: mariadb-columnstore-1.0-0.src.rpm

Test case: Autopilot systemTest/casualPartition

After an import job, cpimport should set the casual partitioning flags for each column to valid. I import a 10g lineitem table. Flags for dictionary columns (l_shipinstruct, l_shipmode, l_comment) are not set correctly.

[root@s1um1 casualPartition]# /usr/local/mariadb/columnstore/bin/editem -o 34123
Col OID = 34123, NumExtents = 8, width = 8
15630336 - 15638527 (8192) min: notset, max: notset, seqNum: 0, state: valid, fbo: 0, DBRoot: 2, part#: 0, seg#: 0, HWM: 0; status: avail
15747072 - 15755263 (8192) min: notset, max: notset, seqNum: 0, state: invalid, fbo: 0, DBRoot: 1, part#: 0, seg#: 1, HWM: 0; status: unavail
15912960 - 15921151 (8192) min: notset, max: notset, seqNum: 0, state: invalid, fbo: 0, DBRoot: 2, part#: 0, seg#: 2, HWM: 0; status: unavail
16005120 - 16013311 (8192) min: notset, max: notset, seqNum: 0, state: invalid, fbo: 0, DBRoot: 1, part#: 0, seg#: 3, HWM: 0; status: unavail
16195584 - 16203775 (8192) min: notset, max: notset, seqNum: 0, state: invalid, fbo: 8192, DBRoot: 2, part#: 0, seg#: 0, HWM: 16383; status: avail
16287744 - 16295935 (8192) min: notset, max: notset, seqNum: 0, state: invalid, fbo: 8192, DBRoot: 1, part#: 0, seg#: 1, HWM: 16383; status: avail
16445440 - 16453631 (8192) min: notset, max: notset, seqNum: 0, state: invalid, fbo: 8192, DBRoot: 2, part#: 0, seg#: 2, HWM: 12917; status: avail
16537600 - 16545791 (8192) min: notset, max: notset, seqNum: 0, state: invalid, fbo: 8192, DBRoot: 1, part#: 0, seg#: 3, HWM: 12911; status: avail



 Comments   
Comment by Daniel Lee (Inactive) [ 2016-06-10 ]

I just realized that casual partition test case was broke by the latest changes in InfiniDB 4.6 and the reported behavior is expected. Thanks you for Mr. Hall for confirming that in InfiniDB 4.6.

I have not been running for Columnstore. For the latest test, I ran it by accident. Anyway, I spent time today and have the test case fixed.

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