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-issue-importer opened this issue Mar 5, 2008 · 8 comments
Closed

Problem with COLLATE ES_ES_CI_AI [CORE1774] #2198

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

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Mar 5, 2008

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 6, 2008

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 8, 2008

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 8, 2008

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 17, 2008

Commented by: Jorge Andres Brugger (jbrugger)

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 17, 2008

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 31, 2008

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 18, 2008

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 28, 2015

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