~tsarev/percona-server/fix_bug_719386

« back to all changes in this revision

Viewing changes to mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result

  • Committer: Oleg Tsarev
  • Date: 2011-06-21 17:12:05 UTC
  • mfrom: (235.1.1 innodb_deadlock)
  • Revision ID: oleg.tsarev@percona.com-20110621171205-f4lh3kn44qnatmbh
Move tests from mysql-test/ to mysql-test/innodb_deadlock_count.patch according to bug #788569
Now test explicit return "ERROR 40001: Deadlock found when trying to get lock; try restarting transaction"

Show diffs side-by-side

added added

removed removed

Lines of Context:
22
22
SELECT b FROM t WHERE a=2 FOR UPDATE;
23
23
# Switch to connection con2
24
24
SELECT b FROM t WHERE a=1 FOR UPDATE;
 
25
# Switch to connection con1
 
26
b
 
27
1
 
28
# Switch to connection con2
 
29
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
25
30
# Switch to connection con3
26
31
1
27
32
# Drop test table