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

Server crashing with UTF8 blobs [CORE3427] #3789

Closed
firebird-automations opened this issue Apr 4, 2011 · 10 comments
Closed

Server crashing with UTF8 blobs [CORE3427] #3789

firebird-automations opened this issue Apr 4, 2011 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: ceeam (ceeam)

Is related to QA478

I have "BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET UTF8" (CI_AI collation) fields in my DB. When trying to "select * from tbl where blob_field like '%test%'" the server reliably crashes. Doesn't happen with WIN1251 (for example) blobs or VARCHAR fields.

Yes, I know that queries like those are not effective/recommended, but that's not the point, I guess.

Commits: e01b956 8a412c6

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

Seems that this crash depended on concrete data, so it was decided to copy these text from ticket.
Confirmed crash on 2.5.0, works fine on 2.5.1 and later.

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Cannot reproduce:

SQL> create table tbl (blob_field blob sub_type text character set utf8 collate unicode_ci_ai);
SQL> insert into tbl values ('test');
SQL> insert into tbl values ('TEST');
SQL> select * from tbl where blob_field like '%test%';

   BLOB\_FIELD 

=================
8a:0

BLOB_FIELD:
test

         8a:2 

==============================================================================
BLOB_FIELD:
TEST

@firebird-automations
Copy link
Collaborator Author

Commented by: ceeam (ceeam)

Well, that depends on the data then:

server#⁠ ./isql -u sysdba -p xxxxxxxxx -ch win1251
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database '/data/fb/foo.fdb';
SQL> create table tbl (blob_field blob sub_type text character set utf8 collate unicode_ci_ai);
SQL> insert into tbl values ('крупнейший европейский журнал о компьютерах. Вышел на рынок компьютерных изданий с уникальной концепцией и предназначен для людей, которые интересуются компьютерами, Интернетом, средствами телекоммуникаций, аудио-, видео- и фототехникой. Каждые две недели читателям предлагаются новости индустрии, тесты оборудования и программ, обучающие курсы и практические советы. Издание интересно как новичкам, так и опытным пользователям.');
SQL> commit;
SQL> select * from tbl where blob_field like '%test%';

   BLOB\_FIELD

=================
Statement failed, SQLSTATE = 08006
Error reading data from the connection.

Yep. Crashed and needs to be restarted.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Version: 3.0 Initial [ 10301 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Version: 2.5.1 [ 10333 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA478 [ QA478 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

Test Details: Seems that this crash depended on concrete data, so it was decided to copy these text from ticket.
Confirmed crash on 2.5.0, works fine on 2.5.1 and later.

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Test created.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

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