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

Problem with COLLATE ES_ES_CI_AI [CORE1774] #2198

Closed
firebird-automations opened this issue Mar 5, 2008 · 8 comments
Closed

Problem with COLLATE ES_ES_CI_AI [CORE1774] #2198

firebird-automations opened this issue Mar 5, 2008 · 8 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Jesús Gálvez (xus)

Jira_subtask_outward CORE1781

CREATE TABLE TABLE_A (
FIELD_A VARCHAR(100) CHARACTER SET ISO8859_1 COLLATE ES_ES_CI_AI
);

INSERT INTO TABLE_A (FIELD_A) VALUES ('Hace buena noche');
INSERT INTO TABLE_A (FIELD_A) VALUES ('Voy a hacer de comer');
INSERT INTO TABLE_A (FIELD_A) VALUES ('The web is hacked');

When I run the query:

SELECT * FROM TABLE_A WHERE FIELD_A LIKE '%HACK%'

Results:
FIELD_A
Hace buen día
Voy a hacer de comer
The web is hacked

Why shows 'Hace' and 'Hacer' if I'm search for 'hack'?

Commits: 628ad70

====== Test Details ======

See also other tickets related to collation ES_ES_CI_AI: CORE1384, CORE2361, CORE1172, CORE1178

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

The letter "k" is incorrectly being mapped to "_" so it match any character.

This is a bug of case-/accent- insensitive collations, present in all branches since 2.0, but directly affects only (I hope) ES_ES_CI_AI of V2.0.X.

I'll commit a fix for 2.0.4 and 2.5... I can latter fix 2.1 if new RC are needed or defer to 2.1.1.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Version: 2.5 Initial [ 10260 ]

Version: 2.1 RC1 [ 10201 ]

Version: 2.1 Beta 2 [ 10190 ]

Version: 2.0.2 [ 10130 ]

Version: 2.1 Beta 1 [ 10141 ]

Version: 2.1 Alpha 1 [ 10150 ]

Version: 2.0.1 [ 10090 ]

Version: 2.0.0 [ 10091 ]

Fix Version: 2.0.4 [ 10211 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

Component: Charsets/Collation [ 10001 ]

Component: Engine [ 10000 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: Jorge Andres Brugger (jbrugger)

Adriano, it´s the one and only letter with this behaviour? (i.e, "mapped to _")

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Jorge,

All characters marked as IGNORE (i.e., the ones that with SPECIALS-FIRST=1 comes before - such as punctuations, underline and percent) are being mapped to some other character.

As such, the more problematic cases here is underline and percent, and hence the collation is very bugged.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

Test Details: See also other tickets related to collation ES_ES_CI_AI: CORE1384, CORE2361, CORE1172, CORE1178

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