List:Internals« Previous MessageNext Message »
From:sasha Date:July 13 2001 11:25pm
Subject:bk commit into 3.23 tree
View as plain text  
Below is the list of changes that have just been commited into a local
3.23. repository of sasha. When sasha does a push, they will be
propogaged to the main repository and within 24 hours after the push into
the public repository. For information on how to access
the public repository see
http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet@stripped, 2001-07-13 17:25:37-06:00, sasha@stripped
  test case for low priority updates race bug
  not yet fixed

  mysql-test/r/lock.result
    1.3 01/07/13 17:25:33 sasha@stripped +2 -0
    updated result

  mysql-test/t/lock.test
    1.3 01/07/13 17:25:33 sasha@stripped +22 -0
    test case for low prior updates bug

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	sasha
# Host:	mysql.sashanet.com
# Root:	/home/sasha/src/bk/mysql

--- 1.2/mysql-test/r/lock.result	Wed Apr 18 14:47:10 2001
+++ 1.3/mysql-test/r/lock.result	Fri Jul 13 17:25:33 2001
@@ -4,3 +4,5 @@
 test.t1	check	status	OK
 Table	Op	Msg_type	Msg_text
 test.t2	check	error	Table 't2' was not locked with LOCK TABLES
+n
+1

--- 1.2/mysql-test/t/lock.test	Wed Apr 18 14:47:10 2001
+++ 1.3/mysql-test/t/lock.test	Fri Jul 13 17:25:33 2001
@@ -53,3 +53,25 @@
 check table t2;
 unlock tables;
 drop table t1,t2;
+
+#test to see if select will get the lock ahead of low priority update
+connect (locker,localhost,root,,);
+connect (reader,localhost,root,,);
+connect (writer,localhost,root,,);
+
+connection locker;
+create table t1(n int);
+insert into t1 values (1);
+lock tables t1 write;
+connection writer;
+send update low_priority t1 set n = 4;
+connection reader;
+send select n from t1;
+connection locker;
+unlock tables;
+connection writer;
+reap;
+connection reader;
+reap;
+drop table t1;
+
Thread
bk commit into 3.23 treesasha14 Jul