Subject Re: [ib-support] views unreliable?
Author Rob Schuff
thanks claudio.


Robert Schuff Bull Run Software
rob@... Portland, OR USA
----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
Newsgroups: egroups.ib-support
To: <>
Sent: Thursday, December 06, 2001 11:00 PM
Subject: Re: [ib-support] views unreliable?

> ""Rob Schuff"" <rob@...> wrote in message
> news:002501c17e7f$0b0507f0$0401a8c0@picard...
> > hi folks,
> >
> > I have seen some disturbing opinions/observations on the atkin group
> > sourceforge.firebird-devel regarding views.
> We are like a living room as seen in a TV series... everyone can watch for
> free, at any time the show is running.
> > it seems that some people on
> > that group have the opinion that views are far too buggy and should not
> > used. Can someone please comment on this? I have have using views with
> > triggers for quite a while and have not found any issues yet.
> Views are VERY BUGGY. No joke. And we inherited those bugs from the
> company. Just search our bug tracker and you will find at least 10 serious
> issues. As it's not enough, Dmitry Kuzmenko logged two more today. The
> serious one I remember I fixed (shown among closed bugs) is that one that
> came "only" from IB4: joins of views using indices in the underlying
> kill the engine at prepare time, no need to run the query. Several of
> bugs come from 1994 and never were fixed.
> I use views in my applications. If I happen to run in one of the bugs, I
> will find a way to restructure my SQL view so it doesn't fail. It's like
> running near the nest of very aggressive bees.
> > I ran into this wehen I was searching for the rowsaffected problem on
> views
> > with triggers. I wanted to see if this bug was going to be addressed in
> > RC2, but it does not appear to be the case, which leaves me at v0.94 i
> > guess.
> It was fixed according to Ann suggestions. If someone's still not happy
> the new "virtual behavior" for views, please take the sources and branch a
> new fork of the original product. Questions about the philosophical
> foundation for the new behavior can be sent to Jason Wharton. <g> I think
> will copy/paste one of his letters to explain you. You get the activity on
> the view, not on the underlying tables.
> The bottom line is that the behavior is different than IB6.
> C.
> --
> Claudio Valderrama C. - -
> Independent developer
> Owner of the Interbase® WebRing
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to