[MDEV-37865] IF() function is returning incorrect error - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.6.24
Fix Version/s: 10.6.28, 10.11.19, 11.4.13, 11.8.9, 12.3.3, 13.0.2
Component/s: Scripts & Clients
Labels:
None

Bug Category:
Not for Release Notes
Sprint:
Q3/2026 Server Maintenance

Description

The IF() function is not implemented in mysqltest. However, when we attempt to use IF() in test scripts, it is incorrectly interpreted as IFNULL(), leading to misleading or incorrect error messages during test execution.

Test Case:

let $lt36 = $(if(null,"   fallback", "   actual"));

-- echo (if(null, "   fallback", "   actual") -> $lt36;

Mysqltest Output:
mysqltest: At line 1: ifnull() expects 2 arguments, got 3

Server Output:

MariaDB [(none)]> select if(null,"   fallback", "   actual");

+-------------------------------------+

| if(null,"   fallback", "   actual") |

+-------------------------------------+

|    actual                           |

+-------------------------------------+

1 row in set (0.001 sec)

Attachments

Issue Links

relates to

MDEV-36107 expressions in mysqltest

Closed

Activity

People

Assignee:: Khaled Amr

Reporter:: Pooja Rani Lamba

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2025-10-15 09:18

Updated:: 6 days ago 14:25

Resolved:: 6 days ago 14:22

Time Tracking

Estimated:

0.5d

Remaining:

Logged:

6.25h

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.