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

builtin function WEIGHT_STRING() not support #3580

Closed
winkyao opened this issue Jun 30, 2017 · 0 comments · Fixed by #14792
Closed

builtin function WEIGHT_STRING() not support #3580

winkyao opened this issue Jun 30, 2017 · 0 comments · Fixed by #14792
Labels
help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/compatibility
Milestone

Comments

@winkyao
Copy link
Contributor

winkyao commented Jun 30, 2017

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?

    use mysql builtin function WEIGHT_STRING(), but it is not supported by TiDB yet.

  2. What did you expect to see?

mysql> SELECT HEX(WEIGHT_STRING('ab' AS CHAR(4)));
+-------------------------------------+
| HEX(WEIGHT_STRING('ab' AS CHAR(4))) |
+-------------------------------------+
| 0041004200200020                    |
+-------------------------------------+
1 row in set (0.03 sec)
  1. What did you see instead?
mysql> SELECT HEX(WEIGHT_STRING('ab' AS CHAR(4)));
ERROR 1105 (HY000): line 0 column 25 near "'ab' AS CHAR(4)))" (total length 42)
  1. What version of TiDB are you using (tidb-server -V)?
[wink@localhost tidb]$ bin/tidb-server -V
Git Commit Hash: 677fd05c82517e20c60345202e8dc612b1942615
UTC Build Time:  2017-06-29 08:03:08
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/compatibility
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants