QualityCentral

Public Report

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

Report #: 44565

Status: Closed

optimizer block exceeded

Project: InterBase

Build #: 7.5.1.162

Version: 8.0

Submitted By: Alessandro Cipriano

Report Type: Issue

Date Reported: 4/17/2007 9:36:12 AM

Severity: Critical / Show Stopper

Last Updated: 4/24/2008 2:06:00 PM

Platform: 95, 98, 2000, NT, XP

Internal Tracking #: 251608

Resolution: Fixed (Resolution Comments)

Resolved in Build: : 9.0

Duplicate of: None

Voting and Rating

Overall Rating: No Ratings Yet

0.00 out of 5

Total Votes: None

Description

when I try to execute following query:
select idx_fascicolo,idx_contratto,idx_contranno,idx_unarc,data_scadenza,data_modifica,fascicolo_stato,idx_scatola,idx_tipologia,t1.idx_dettendina idx_tendina1,t2.idx_dettendina idx_tendina2,t3.idx_dettendina idx_tendina3,data,idx_utente1,idx_utente2,note,idx_unarcold,idx_unarc idx_unarcnew
from tab_fascicoli tf
inner join tab_campi c1 on (tf.idx_unarc = c1.idx_unarc) and (c1.idx_campo = 1172)
inner join tab_campi c2 on (tf.idx_unarc = c2.idx_unarc) and (c2.idx_campo = 1174)
inner join tab_campi c3 on (tf.idx_unarc = c3.idx_unarc) and (c3.idx_campo = 1175)
inner join tab_campi c4 on (tf.idx_unarc = c4.idx_unarc) and (c4.idx_campo = 1176)
inner join tab_campi c5 on (tf.idx_unarc = c5.idx_unarc) and (c5.idx_campo = 1177)
inner join tab_campi c6 on (tf.idx_unarc = c6.idx_unarc) and (c6.idx_campo = 1178)
inner join tab_campi c7 on (tf.idx_unarc = c7.idx_unarc) and (c7.idx_campo = 1179)
inner join tab_campi c8 on (tf.idx_unarc = c8.idx_unarc) and (c8.idx_campo = 1190)
inner join tab_campi c9 on (tf.idx_unarc = c9.idx_unarc) and (c9.idx_campo = 1191)
inner join tab_campi c10 on (tf.idx_unarc = c10.idx_unarc) and (c10.idx_campo = 1210)
inner join tab_campi c11 on (tf.idx_unarc = c11.idx_unarc) and (c11.idx_campo = 1251)
inner join tab_campi c12 on (tf.idx_unarc = c12.idx_unarc) and (c12.idx_campo = 1252)
inner join tab_campi c13 on (tf.idx_unarc = c13.idx_unarc) and (c13.idx_campo = 1253)
inner join tab_campi c14 on (tf.idx_unarc = c14.idx_unarc) and (c14.idx_campo = 1259)
inner join tab_campi c15 on (tf.idx_unarc = c15.idx_unarc) and (c15.idx_campo = 1260)
inner join tab_campi c16 on (tf.idx_unarc = c16.idx_unarc) and (c16.idx_campo = 1266)
inner join tab_campi c17 on (tf.idx_unarc = c17.idx_unarc) and (c17.idx_campo = 1267)
inner join tab_campi c18 on (tf.idx_unarc = c18.idx_unarc) and (c18.idx_campo = 1291)
inner join tab_campi c19 on (tf.idx_unarc = c19.idx_unarc) and (c19.idx_campo = 1292)
inner join tab_campi c20 on (tf.idx_unarc = c20.idx_unarc) and (c20.idx_campo = 1295)
inner join tab_campi c21 on (tf.idx_unarc = c21.idx_unarc) and (c21.idx_campo = 1300)
inner join tab_unarc v on v.idx_unarc = tf.idx_unarc
join tab_valtendine t1 on v.idx_unarc = t1.idx_unarc and t1.idx_testendina = 1
join tab_valtendine t2 on v.idx_unarc = t2.idx_unarc and t2.idx_testendina = 2
join tab_valtendine t3 on v.idx_unarc = t3.idx_unarc and t3.idx_testendina = 3
where (v.idx_contratto = :idx_contratto) and (v.idx_contranno = :idx_contranno) order by idx_fascicolo

error "optimizer block exceeded" appears.

Where is the problem?

Steps to Reproduce:

None

Workarounds

None

Attachment

None

Comments

None

Quality Central

Developer Tools

Database Tools