Built-in string functions implementation: ASCII, BIN, BIT_LENGTH

[wanghaoyang1995]

Description

Add MySQL built-in functions ascii, bin, bit_length to evalengine.

Related Issue(s)

https://github.com/vitessio/vitess/issues/9647

Checklist

• [ ] Should this PR be backported?
• [x] Tests were added or are not required
• [ ] Documentation was added or is not required

Deployment Notes

N/A

[wanghaoyang1995]

@vmg Hello,vmg. I have fixed some problems as suggested. For some case not defined in MySQL docs, there are different outputs between MySQL 5 and MySQL 8. Which one should I refer to?

[vmg]

For some case not defined in MySQL docs, there are different outputs between MySQL 5 and MySQL 8. Which one should I refer to?

That's great! We always target MySQL 8's behavior. It would be even better if you added a test for this specific mismatch with a comment that says it's not backwards compatible with MySQL 5.

[github-actions[bot]]

This PR is being marked as stale because it has been open for 30 days with no activity. To rectify, you may do any of the following:

• Push additional commits to the associated branch.
• Remove the stale label.
• Add a comment indicating why it is not stale.

If no action is taken within 7 days, this PR will be closed.

[github-actions[bot]]

This PR was closed because it has been stale for 7 days with no activity.