Subject Re: [firebird-support] Invalid BLR - BAD BLR - Help
Author Kurt Schneider
Post date 2006-03-03T18:05:36Z
Hello Rick

The select * from view return a Adapted Plan, not visible an IBExpert, or
EMS Manager ou IBPlanAnalize

But, the select used for create the view VW_ESPRODUTO return the
PLAN_View.txt.

Same retired the INNER from the JOIN, the database is shutdown (error).

Thanks....



On 3/3/06, Rick Debay <rdebay@...> wrote:
>
> What plan does your query produce? What plan do you see when you SELECT
> * from your view?
> FWIW, drop the keyword INNER. A JOIN is be default INNER. It probably
> won't help you, it's just a pet peeve of mine ;-)
>
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Kurt Schneider
> Sent: Friday, March 03, 2006 12:22 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Invalid BLR - BAD BLR - Help
>
> Hello Rick
>
> Thanks for the Tip. Exactly thus, the problem persists. It sees the
> SQL_Problem_Short.txt Example in attach. I reduced the tables name and
> the
> size of the SQL. Still thus, the problem continues. We go the search
> of
> the solution. ;-)
>
> PS: The same act was executed in View (reduce the tables names).
>
> Thanks.
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw> Computer
> technical support<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA> Compaq
> computer technical support<http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjEqA6g> Compaq
> technical support<http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w> Hewlett
> packard technical support<http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfmvLcA> Microsoft
> technical support<http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "firebird-support<http://groups.yahoo.com/group/firebird-support>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com<firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>



--
************************************************************************************
Kurt Schneider - [ Analista de Sistema ]
Especialista em Analise e Desenvolvimento de Software
ControlSoft - Assessoria e Desenvolvimento de Sistemas
e-mail: kjundia@...
"Quis custodiet ipsos custodes?" - SatirĂ¡s - De Juvenal

----------

Plan
PLAN SORT (JOIN (JOIN (TB_PEDIDOS INDEX (FK_TB_PEDID_R_10043_TB_ORIGE,FK_TB_PEDID_R_10019_TB_OPERE,FK_TB_PEDID_R_10008_TB_TIPOP),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10021_TB_PEDID)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10031_TB_PRODU)))
PLAN SORT (JOIN (JOIN (TB_PEDIDOS INDEX (FK_TB_PEDID_R_10043_TB_ORIGE,FK_TB_PEDID_R_10019_TB_OPERE,FK_TB_PEDID_R_10008_TB_TIPOP),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10021_TB_PEDID)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10031_TB_PRODU)))
PLAN SORT (JOIN (JOIN (TB_PEDIDOS INDEX (FK_TB_PEDID_R_10043_TB_ORIGE,FK_TB_PEDID_R_10019_TB_OPERE,FK_TB_PEDID_R_10008_TB_TIPOP),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10021_TB_PEDID)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10031_TB_PRODU)))
PLAN SORT (JOIN (JOIN (TB_PEDIDOS INDEX (FK_TB_PEDID_R_10043_TB_ORIGE,FK_TB_PEDID_R_10019_TB_OPERE,FK_TB_PEDID_R_10008_TB_TIPOP),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10021_TB_PEDID)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10031_TB_PRODU)))
PLAN SORT (JOIN (JOIN (TB_NOTAFISCAL INDEX (FK_TB_NOTAF_R_1879_TB_OPERE),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10040_TB_NOTAF)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10030_TB_PRODU)))
PLAN SORT (JOIN (JOIN (TB_NOTAFISCAL INDEX (FK_TB_NOTAF_R_1879_TB_OPERE),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10040_TB_NOTAF)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10030_TB_PRODU)))

Adapted Plan
PLAN SORT (JOIN (JOIN (TB_PEDIDOS INDEX (FK_TB_PEDID_R_10043_TB_ORIGE,FK_TB_PEDID_R_10019_TB_OPERE,FK_TB_PEDID_R_10008_TB_TIPOP),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10021_TB_PEDID)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10031_TB_PRODU))) PLAN SORT (JOIN (JOIN (TB_PEDIDOS INDEX (FK_TB_PEDID_R_10043_TB_ORIGE,FK_TB_PEDID_R_10019_TB_OPERE,FK_TB_PEDID_R_10008_TB_TIPOP),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10021_TB_PEDID)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10031_TB_PRODU))) PLAN SORT (JOIN (JOIN (TB_PEDIDOS INDEX (FK_TB_PEDID_R_10043_TB_ORIGE,FK_TB_PEDID_R_10019_TB_OPERE,FK_TB_PEDID_R_10008_TB_TIPOP),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10021_TB_PEDID)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10031_TB_PRODU))) PLAN SORT (JOIN (JOIN (TB_PEDIDOS INDEX (FK_TB_PEDID_R_10043_TB_ORIGE,FK_TB_PEDID_R_10019_TB_OPERE,FK_TB_PEDID_R_10008_TB_TIPOP),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10021_TB_PEDID)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10031_TB_PRODU))) PLAN SORT (JOIN (JOIN (TB_NOTAFISCAL INDEX (FK_TB_NOTAF_R_1879_TB_OPERE),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10040_TB_NOTAF)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10030_TB_PRODU))) PLAN SORT (JOIN (JOIN (TB_NOTAFISCAL INDEX (FK_TB_NOTAF_R_1879_TB_OPERE),TB_CFOP INDEX (PK_TB_CFOP),TB_LIGCFOP INDEX (PK_TB_LIGCFOP),TB_PRODUTOSMOV INDEX (FK_TB_PRODU_R_10040_TB_NOTAF)),TB_LIGFATURAS INDEX (FK_TB_LIGFA_R_10030_TB_PRODU)))



[Non-text portions of this message have been removed]