Subject | Crash from view and stored proc. |
---|---|
Author | todd_pinel |
Post date | 2004-08-27T19:09:09Z |
I've read in the release notes of FB1.5.1 under Language Bugs
fixed that "Server would crash when views and selectable procedures
were intermixed". I realize this is for v1.5.1, and I am using
1.03, but I wanted to know if anyone knows if this was also an issue
in 1.03. Even better would be to let me know if I'm abusing SQL by
creating a view similar to this
CREATE VIEW VW_BUYERSELECT(
BUYER_NO,
BUYERNAME,
PHONENUMBER
)
AS
SELECT B.BUYER_NO, B.BUYERNAME, AD.PHONE
FROM BUYER B, ADDRESS AD
WHERE B.BUYER_NO = AD.BUYER_NO
AND AD.ADDRESS_NO = (SELECT NEW_ADDRESS_NO
FROM SP_GETCURRENTADDRESS(B.BUYER_NO, 'NOW'))
;
As you can see I'm mixing a selectable sp within a view, the part
I'm really sketchy on is if referencing the Buyer table as one of my
input params to the sp is perhaps too abusive? This code has
been "working" for months but I've had my server randomly crash a
few times earlier this week, still trying to nail down the cause but
I am looking to rule some things out along the way here. Thanks in
advance, Todd.
fixed that "Server would crash when views and selectable procedures
were intermixed". I realize this is for v1.5.1, and I am using
1.03, but I wanted to know if anyone knows if this was also an issue
in 1.03. Even better would be to let me know if I'm abusing SQL by
creating a view similar to this
CREATE VIEW VW_BUYERSELECT(
BUYER_NO,
BUYERNAME,
PHONENUMBER
)
AS
SELECT B.BUYER_NO, B.BUYERNAME, AD.PHONE
FROM BUYER B, ADDRESS AD
WHERE B.BUYER_NO = AD.BUYER_NO
AND AD.ADDRESS_NO = (SELECT NEW_ADDRESS_NO
FROM SP_GETCURRENTADDRESS(B.BUYER_NO, 'NOW'))
;
As you can see I'm mixing a selectable sp within a view, the part
I'm really sketchy on is if referencing the Buyer table as one of my
input params to the sp is perhaps too abusive? This code has
been "working" for months but I've had my server randomly crash a
few times earlier this week, still trying to nail down the cause but
I am looking to rule some things out along the way here. Thanks in
advance, Todd.