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
Wrong result in "similar to" with non latin characters [CORE6145] #6394
Comments
Commented by: @mrotteveel I wonder if this is the result of the changes for CORE5931 |
Commented by: @asfernandes It's working for me in Linux. |
Commented by: Alex Bekhtin (afgm) I loose first version of issue with environment description, sorry |
Commented by: @asfernandes What's the connection charset? Test case with isql, please. |
Commented by: @pavel-zotov C:\FB\40SS>chcp 1251 C:\FB\40SS>isql /:e40 -ch win1251 C:\FB\40SS>isql /:e40
Records affected: 1 SQL> show version; |
Commented by: @asfernandes Also cannot reproduce in Windows with that download. |
Commented by: Alex Bekhtin (afgm) SET NAMES WIN1251; SQL> set list on; SQL> select * from rdb$database where 'Я' similar to '%Я%'; RDB$DESCRIPTION <null> |
Commented by: @pavel-zotov Compare 1st case - when we *do* specify charset - with 3.0.5 (and also specify -ch ....): C:\FB\30SS>isql /:e30 -ch win1251
Records affected: 1 |
Commented by: Alex Bekhtin (afgm) With charset NONE result is correct. |
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: Sean Leyne (seanleyne)environment: Windows 7 64bit |
Commented by: Sean Leyne (seanleyne) So to summarize: FB v3.x Charset = none -- unknown FB v4.x Charset = none -- Pass |
Commented by: @pavel-zotov > So to summarize: It is also PASSES. |
Commented by: @asfernandes Please try next snapshot. |
Commented by: Alex Bekhtin (afgm) I test it. Small difference between 3.0 and 4.0 with case insensitive 3.0 4.0 |
Commented by: Alex Bekhtin (afgm) Another example: select * from rdb$database where 'R' similar to 'r' -- True |
Commented by: @asfernandes Fixed. Please test again. |
Commented by: @pavel-zotov Issues of *this* ticket seems to be fixed, all fine with them. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Commented by: @asfernandes Pavel, I do not known what email are you talking about. I didn't received any email from you recently. |
Commented by: @pavel-zotov Adriano, perhaps you've changed e-mail ? I always wrote to this: mailto:adrianosf@gmail.com |
Commented by: @asfernandes Sorry, it was in my spam folder. |
Submitted by: Alex Bekhtin (afgm)
select * from rdb$database where 'Я' similar to '%Я%'
FB 3.0 - 1 line
FB 4.0 - 0 lines
Commits: 51ee150 6add872 093ba00
The text was updated successfully, but these errors were encountered: