[MDEV-6884] greatest and coalesce on null date does not produce null Created: 2014-10-17 Updated: 2022-11-08 Resolved: 2022-11-08 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | OTHER |
| Affects Version/s: | 5.5.40, 10.0.14 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Marcel Schneider | Assignee: | Alexander Barkov |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | None | ||
| Description |
|
I create a table and insert one row like this:
The bug can be reproduced with this statement:
this should return null, but it doesnt.
==> Returns one row It is also possible to insert this "corrupt null" into a table:
if you select from this table with a select * from datetest where date1 is not null, you will get the row with nr=2 Additional info: |
| Comments |
| Comment by Elena Stepanova [ 2014-10-17 ] |
|
Thanks for the report. |
| Comment by Sergei Golubchik [ 2022-11-08 ] |
|
fixed before 10.3.37 |