Hi,

> "Martijn Tonies" <martijn@...> wrote in message
> news:C1FE56B5C29FD211A99F00A0244BE8200961A0@SRV_BISIT...
> > Sorry, forgot to mention: FB 1, RC2
> >
> >
> > Hi all,
> >
> > Does someone (before I start posting lots of stuff) have any idea why
> taking
> > the view source and running that (with UNION and all) runs just fine

while

> > select * from the view results in a string truncation error?
>
> No at first glance, but if you can isolate the bug with the minimum number
> of columns possible, I will take a peek. Does IB65 have the same issue? If
> not, it's one of our changes.
> The nearest error I know is the
> conversion from string " "
> that appears in some cases while joining views and using group's and the
> like. I changed it to show the source field's value, not the target

field's

> value (the error msg was totally misleading), but the bug itself still
> exists.
>

Well, the problems starts happening as I restore a backup from IB6 to
Firebird 1, RC2. I think you can still download the database backup
from bp.attachements (the one that I posted the PLAN thing about)...

Without data, it doesn't have the problem (just restored a DDL backup
at Firebird 1, RC2...

I'll have to create a backup Tuesday with data (was a bit too large last
week)...

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."