matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: Function or operator 'bin' will be implemented in future version

Open daviszhen opened this issue 3 years ago • 2 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

[ERROR] [SCRIPT FILE]: /Users/pengzhen/Documents/GitHub/matrixone/test/cases/function/func_string_findinset.test [ROW NUMBER]: 4 [SQL STATEMENT]: select bin(concat_ws(" ",find_in_set('b','a,b,c,d'))); [EXPECT RESULT]: bin(concat_ws(" ",find_in_set('b','a,b,c,d'))) 10 [ACTUAL RESULT]: Function or operator 'bin' will be implemented in future version.

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

daviszhen avatar Jul 02 '22 05:07 daviszhen

The function bin is wrong and contributed by an external author who have not fix it. So in migration plan, we decide to migrate it after it is fixed. Now, it is in plan1.

daviszhen avatar Jul 03 '22 09:07 daviszhen

ok for 0.6

dengn avatar Jul 04 '22 04:07 dengn

mysql> select bin(concat_ws(" ",find_in_set('b','a,b,c,d'))); +--------------------------------------------+ | bin(concat_ws( , find_in_set(b, a,b,c,d))) | +--------------------------------------------+ | 10 | +--------------------------------------------+ 1 row in set (0.00 sec)

aressu1985 avatar Oct 20 '22 15:10 aressu1985

Hello @daviszhen. The bug issue in the BVT test code has not been removed,issues automatically open.

matrix-meow avatar Oct 20 '22 15:10 matrix-meow

[sudong@mo-srv-128 test]$ grep -r "#3657" cases/ cases/function/func_string_findinset.test:-- @bvt:issue#3657

aressu1985 avatar Oct 24 '22 12:10 aressu1985

@daviszhen only issue owner is can close an issue.

tianyahui-python avatar Oct 29 '22 15:10 tianyahui-python

it was fixed.

daviszhen avatar Oct 30 '22 05:10 daviszhen