New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
In the GROUP BY clause, TiDB incorrectly handled ' ' and NULL #52938
Comments
The comparison with text type column seems ignoring white spaces. Not common cases. Lower priority to major.
|
/remove-severity critical |
/severity major |
/assign |
select * from t1 left outer join t0 on t0.c0 = t1.c0;
Result in mysql:
|
This issue do not need fix, cause create table with collate utf8mb4_unicode_ci in mysql, you will get the same result with tidb. |
/close |
@xzhangxian1008: Closing this issue. In response to this:
Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the kubernetes/test-infra repository. |
We will get same results between tidb and mysql with the following statements with all collations in tidb. So the behaviour in tidb is correct. Not a bug. drop table t0;
CREATE TABLE t0 (
c0 TEXT NOT NULL COLLATE xxx
) collate=xxx;
INSERT INTO t0 VALUES (' '), ('dadfad'), ('2342dfad'), ('2dfad');
select * from t0 where c0=' '; |
correct. strictly, we could try test with hashjoin case like the issue states also, cause it goes different func when running |
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
The text was updated successfully, but these errors were encountered: