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

Jump to bottom

Bad optimization -- <procedure> left join <subquery> (or <view>) [CORE1130] #1552

Closed
firebird-automations opened this issue Feb 15, 2007 · 12 comments
Closed

Bad optimization -- <procedure> left join <subquery> (or <view>) [CORE1130] #1552

firebird-automations opened this issue Feb 15, 2007 · 12 comments
Assignees
@dyemanov
Labels
affect-version: 1.5.0 affect-version: 1.5.1 affect-version: 1.5.2 affect-version: 1.5.3 affect-version: 2.0.0 component: engine fix-version: 2.0.1 fix-version: 2.1 Alpha 1 priority: major qa: done successfully type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @dyemanov

Is related to QA83

create procedure p
returns (r int)
as
begin
r = 1;
suspend;
end

select *
from p
left join ( select rdb$relation_id from rdb$relations ) r
on p.r = r.rdb$relation_id

Index on the inner stream (rdb$relations) is not used.

Commits: 5abc11d 02035b1
@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.0.1 [ 10090 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pmakowski

Q/A tested ok
and Q/A test made

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Reopened to update ticket information.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Reopened [ 4 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA83 [ QA83 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11600 ] => Firebird [ 15298 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test => Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@dyemanov dyemanov

Labels
affect-version: 1.5.0 affect-version: 1.5.1 affect-version: 1.5.2 affect-version: 1.5.3 affect-version: 2.0.0 component: engine fix-version: 2.0.1 fix-version: 2.1 Alpha 1 priority: major qa: done successfully type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@dyemanov @firebird-automations