Subject | RE: [firebird-support] Subselects |
---|---|
Author | Bogdan Mugerli |
Post date | 2004-03-16T12:59:57Z |
HI
a. Procedure (and not just one like this) was running smoothly for months.
b. as i recall, this problem gets on agenda every few months.
Regards
Bogdan
-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Tuesday, March 16, 2004 1:56 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Subselects
Hi,
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
Yahoo! Groups Links
a. Procedure (and not just one like this) was running smoothly for months.
b. as i recall, this problem gets on agenda every few months.
Regards
Bogdan
-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Tuesday, March 16, 2004 1:56 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Subselects
Hi,
> I wonder if the occasional problems with subselects are resolved in FB1.5??
>Did you modify the procedure prior to executing it?
> Here is the excerpt from our procedure:
>
> SELECT VALID_FROM, PRICE FROM MATERIALCENA
> WHERE MATERIALid = :IMATERIALID AND VALID_FROM =
> (select max(MC.VALID_FROM from materialcena mc where mc.materialid =
> :imaterialid and mc.VALID_FROM <= 'today')
> INTO :VALID_FROM, :PRICE;
>
> Suddenly subselect didn't return max(valid_from)
>
> After we restarted the server, the results are ok again
> PS.: this problem should have been solved years agoFeel free to help, instead of complain.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
Yahoo! Groups Links