matrixone
matrixone copied to clipboard
[Bug]: REGEXP_LIKE() : The third parameter can't use correctly
Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
Environment
- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:
Actual Behavior
The problematic SQL stmt is : SELECT REGEXP_LIKE('abc', 'ABC', 'c');
It's return : ERROR 20203 (HY000): invalid argument function regexp_like, bad value [VARCHAR VARCHAR VARCHAR]
The result on MySQL : +--------------------------------+ | REGEXP_LIKE('abc', 'ABC', 'c') | +--------------------------------+ | 0 | +--------------------------------+
Expected Behavior
No response
Steps to Reproduce
No response
Additional information
No response
the third parameter will be supported in future release
pr merged
tracking
fixed mysql> SELECT REGEXP_LIKE('abc', 'ABC', 'c'); +--------------------------+ | regexp_like(abc, ABC, c) | +--------------------------+ | false | +--------------------------+ 1 row in set (1.09 sec)