[MCOL-536] ifnull function does not work on datetime datatype. Created: 2017-01-26  Updated: 2017-02-06  Resolved: 2017-02-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.0.7
Fix Version/s: Icebox

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

Linux Redhat


Sprint: 2017-3

 Description   

The ifnull() function does not work on the datetime data type in mariaDB CS.

Test case:

create table test_nulls_infini
(name varchar(100),
dbdate datetime
)engine=infinidb
;

insert into test_nulls_infini values('test', null)
;

select ifnull(dbdate,now())
from test_nulls_infini
;



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

Result in 1.0.7:

+----------------------+
| ifnull(dbdate,now()) |
+----------------------+
| 2017-01-26 10:39:14  |
+----------------------+
1 row in set (0.09 sec)

Is this not what you were expecting?

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

also make sure you specify engine=columnstore.

Comment by Nivesh [ 2017-02-06 ]

yes thanks looks like this is fixed in 1.0.7
apologies.

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

Closed as "Not a Bug" since this isn't an issue in the current GA release.

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