[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 insert into test_nulls_infini values('test', null) select ifnull(dbdate,now()) |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2017-01-26 ] | ||||||
|
Result in 1.0.7:
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 | ||||||
| Comment by Andrew Hutchings (Inactive) [ 2017-02-06 ] | ||||||
|
Closed as "Not a Bug" since this isn't an issue in the current GA release. |