>I have not reach a point of creating a "maximum possible ROWID", I'm
only at three rows. The behavior I was desiring is:
>
> If no ROWID is specified on the insert, an appropriate ROWID is
> created automatically. The usual algorithm is to give the newly
> created row a ROWID that is one larger than the largest ROWID in
the
> table prior to the insert.
Based on your previous example its doing exactly the behaviour
described.
Try
DELETE FROM abc WHERE ROWID='2';
INSERT INTO abc(c,p,t) VALUES('t5', 26, 't8');
SELECT * FROM abc;
I would expect 'masked' to be 1,3,4
********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
