Re: GET DIAGNOSTICS (was Re: Open 7.1 items)

> >>     GET DIAGNOSTICS :c = OID;
> >
> >It looks to me like SQL99 allows
> >
> >    GET DIAGNOSTICS :a = ROW_COUNT, :b = OID, ...;
> 
> Yes, but condition information (eg. SPI RESULT or SQLCODE), needs a
> separate statement to row information (eg. ROW_COUNT). ie.
> 
>      GET DIAGNOSTICS :a = ROW_COUNT, :c = OID;
>      GET DIAGNOSTICS EXCEPTION 1 :b = SQLCODE;
> 
> but it's not much of a problem, really. And I agree the 'x = y' syntax is
> better.
> 
> Unfortunately, I don't have an awful lot of free time at the moment, so I
> won't be able to look at this for at *least* as week.

Well, this clearly is a release-stopper because we don't want to release
a non-standard GET DIAGNOSTICS.  It will be fixed before 7.1 final by
someone.  I have added it to the open items list.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026