🚀 go-pugleaf

Hi,

What version of IB are you using? I recall a bug in earlier versions
that messed up the PLAN that IB returned.


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

>
>   I Have the following tables and view :
>
> CREATE TABLE TAB1
> (
>   COD INTEGER NOT NULL,
>   DESCR VARCHAR(10),
>   CODTAB INTEGER,
>   TYPETAB VARCHAR(1)
> );
>
> CREATE TABLE TAB2
> (
>   COD INTEGER NOT NULL,
>   DESCR VARCHAR(10)
> );
>
> CREATE TABLE TAB3
> (
>   COD INTEGER NOT NULL,
>   DESCR  VARCHAR(10)
> );
>
> CREATE VIEW V_TABS
> (
>   COD,
>   DESCR,
>   TYPETAB
> )
> AS
> SELECT
>   COD,
>   DESCR,
>   '2'
>   FROM
>     TAB2
>
> UNION
>
> SELECT
>   COD,
>   DESCR,
>   '3'
>   FROM
>     TAB3;
>
>
>   My problem happens when I try to run the following
> select :
>
> SELECT
>     TAB1.COD,
>     TAB1.DESCR,
>     TAB1.TYPETAB || ' - ' || V_TABS.DESCR
>   FROM
>     TAB1
>     LEFT OUTER JOIN V_TABS
>     ON (  (V_TABS.CODTAB = TAB1.CODTAB)
>         AND
>           (V_TABS.TYPETAB = TAB1.TYPETAB))
>
>   The select return the records I want but my plan analyser tool goes crazy
> and show a lot of unrecognized characters instead of the correct plan. Am I
> doing something wrong ? Can I trust that my select will always work ?
>
> Is there some problem using a VIEW based on a UNION of two SELECT's ? Is it
> safe ?
>
> Do you have some other idea ?
>
> Thanks for reading.
>
> Jose Carlos
> Brazil
>
>