matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: REGEXP_LIKE() : The third parameter can't use correctly

Open goodMan-code opened this issue 3 years ago • 1 comments

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

goodMan-code avatar Oct 11 '22 08:10 goodMan-code

the third parameter will be supported in future release

domingozhang avatar Oct 12 '22 02:10 domingozhang

pr merged

iceTTTT avatar Feb 01 '23 02:02 iceTTTT

tracking

aressu1985 avatar Feb 21 '23 15:02 aressu1985

fixed mysql> SELECT REGEXP_LIKE('abc', 'ABC', 'c'); +--------------------------+ | regexp_like(abc, ABC, c) | +--------------------------+ | false | +--------------------------+ 1 row in set (1.09 sec)

aressu1985 avatar Mar 03 '23 04:03 aressu1985