2
# Test to verify updates from SELECT FOR UPDATE are handled
3
# properly, an update is not put in the log for a update that
8
DROP TABLE IF EXISTS t1;
13
, padding VARCHAR(200) NOT NULL
17
INSERT INTO t1 VALUES (1, "I love testing.");
18
INSERT INTO t1 VALUES (3, "I hate testing.");
19
INSERT INTO t1 VALUES (5, "I still hate testing.");
21
connect (conn1, localhost, root,,);
22
connect (conn2, localhost, root,,);
26
SELECT id FROM t1 FOR UPDATE;
29
# This should timeout and not appear in the transaction log
30
--error ER_LOCK_WAIT_TIMEOUT
31
UPDATE t1 SET id=1000 WHERE padding='I love testing.';
34
UPDATE t1 SET id=id + 1;