[MDEV-5975] Prepared statements with DATE literals do not honor NO_ZERO_IN_DATE - Jira

SET sql_mode=DEFAULT;

PREPARE stmt FROM "SELECT (SELECT DATE'2001-00-00') AS c";

EXECUTE stmt;

SET sql_mode='no_zero_in_date';

EXECUTE stmt;

returns:

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

| c          |

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

| 2001-00-00 |

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

1 row in set (0.00 sec)

for both EXECUTE.
This is wrong. The second EXECUTE should return NULL.

If I change the script slightly:

SET sql_mode=DEFAULT;

PREPARE stmt FROM "SELECT (SELECT DATE('2001-00-00')) AS c";

EXECUTE stmt;

SET sql_mode='no_zero_in_date';

EXECUTE stmt;

it correctly returns '2001-00-00' for the first EXECUTE and NULL for the second EXECUTE,
as expected.

Pushed into 10.0.

Alexander Barkov added a comment - 2014-04-22 10:27 Pushed into 10.0.

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

MariaDB Server