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
order select * from table where ci_ai_field collate UNICODE = 'c' is case insensitive [CORE3928] #4263
Comments
Modified by: Pablo León (palevi67)summary: UNICODE_CI_AI: SELECT => order select * from table where ci_ai_field collate UNICODE = 'c' is case insensitive |
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Commented by: @asfernandes Cannot reproduce! Reopen if you have reproducible testcase. isql -ch utf8 t.fdb SQL> create table tab (ci_ai_field varchar(5) character set utf8 collate unicode_ci_ai); CI_AI_FIELDc SQL> select * from tab where ci_ai_field collate UNICODE = 'c'; CI_AI_FIELDc SQL> select * from tab where ci_ai_field collate UNICODE like 'c'; CI_AI_FIELDc |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: Pablo León (palevi67) It seems that this only fails when the database is created with default collation set: create database "testdb" user "theuser" password "secret" page_size 16384 default character set utf8 collation unicode_ci_ai; |
Commented by: @asfernandes I do not tested, but I know this is a important reason to reproduce this bug. |
Modified by: @asfernandesstatus: Closed [ 6 ] => Reopened [ 4 ] resolution: Cannot Reproduce [ 5 ] => |
Submitted by: Pablo León (palevi67)
In a field with UNICODE_CI_AI collation, the following sentence is case insensitive, witch IMHO is wrong behavior:
furthermore, the following sentence is case sensitive (as expected):
The text was updated successfully, but these errors were encountered: