Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

IS_UUID and UUID_TO_BIN shouldn't trim the argument #59457

Open
Tracked by #59410
YangKeao opened this issue Feb 11, 2025 · 1 comment
Open
Tracked by #59410

IS_UUID and UUID_TO_BIN shouldn't trim the argument #59457

YangKeao opened this issue Feb 11, 2025 · 1 comment
Labels
component/expression severity/moderate sig/execution SIG execution type/bug The issue is confirmed as a bug.

Comments

@YangKeao
Copy link
Member

YangKeao commented Feb 11, 2025

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

2. What did you expect to see? (Required)

mysql> SELECT IS_UUID(' 6ccd780c-baba-1026-8567-4cc3505b2a62 ');
+---------------------------------------------------+
| IS_UUID(' 6ccd780c-baba-1026-8567-4cc3505b2a62 ') |
+---------------------------------------------------+
|                                                 0 |
+---------------------------------------------------+
1 row in set (0.03 sec)

mysql> SELECT UUID_TO_BIN(' 6ccd780c-baba-1026-9564-5b8c656024db ');
ERROR 1411 (HY000): Incorrect string value: ' 6ccd780c-baba-1026-9564-5b8c656024db ' for function uuid_to_bin

3. What did you see instead (Required)

mysql> SELECT IS_UUID(' 6ccd780c-baba-1026-8567-4cc3505b2a62 ');
+---------------------------------------------------+
| IS_UUID(' 6ccd780c-baba-1026-8567-4cc3505b2a62 ') |
+---------------------------------------------------+
|                                                 1 |
+---------------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT UUID_TO_BIN(' 6ccd780c-baba-1026-9564-5b8c656024db ');
+--------------------------------------------------------------------------------------------------------------+
| UUID_TO_BIN(' 6ccd780c-baba-1026-9564-5b8c656024db ')                                                        |
+--------------------------------------------------------------------------------------------------------------+
| 0x6CCD780CBABA102695645B8C656024DB                                                                           |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

4. What is your TiDB version? (Required)

@YangKeao YangKeao added the type/bug The issue is confirmed as a bug. label Feb 11, 2025
@YangKeao YangKeao changed the title IS_UUID shouldn't trim the argument IS_UUID and UUID_TO_BIN shouldn't trim the argument Feb 11, 2025
@zanmato1984
Copy link
Contributor

/severity moderate

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
component/expression severity/moderate sig/execution SIG execution type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

2 participants