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

Left join fails with SQLCODE = -508 [CORE94] #419

Closed
firebird-automations opened this issue Dec 20, 2001 · 14 comments
Closed

Left join fails with SQLCODE = -508 [CORE94] #419

firebird-automations opened this issue Dec 20, 2001 · 14 comments

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2006-05-17 22:26
Sender: dimitr
Logged In: YES
user_id=61270

Arno, you wanted an example :-)

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2005-07-10 01:35
Sender: seanleyne
Logged In: YES
user_id=71163

I notice that there is no criteria for the join to RDB$Database,
accordingly, is this in fact a valid statement?

(This is still a problem with early v2.0 alpha)

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 [ 10048 ]

SF_ID: 495339 =>

@firebird-automations
Copy link
Collaborator Author

Commented by: ramengo (ramengo)

This is still not resolved in 2.1 Beta 1.
Any chance to get it resolved in 2.1 Beta 2 ?

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

There are no plans to have it resolved in v2.1.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE1668 [ CORE1668 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10118 ] => Firebird [ 14307 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Arno Brinkman [ arnobrinkman ] => Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 3.0.0 [ 10048 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue relate to CORE2812 [ CORE2812 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

I'm closing this ticket as "Won't fix", because such joins should not work at all. CORE2812 becomes a replacement ticket.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Won't Fix [ 2 ]

@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
Projects
None yet
Development

No branches or pull requests

2 participants