[MDEV-34592] There are some problems with the keyword 'where if' - Jira

XML

Word

Printable

This statement returns result 1 in mysql but empty sets in mariadb.
mariadb:

   CREATE TABLE t0(c0 INT);

  INSERT INTO t0(c0) VALUES(1);

 SELECT * FROM t0 WHERE IF(FALSE, t0.c0, 0.1);

--Empty set

mysql:

   CREATE TABLE t0(c0 INT);

  INSERT INTO t0(c0) VALUES(1);

 SELECT * FROM t0 WHERE IF(FALSE, t0.c0, 0.1);

--1

duplicates

MDEV-34123 CONCAT Function Returns Unexpected Empty Set in Query

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