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

Regression: Server crashes when executing sql query "delete from mytable order by id desc rows 2" [CORE4108] #4436

Closed
firebird-automations opened this issue May 29, 2013 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @sim1984

Firebird crash when executing sql query

CREATE TABLE MYTABLE (
ID INTEGER NOT NULL PRIMARY KEY,
NAME VARCHAR(30)
);

insert into mytable(id, name)
select 1, 'a' from rdb$database
union all
select 2, 'b' from rdb$database
union all
select 3, 'c' from rdb$database;

delete from mytable order by id desc rows 2;

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

Then actions connection to be lost

for 2.5.2 it works correctly

Commits: f73ca88 FirebirdSQL/fbt-repository@eb164a6

@firebird-automations
Copy link
Collaborator Author

Modified by: @sim1984

description: Firebird crash when executing sql query

CREATE TABLE MYTABLE (
ID INTEGER NOT NULL PRIMARY KEY,
NAME VARCHAR(30)
);

insert into mytable(id, name)
select 1, 'a' from rdb$database
union all
select 2, 'b' from rdb$database
union all
select 3, 'c' from rdb$database;

delete from mytable order by id desc rows 2;

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

for 2.5.2 it works correctly

=>

Firebird crash when executing sql query

CREATE TABLE MYTABLE (
ID INTEGER NOT NULL PRIMARY KEY,
NAME VARCHAR(30)
);

insert into mytable(id, name)
select 1, 'a' from rdb$database
union all
select 2, 'b' from rdb$database
union all
select 3, 'c' from rdb$database;

delete from mytable order by id desc rows 2;

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

Then actions connection to be lost

for 2.5.2 it works correctly

environment: Windows 7 x86
IBExpert, isql
Firebird 3.0.0.30431

=>

Windows 7 x86
IBExpert, isql
Firebird 3.0.0.30431 SS

summary: Firebird crash when executing sql query "delete from mytable order by id desc rows 10" => Firebird crash when executing sql query "delete from mytable order by id desc rows 2"

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

summary: Firebird crash when executing sql query "delete from mytable order by id desc rows 2" => Regression: Server crashes when executing sql query "delete from mytable order by id desc rows 2"

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

assignee: Dmitry Yemanov [ dimitr ]

@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

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

No branches or pull requests

2 participants