Re: [osdldbt-general] TradeCleanupFrame1 bug

[<ma...@gm...>]

Ok, I've check in the changes.

Mark

On 1/27/07, Rilson Nascimento <ril...@gm...> wrote:
> Hi Mark,
>
> Yeah, this seems to be better.
>
> thanks,
>
> -Rilson
>
>
> On 1/27/07, ma...@gm... < ma...@gm...> wrote:
> > On 1/22/07, Rilson Nascimento < ril...@gm...> wrote:
> > > Hi Mark,
> > >
> > > I have reproduced the error with TradeCleanup. It seems that the bug
> > > is caused by the TRADE_T domain, which was created with a NOT NULL
> > > clause. Two variables in TradeCleanupFrame1 use this TRADE_T domain as
> > > type (trade_id and tr_trade_id)
> > >
> > > Sometimes the cursor opened in tradecleanupframe1 function might have
> > > no rows. So, at the fetch operation, the cursor will return NULL to
> > > the TRADE_T variables, which will trigger their NOT NULL constraints.
> > >
> > > A possible solution is to change the type of these two variables from
> > > TRADE_T to BIGINT.
> >
> > Hi Rilson,
> >
> > This is actually happening in more than one spot for me.  Do you think
> > it's better to create the DOMAINS so that they can be NULL, rather
> > than than each individual location to use BIGINT or whatever the
> > DOMAIN is set to?
> >
> > Regards,
> > Mark
> >
>
>