[MDEV-7001] Bad result for NOT NOT STRCMP('a','b') and NOT NOT NULLIF(2,3) Created: 2014-11-01  Updated: 2014-11-17  Resolved: 2014-11-14

Status: Closed
Project: MariaDB Server
Component/s: Character Sets
Affects Version/s: 5.5.40, 10.0.14, 5.3.13
Fix Version/s: 10.0.15

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None


 Description    

SELECT NOT NOT STRCMP('a','b');

returns

+-------------------------+
 
| NOT NOT STRCMP('a','b') |
 
+-------------------------+
 
|                      -1 |
 
+-------------------------+
 
1 row in set (0.00 sec)

The expected result is 1.

The same problem is observed with NOT NOT NULLIF(2,3).

mysql> SELECT NOT NOT NULLIF(2,3);
 
+---------------------+
 
| NOT NOT NULLIF(2,3) |
 
+---------------------+
 
|                   2 |
 
+---------------------+
 
1 row in set (0.00 sec)

The expected result is 1.
Generated at Thu Feb 08 07:16:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.