Skip to content
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.

Sign up for GitHub

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

Jump to bottom

[Bug] Inconsistent behavior for string comparison in FE and BE #13573

Closed
1 of 3 tasks
Gabriel39 opened this issue Oct 22, 2022 · 1 comment · Fixed by #13604
Closed
1 of 3 tasks

[Bug] Inconsistent behavior for string comparison in FE and BE #13573

Gabriel39 opened this issue Oct 22, 2022 · 1 comment · Fixed by #13604
Labels
good first issue

Comments

@Gabriel39
Copy link
Contributor

Gabriel39 commented Oct 22, 2022 •
edited
Loading

Search before asking

  • I had searched in the issues and found no similar issues.

Version

master

What's Wrong?

In FE, when constant folding rule is applied, '汇总' is always less than '2022-01-01'.
image

But when I send a sorting sql which runs a sorting in BE, the result is contrary.
image

What You Expected?

FE should keep the same logic as BE.

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct
@nextdreamblue
Copy link
Contributor

be中，字符串的比较是基于utf8的编码，按字节比较，字节是基于uint8
fe中，java基于signed byte
导致be中fe中，编码值对应的数字值不同导致排序不同

@nextdreamblue nextdreamblue mentioned this issue Oct 24, 2022
Merged
13 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
good first issue
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[fix](fe) Inconsistent behavior for string comparison in FE and BE nextdreamblue/doris
2 participants
@nextdreamblue @Gabriel39