svn commit: r783088 [1/3] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/updatelocks.out suites/storemats.runall

[mi...@apache.org]

Author: mikem
Date: Tue Jun  9 18:18:28 2009
New Revision: 783088

URL: http://svn.apache.org/viewvc?rev=783088&view=rev
Log:
DERBY-4047

updating the master and adding the test to be run as part of the storemats
suite.  I have checked the diffs with the neglected master and found them
all to be ok.

I hand checked the diffs and found the following 3 family of diffs to be
acceptable:
o a bunch with the new ij header
o trunk and 10.5 does not have scan locks, so no longer will get any row locks
of the form (N, 1)
o the following kind of diff comes from inlist optimization, now a set of
OR's can do multiple index probes and thus only the affected rows are
locked.  The exact number and name of the rows depends on the type of
index and the padding of the row.
> -- Very basic single user testing of update locks.  This ".subsql" test is
3417,3418d3521
< APP     |UserTran|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE
< APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE
3634,3638d3736
< APP     |UserTran|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE
< APP     |UserTran|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE
< APP     |UserTran|ROW     |1   |X   |A           |(1,12)    |GRANT|ACTIVE
< APP     |UserTran|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE
< APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE

delete from a where a = 2 or a = 4 or a = 6;
2 rows inserted/updated/deleted
ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS
---------------------------------------------------------------------------
APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE
APP     |UserTran|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE
APP     |UserTran|ROW     |2   |X   |A           |(1,12)    |GRANT|ACTIVE
APP     |UserTran|ROW     |2   |X   |A           |(1,8)     |GRANT|ACTIVE


Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocks.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/storemats.runall