[#MDEV-17408] VIEW is incorrectly defined for a combination of = and BETWEEN

DROP VIEW IF EXISTS v1;

CREATE VIEW v1 AS SELECT (1 = 2) BETWEEN 1 AND 2 AS c;

SHOW CREATE TABLE v1;

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

| View | Create View                                                                                                                   | character_set_client | collation_connection |

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

| v1   | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 = (2 between 1 and 2) AS `c` | utf8                 | utf8_general_ci      |

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

[MDEV-17408] VIEW is incorrectly defined for a combination of = and BETWEEN Created: 2018-10-09 Updated: 2020-10-23 Resolved: 2020-10-23
Status:	Closed
Project:	MariaDB Server
Component/s:	Parser, Views
Affects Version/s:	10.5.5, 10.2, 10.3, 10.4, 10.5
Fix Version/s:	10.2.35, 10.3.26, 10.4.16, 10.5.7

[MDEV-17408] VIEW is incorrectly defined for a combination of = and BETWEEN Created: 2018-10-09 Updated: 2020-10-23 Resolved: 2020-10-23