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
Left join fails with SQLCODE = -508 [CORE94] #419
Comments
Commented by: Alice F. Bird (firebirds) Date: 2006-05-17 22:26 Arno, you wanted an example :-) |
Commented by: Alice F. Bird (firebirds) Date: 2005-07-10 01:35 I notice that there is no criteria for the join to RDB$Database, (This is still a problem with early v2.0 alpha) |
Commented by: ramengo (ramengo) This is still not resolved in 2.1 Beta 1. |
Commented by: @dyemanov There are no plans to have it resolved in v2.1. |
Modified by: @pcisarWorkflow: jira [ 10118 ] => Firebird [ 14307 ] |
Modified by: @dyemanovassignee: Arno Brinkman [ arnobrinkman ] => Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovFix Version: 3.0 Alpha 1 [ 10331 ] => |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: skopalik (skopalik)
Is duplicated by CORE1668
Relate to CORE2812
SFID: 495339#
Submitted By: skopalik
CREATE DATABASE "localhost:d:\ibdata\test.gdb"
USER "sysdba" PASSWORD "masterkey"
PAGE_SIZE 8192;
create table a(
id integer
);
insert into a values(1);
select *
from a B, rdb$database
left join a C on http://C.ID=B.ID;
This select produce:
Statement failed, SQLCODE = -508
no current record for fetch operation
rdb$database may be any table.
if You substitute left join to join result is OK.
This error founded at FB beta2, FB RC1 and IB5.6
The text was updated successfully, but these errors were encountered: