NULLIF does not work as documented

Description

The manual at https://mariadb.com/kb/en/mariadb/documentation/functions-and-operators/control-flow-functions/nullif/ says that NULLIF(expr1,expr2) is the same as CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END.
In fact it is not always true.

returns:

Notice, NULLIF erroneously created a VARCHAR column, while CASE correctly created a TIME column.

Environment

None

Status

Assignee

Alexander Barkov

Reporter

Alexander Barkov

Labels

None

Components

Fix versions

Affects versions

Priority

Minor
Configure