[Firebird-devel] [ firebird-Bugs-1266013 ] fbserver can't perform view data

[SourceForge.net <no...@so...>]

Bugs item #1266013, was opened at 2005-08-22 11:57
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1266013&group_id=9028

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Java Client (JayBird)
Group: Initial Bug
Status: Open
Resolution: None
Priority: 5
Submitted By: core (corewithin)
Assigned to: Nobody/Anonymous (nobody)
Summary: fbserver can't perform view data

Initial Comment:
I'm using 
Firebird-1.5.2.4731-Win32 + FirebirdSQL-1.5.5JDK_1.4. 

I have a table with 10000 rows (T1) a table with
(100000) rows (T2), and 3 small views (VWS).

Using this i'm going to create some new views:

NEWVIEW = T1 'JOIN' VWS;
And it successfully performed.

Next, NEWVIEW2 = NEWVIEW 'JOIN' T2.

NEWVIEW2 consists of all column from NEWVIEW and 2 SUM
columns from T2. 

Explane:
CREATE VIEW NEWVIEW2
AS
SELECT ..., SUM(T2.f1), SUM(T2.f2)
FROM T2 RIGHT JOIN NEWVIEW ON ...
GROUP BY ...

This view successfully compliled, but trying to perform
data using 100% CPU time and go on above soo many
times. I'm can't wait until the end of operation...

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1266013&group_id=9028