[MCOL-535] using arithemitic in the concat function crashes the PM's Created: 2017-01-26  Updated: 2017-02-06  Resolved: 2017-02-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: 1.0.6.1
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Nivesh Assignee: Andrew Hutchings (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Linux Redhat 7


Sprint: 2017-3

 Description   

running arithemetic inside a the concat() function on a char field causes the PM's to crash

Test case;

create table test_nulls_infini
(name varchar(100),
dbdate datetime
)engine=infinidb
;
insert into test_nulls_infini values('test', null);

;
select *
from test_nulls_infini
where concat("",name*1) = name
;

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-01-26 ]

Hi, can you please retry with 1.0.7? I have not been able to reproduce this in the latest version.

Comment by David Thompson (Inactive) [ 2017-01-26 ]

also make sure you specify engine=columnstore.

Comment by Nivesh [ 2017-02-06 ]

This is fixed on 1.0.7
I have been working on a old version.
hence the infinidb reference.

Thanks alot.

Comment by Andrew Hutchings (Inactive) [ 2017-02-06 ]

No problem, we caught a lot of these corner cases with the run-up to the GA release of ColumnStore, but they may still be some out there.

Closed as "Not a Bug" since it fixed in the GA release.

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