Subject Re: View output differs from straight SELECT output
Author reinier_olislagers
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> > Firebird 2.5RC3 (Debian version) on Debian Squeeze
<snip>
> > I created a view with this SQL:
> > CREATE VIEW OKRESULTS (RUNID, OKCOUNT, OKPERCENTAGE)
<snip>
> > which gives output (in FlameRobin) like:
> > RUNID OKCOUNT OKPERCENTAGE
> > 8 5 [null]
> >
> > What am I doing wrong? Do I need to explicitly CAST the expression to
> > e.g. a float?
Hi Thomas,

Thanks.
> Looks a bit like:
> http://tracker.firebirdsql.org/browse/CORE-3141
Yes, it does... and it is fixed in FB embedded Windows 2.5.1
>
> Any reason why you are using a RC of 2.5.0?

It's the one distributed by Debian stable (6.0/Squeeze) - so it's a simple apt-get ;)
Looks like an upgrade may be a good idea ;)