LOCK TABLE bug

forum.gupta.bugreport (2005-2010)
FRBhote
India
Posts: 2208
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

LOCK TABLE bug

Post by FRBhote » 14 Nov 2007, 11:07

 Posted by:  F R Bhote 

When an update statement is issued on a date field, another session is
allowed to lock that same table (BADLOCK.JPG), but when a similar update
statement is issued on a numeric field, the lock table times out
(GOODLOCK.JPG).



You do not have the required permissions to view the files attached to this post.

Mike Vandine

Re: LOCK TABLE bug

Post by Mike Vandine » 14 Nov 2007, 15:27

 Posted by:  Mike Vandine 

What is the structure of the s_id table? Is the s_id_no a unique key?

FRBhote
India
Posts: 2208
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: LOCK TABLE bug

Post by FRBhote » 15 Nov 2007, 06:17

 Posted by:  F R Bhote 

The S_ID table was attached.

CREATE INDEX SYSADM.XSID ON SYSADM.S_ID(
S_ID_DATE)
/

Return to “gupta.bugreport”

Who is online

Users browsing this forum: [Ccbot] and 0 guests