Re: [Flamerobin-devel] [Flamerobin-checkins] SF.net SVN: flamerobin: [1271] trunk/flamerobin

[Milan B. <mi...@pa...>]

Hi Nando,

na...@us... wrote:
> Revision: 1271
>           http://svn.sourceforge.net/flamerobin/?rev=1271&view=rev
> Author:   nandod
> Date:     2007-02-07 08:41:26 -0800 (Wed, 07 Feb 2007)
> 
> Log Message:
> -----------
> * Show expression-based indexes in the Table Properties dialog.
> 
> ===================================================================
> --- trunk/flamerobin/src/metadata/table.cpp	2007-02-07 09:17:16 UTC (rev 1270)
> +++ trunk/flamerobin/src/metadata/table.cpp	2007-02-07 16:41:26 UTC (rev 1271)
> @@ -460,11 +460,11 @@
>          IBPP::Statement st1 = IBPP::StatementFactory(db, tr1);
>          st1->Prepare(
>              "SELECT i.rdb$index_name, i.rdb$unique_flag, i.rdb$index_inactive, "
> -            " i.rdb$index_type, i.rdb$statistics, s.rdb$field_name, "
> -            " rc.rdb$constraint_name"
> +            " i.rdb$index_type, i.rdb$statistics, "
> +			" s.rdb$field_name, rc.rdb$constraint_name, i.rdb$expression_source"
>              " from rdb$indices i"
> -            " join rdb$index_segments s on i.rdb$index_name = s.rdb$index_name"
> -            " left outer join rdb$relation_constraints rc "
> +            " left join rdb$index_segments s on i.rdb$index_name = s.rdb$index_name"
> +            " left join rdb$relation_constraints rc "

What is the reason to change this JOIN on rdb$index_segments to LEFT JOIN ?

-- 
Milan Babuskov
http://www.guacosoft.com
http://www.flamerobin.org