Thread

  1. Changes to sequence.c

    bill.allie@mug.org — 1998-03-02T06:16:24Z

    I encountered a problem (bug? feature?) where "select currval('sequence')" 
    will generate an error if "select nextval('sequence')" is not executed first.  
    The attached patch will change this behaviour by reading the sequence tuple 
    and returning the last_value attribute if nextval has not been called on the 
    sequence yet.
    
    The patched code appears to work as intended and did not have any effect on 
    the output of the regression test.
    
  2. Re: [PATCHES] Changes to sequence.c

    Vadim Mikheev <vadim@sable.krasnoyarsk.su> — 1998-03-02T07:55:47Z

    Billy G. Allie wrote:
    > 
    > I encountered a problem (bug? feature?) where "select currval('sequence')"
    > will generate an error if "select nextval('sequence')" is not executed first.
    > The attached patch will change this behaviour by reading the sequence tuple
    > and returning the last_value attribute if nextval has not been called on the
    > sequence yet.
    
    This is feature :)
    1. This is what Oracle does.
    2. currval () is described as returning value returned by
       last nextval() in _session_.
    
    Vadim