We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Submitted by: @dyemanov
recreate table t (id int not null); alter table t add constraint pk primary key (id);
insert into t values (1); commit;
select * from t t1, t t2, t t3, t t4 where http://t1.id = http://t2.id and http://t2.id = http://t3.id and http://t3.id = http://t4.id PLAN MERGE (JOIN (T1 NATURAL, T2 INDEX (PK)), JOIN(T3 NATURAL, T4 INDEX (PK)))
the engine reports: PLAN JOIN (MERGE (SORT (JOIN (T3 NATURAL, T4 INDEX (PK))), SORT (JOIN (T1 NATURAL, T2 INDEX (PK)))), JOIN ())
and crashes in rse.cpp because of rsb_count == 0 (in the last join).
Commits: 6729422 eecccbb
The text was updated successfully, but these errors were encountered:
Commented by: @dyemanov
Fixed in both v2.0.1 and v2.1.
Sorry, something went wrong.
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
Commented by: @pmakowski
Q/A test made ok
status: Resolved [ 5 ] => Closed [ 6 ]
Workflow: jira [ 11358 ] => Firebird [ 15439 ]
QA Status: No test
QA Status: No test => Done successfully
dyemanov
No branches or pull requests
Submitted by: @dyemanov
recreate table t (id int not null);
alter table t add constraint pk primary key (id);
insert into t values (1);
commit;
select *
from t t1, t t2, t t3, t t4
where http://t1.id = http://t2.id
and http://t2.id = http://t3.id
and http://t3.id = http://t4.id
PLAN MERGE (JOIN (T1 NATURAL, T2 INDEX (PK)), JOIN(T3 NATURAL, T4 INDEX (PK)))
the engine reports:
PLAN JOIN (MERGE (SORT (JOIN (T3 NATURAL, T4 INDEX (PK))), SORT (JOIN (T1 NATURAL, T2 INDEX (PK)))), JOIN ())
and crashes in rse.cpp because of rsb_count == 0 (in the last join).
Commits: 6729422 eecccbb
The text was updated successfully, but these errors were encountered: