Thread
-
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. -
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