Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.6.24
-
None
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
-
- Open
-