QualityCentral

Public Report

Report From: InterBase/Server/Internal [ Add a report in this area ]

Report #: 47602

Status: Closed

(Pulled) Query with many joins returns "size of optimizer block exceeded" Statement failed, SQLCODE = -904 size of optimizer block

Project: InterBase

Build #:

Version: 8.0

Submitted By: QC<->Raid Replicator Account

Report Type: Minor failure / Design problem

Date Reported: 6/1/2007 12:00:00 AM

Severity: Infrequently encountered problem

Last Updated: 7/10/2008 9:10:30 PM

Platform: Not OS or platform specific

Internal Tracking #: 251265

Resolution: Fixed (Resolution Comments)

Resolved in Build: : 8.1.0.257

Duplicate of: None

Voting and Rating

Overall Rating: No Ratings Yet

0.00 out of 5

Total Votes: None

Description

Query with many joins returns "size of optimizer block exceeded"

Statement failed, SQLCODE = -904

size of optimizer block exceeded

Steps to Reproduce:

create table test
(a1 int,a2 int,a3 int,a4 int,a5 int,a6 int,a7 int,a8 int,a9 int,a10 int,
a11 int,a12 int,a13 int,a14 int,a15 int,a16 int,a17 int,a18 int,a19 int,
a20 int,a21 int,a22 int,a23 int,a24 int,a25 int,a26 int,a27 int,a28 int,a29 int);
select m.* from test m
join rdb$database r1 on r1.rdb$relation_id = m.a1
join rdb$database r2 on r2.rdb$relation_id = m.a2
join rdb$database r3 on r3.rdb$relation_id = m.a3
join rdb$database r4 on r3.rdb$relation_id = m.a4
join rdb$database r5 on r3.rdb$relation_id = m.a5
join rdb$database r6 on r3.rdb$relation_id = m.a6
join rdb$database r7 on r3.rdb$relation_id = m.a7
join rdb$database r8 on r3.rdb$relation_id = m.a8
join rdb$database r9 on r3.rdb$relation_id = m.a9
join rdb$database r10 on r3.rdb$relation_id = m.a10
join rdb$database r11 on r3.rdb$relation_id = m.a11
join rdb$database r12 on r3.rdb$relation_id = m.a12
join rdb$database r13 on r3.rdb$relation_id = m.a13
join rdb$database r14 on r3.rdb$relation_id = m.a14
join rdb$database r15 on r3.rdb$relation_id = m.a15
join rdb$database r16 on r3.rdb$relation_id = m.a16
join rdb$database r17 on r3.rdb$relation_id = m.a17
join rdb$database r18 on r3.rdb$relation_id = m.a18
join rdb$database r19 on r3.rdb$relation_id = m.a19
join rdb$database r20 on r3.rdb$relation_id = m.a20
join rdb$database r21 on r3.rdb$relation_id = m.a21
join rdb$database r22 on r3.rdb$relation_id = m.a22
join rdb$database r23 on r3.rdb$relation_id = m.a23
join rdb$database r24 on r3.rdb$relation_id = m.a24
join rdb$database r25 on r3.rdb$relation_id = m.a25
join rdb$database r26 on r3.rdb$relation_id = m.a26
join rdb$database r27 on r3.rdb$relation_id = m.a27
join rdb$database r28 on r3.rdb$relation_id = m.a28
join rdb$database r29 on r3.rdb$relation_id = m.a29;

Workarounds

None

Attachment

Comments

None

Quality Central

Developer Tools

Database Tools