Re: Error -246
In article g0e@emory.mathcs.emory.edu, jmathwig@STL-03SIMA.ARMY.MIL (Jim Mathwig) writes:
>Hi All,
>
>Need assistance with this row vs. table locking issue!
>
>When executing the following query:
>
>"SELECT rowid, * from table_name WHERE rowid = 425 FOR UPDATE"
>
>another user get an error -246, when attempting to update another record
>from this same table.
>
>Thanx in advance!
>
>============================================================================
>jmathwig@stl-03sima.army.mil (Jim Mathwig)
>ITT - Fderal Services Corp. 805-928-4371
>Santa Maria, Cal.
>============================================================================
I sa this exact same error on Version 5.0 for Sun -> Compiled 4GL!
It was a known bug (actually after we reported it it was a known bug).
The other famous bug I saw on the same version was the following:
Insert into table values (1)
insert into table values (2).
.
.
insert into table values (500)
That statement 500 times with a one column (or many columns it did not
matter) in succession. The 257th row would get a "1" in it, 258th row
got a "2" in it (are you getting the pciture). If you have a unique index
on the column, it blew on the 257th insert.
Stuart