Hi,

I noticed something strange here...

We have a database where we changed the default collation of the ISO charset
(don't know if that has anything to do with it though).

If I backup this database and restore it, it will give 'string truncation
... arithmic error ...' - the usual :) - when selecting from a couple of
views. When we re-create the views, everything works fine.

I cannot find any info about collations/charsets for views in RDB$FIELDS and
RDB$RELATION_FIELDS. Does anyone know why this fails? This happens on both
Firebird RC2 and IB 6.0.something

I can post a zipped backup to borland.public.attachments if you like - I
shrinked the database to something small.

--
Martijn Tonies
Upscene Productions

InterBase Workbench - The Developer Tool for InterBase
http://www.interbaseworkbench.com

"Experience is what you get when you didn't get what you wanted"

> > 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)...