Subject | Re: View output differs from straight SELECT output |
---|---|
Author | reinier_olislagers |
Post date | 2012-10-23T13:26:19Z |
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
Thanks.
Looks like an upgrade may be a good idea ;)
><snip>
> > Firebird 2.5RC3 (Debian version) on Debian Squeeze
> > I created a view with this SQL:<snip>
> > CREATE VIEW OKRESULTS (RUNID, OKCOUNT, OKPERCENTAGE)
> > which gives output (in FlameRobin) like:Hi Thomas,
> > RUNID OKCOUNT OKPERCENTAGE
> > 8 5 [null]
> >
> > What am I doing wrong? Do I need to explicitly CAST the expression to
> > e.g. a float?
Thanks.
> Looks a bit like:Yes, it does... and it is fixed in FB embedded Windows 2.5.1
> http://tracker.firebirdsql.org/browse/CORE-3141
>It's the one distributed by Debian stable (6.0/Squeeze) - so it's a simple apt-get ;)
> Any reason why you are using a RC of 2.5.0?
Looks like an upgrade may be a good idea ;)