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-issue-importer opened this issue Apr 4, 2011 · 10 comments
Closed

Server crashing with UTF8 blobs [CORE3427] #3789

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

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Apr 4, 2011

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

@firebird-issue-importer firebird-issue-importer commented Apr 4, 2011

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

@firebird-issue-importer firebird-issue-importer commented Apr 5, 2011

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

@firebird-issue-importer firebird-issue-importer commented Apr 5, 2011

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 5, 2011

Modified by: @asfernandes

Version: 3.0 Initial [ 10301 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 5, 2011

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

@firebird-issue-importer firebird-issue-importer commented Apr 5, 2011

Modified by: @asfernandes

Version: 2.5.1 [ 10333 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 27, 2014

Modified by: @pcisar

Link: This issue is related to QA478 [ QA478 ]

@firebird-issue-importer
Copy link
Author

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

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

@firebird-issue-importer firebird-issue-importer commented Sep 25, 2015

Commented by: @pcisar

Test created.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 25, 2015

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
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants