MySQL Bugs: #114947: Right and Left functions do not work as documented within WHERE clauses

Bug #114947	Right and Left functions do not work as documented within WHERE clauses
Submitted:	9 May 2024 23:54	Modified:	10 May 2024 7:06
Reporter:	Yoseph Phillips	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S3 (Non-critical)
Version:	8.0.37	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Right and Left functions do not work as documented within WHERE clauses.

See How to repeat below - it should not return any rows as '' <> ' '

How to repeat:
CREATE TEMPORARY TABLE test_table (testColumn VARCHAR(10)) SELECT '' AS testColumn;

SELECT * FROM test_table WHERE right(testColumn, 1) = ' ';

Hello Yoseph Phillips,

Thank you for the report and feedback.

regards,
Umesh