Hi *,
(similar message I posted already in Firegird-general, but it seems, that this
list is not so active)
As a example I have select like:
SELECT col1, col2,
(select sum(col3) from table2 where col1=a.col1 and col2=a.col2) as col3
FROM table1 a;
In this case query PLAN is like:
PLAN (table2
Thanks Dmitry for reply.
Backporting optimization from 2.5 to 2.1 would be a big work ?
L.
> >
> > I guess, that it is because COALESCE is internaly transformed into CASE
> > WHEN IS NULL then 0 else end
> > So in expression is subselect twice.
>
> Correct.
>
> > My question is if is really e
> > Thanks Dmitry for reply.
> > Backporting optimization from 2.5 to 2.1 would be a big work ?
>
> Yes, it would be highly undesirable.
>
I understand. Thanks.
Is there any smart workaround ?
My situation is as follows:
I have view, where are columns like:
coalesce(, 0) as col3,
coalesce(, 0)
Hi *,
I encounter problem with following statements when working with Firebird ODBC
driver:
(if this is not right place where ask such question please let me know)
1. I prepare statement with SQLPrepare. Statement is like:
'insert into mytable values(?)'
(table mytable has one BLOB column)