[MCOL-4718] Decimal offset incorrect after cpimport Created: 2021-05-11  Updated: 2021-06-28  Resolved: 2021-06-28

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

Type: Bug Priority: Blocker
Reporter: David Hall (Inactive) Assignee: David Hall (Inactive)
Resolution: Fixed Votes: 0
Labels: regression

Sprint: 2021-8, 2021-9

 Description   

See test011 bug3801

create table bug3801 (
 
  id int,
 
  c1 decimal(10,3),
 
  c2 decimal(9,2)
 
) engine=columnstore;

The following values are added via colxml and cpimport

Contents of tables/bug3801.tbl
 
1|000250.000|232.20|
 
2|99.233|004.00|
 
3|2333.2|23.99|


colxml -j 1114 -t bug3801 $DB
 
cpimport -j 1114 -f STDIN < tables/bug3801.tbl


select * from bug3801;


+------+-------------+----------+
 
| id   | c1          | c2       |
 
+------+-------------+----------+
 
|    1 |  250000.000 | 23220.00 |
 
|    2 |   99233.000 |   400.00 |
 
|    3 | 2333200.000 |  2399.00 |
 
+------+-------------+----------+
 
3 rows in set (0.151 sec)



 Comments   
Comment by David Hall (Inactive) [ 2021-06-28 ]

Not able to reproduce. Assume fixed as part of another bug.

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