← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/lock.result

Merged from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/lock.result
83
83
ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
84
84
unlock tables;
85
85
drop table t1;
86
 
DROP TABLE IF EXISTS t1;
87
 
CREATE TABLE t1 (i INT);
88
 
LOCK TABLES mysql.time_zone READ, t1 READ;
89
 
UNLOCK TABLES;
90
 
LOCK TABLES mysql.time_zone READ,  t1 WRITE;
91
 
UNLOCK TABLES;
92
 
LOCK TABLES mysql.time_zone READ;
93
 
UNLOCK TABLES;
94
 
LOCK TABLES mysql.time_zone WRITE;
95
 
UNLOCK TABLES;
96
 
LOCK TABLES mysql.time_zone READ, t1 READ;
97
 
LOCK TABLES mysql.time_zone WRITE, t1 READ;
98
 
ERROR HY000: You can't combine write-locking of system tables with other tables or lock types
99
 
LOCK TABLES mysql.time_zone WRITE, t1 WRITE;
100
 
ERROR HY000: You can't combine write-locking of system tables with other tables or lock types
101
 
DROP TABLE t1;
102
86
 
103
87
Cleanup.
104
88