Details
Description
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 |
|
+------+-------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
|
Notice:
- the original definition has parentheses around 1=2 and no parentheses around BETWEEN
- the created definition has parentheses around BETWEEN
Attachments
Issue Links
- relates to
-
MDEV-23656 view: removal of parentheses results in wrong result
- Closed
-
MDEV-17359 || operator is not understand by "like" in Oracle
- Closed
-
MDEV-17406 Problems with LIKE using a parenthesized expression in the pattern
- Open