[#MDEV-8754] Wrong result for SELECT..WHERE year_field=2020 AND NULLIF(year

[MDEV-8754] Wrong result for SELECT..WHERE year_field=2020 AND NULLIF(year_field,2010)='2020' Created: 2015-09-05 Updated: 2015-09-12 Resolved: 2015-09-10
Status:	Closed
Project:	MariaDB Server
Component/s:	Optimizer
Affects Version/s:	10.1.6
Fix Version/s:	10.1.8

Type:

Bug

Priority:

Major

Reporter:

Alexander Barkov

Assignee:

Alexander Barkov

Resolution:

Fixed

Votes:

Labels:

propagation, upstream-not-affected

Issue Links:

Blocks
blocks	~~MDEV-8728~~	Fix a number of problems in equal fie...	Closed
is blocked by	~~MDEV-8785~~	Wrong results for EXPLAIN EXTENDED......	Closed

Description

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a YEAR);

INSERT INTO t1 VALUES (2010),(2020);

SELECT * FROM t1 WHERE a=2020;

SELECT * FROM t1 WHERE NULLIF(a,2010)='2020';

SELECT * FROM t1 WHERE a=2020 AND NULLIF(a,2010)='2020';

The first and the second SELECT queries correctly return one row, and third SELECT query erroneously returns emptu set.

Generated at Thu Feb 08 07:29:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.