Giving a try to the new Firebird 2.0 rc3 (may be definitive version)
I recreate some databases to import data and check new improve in
speed... BUT!

Creating a computed field (that work fine in 1.5.3) give an error in 2.0

this is...

/**********************************/

ALTER TABLE S1 ADD BASE COMPUTED BY (
cast(
coalesce(
(select sum(cast(s2.cantidad*s2.Precio as numeric(14,4))
*cast((1.0-s2.dto/100)*(1.0-s1.dto/100) as numeric(6,5)))
from s2
where a1.id = s2.id)
,0)
as numeric(14,2)));

/**********************************/

any idea? what is erroneous? I read some about changes, and not read
about "new limitations" (only improves)


any workaround? trick? solution?

Tks

Alejandro