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.

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

Open
firebird-automations opened this issue Sep 19, 2012 · 8 comments

Comments

@firebird-automations
Copy link
Collaborator

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:

      select \* from table where ci\_ai\_field collate UNICODE = 'c'

furthermore, the following sentence is case sensitive (as expected):

      select \* from table where ci\_ai\_field collate UNICODE like 'c'
@firebird-automations
Copy link
Collaborator Author

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

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);
SQL> insert into tab values ('c');
SQL> insert into tab values ('C');
SQL> commit;
SQL>
SQL> select * from tab where ci_ai_field = 'c';

CI_AI_FIELD

c
C

SQL> select * from tab where ci_ai_field collate UNICODE = 'c';

CI_AI_FIELD

c

SQL> select * from tab where ci_ai_field collate UNICODE like 'c';

CI_AI_FIELD

c

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Cannot Reproduce [ 5 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

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;

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

I do not tested, but I know this is a important reason to reproduce this bug.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Cannot Reproduce [ 5 ] =>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants