[Feature] [Vectorized] support locate function

[BiteTheDDDDt]

Search before asking

• I had searched in the issues and found no similar issues.

Description

support function locate in vectorized engine.

Use case

MySQL [(none)]> SELECT LOCATE('', '', 1);
+-------------------+
| locate('', '', 1) |
+-------------------+
| 1 |
+-------------------+
1 row in set (0.613 sec)

MySQL [(none)]> SELECT LOCATE('bar', 'foobarbar', 5);
+-------------------------------+
| locate('bar', 'foobarbar', 5) |
+-------------------------------+
| 7 |
+-------------------------------+
1 row in set (0.015 sec)

Related issues

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct