[Bug]: order by result different from mysql

dengn commented 2 years ago

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): 6dedae20180c9e7ad4159ef0c7ad0f8e8c358dee
- Hardware parameters: MAC M1 ARM 16GB
- OS type: OSX
- Others:

Actual Behavior

CREATE TABLE t1 (st varchar(255) NOT NULL, u int(11) NOT NULL); INSERT INTO t1 VALUES ('a',1),('A',1),('aa',1),('AA',1),('a',1),('aaa',0),('BBB',0); select if(u=1,st,st) s from t1 order by s;

[SQL STATEMENT]: select if(u=1,st,st) s from t1 order by s; [EXPECT RESULT]: s a A a aa AA aaa BBB [ACTUAL RESULT]: s A AA BBB a a aa aaa

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

fengttt commented 2 years ago

collation. 0.6

dengn commented 2 years ago

same as #3344

daviszhen commented 2 years ago

it only can be fixed after the https://github.com/matrixorigin/matrixone/issues/3616 (p1) is done.

daviszhen commented 2 years ago

need collation

daviszhen commented 2 years ago

moved from 0.6. it is not in 0.7's plan.

daviszhen commented 1 year ago

i am not working on it

fengttt commented 1 year ago

converted to p0

daviszhen commented 1 year ago

i am not focus on it today

daviszhen commented 1 year ago

I am not working on it

matrix-meow commented 1 year ago

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

matrixorigin / matrixone