Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.6.24
-
None
-
Unexpected results
-
Q3/2026 Server Maintenance
Description
In mysqltest, the TRIM(NULL) expression returns an empty string ('') instead of NULL. This behavior is incorrect and inconsistent with how MySQL server evaluates TRIM(NULL).
Test Case:
let $tt1 = $(trim(null)); |
-- echo trim(null) -> $tt1; |
mysqltest output:
worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029 |
trim(null) -> ; |
main.trim1 [ pass ]
|
server output :
MariaDB [(none)]> select trim(null); |
+------------+ |
| trim(null) | |
+------------+ |
| NULL | |
+------------+ |
1 row in set (0.001 sec) |
Attachments
Issue Links
- relates to
-
MDEV-36107 expressions in mysqltest
-
- Closed
-