~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/lock_multi.test

Committer: Brian Aker
Date: 2009-01-07 21:26:58 UTC
Revision ID: brian@tangent.org-20090107212658-2fh0s2uwh10w68y2

Committing fix lock_multi

files renamed:
tests/suite/broken/r/lock_multi.result => tests/r/lock_multi.result

tests/suite/broken/t/lock_multi.test => tests/t/lock_multi.test

Show diffs side-by-side

added added

removed removed

tests/t/lock_multi.test

230

connection locker;

231

# Disable warnings to allow test to run also without InnoDB

232

--disable_warnings

233

create table t1 (f1 int(12) not null auto_increment, primary key(f1)) engine=innodb;

233

create table t1 (f1 int not null auto_increment, primary key(f1)) engine=innodb;

234

--enable_warnings

235

lock tables t1 write;

236

connection writer;

255

drop table t1;

256

257

--echo End of 5.0 tests

258

259

260

# Bug #21281 "Pending write lock is incorrectly removed when its

261

# statement being KILLed"

262

263

create table t1 (i int);

264

connection locker;

265

lock table t1 read;

266

connection writer;

267

--send update t1 set i= 10;

268

connection reader;

269

let $wait_condition=

270

select count(*) = 1 from information_schema.processlist

271

where state = "Table lock" and info = "update t1 set i= 10";

272

--source include/wait_condition.inc

273

--send select * from t1;

274

connection default;

275

let $wait_condition=

276

select count(*) = 1 from information_schema.processlist

277

where state = "Table lock" and info = "select * from t1";

278

--source include/wait_condition.inc

279

let $ID= `select id from information_schema.processlist where state = "Table lock" and info = "update t1 set i= 10"`;

280

--replace_result $ID ID

281

eval kill query $ID;

282

connection reader;

283

--reap

284

connection writer;

285

--error ER_QUERY_INTERRUPTED

286

--reap

287

connection locker;

288

unlock tables;

289

connection default;

290

drop table t1;

291

292

293

# Bug#25856 - HANDLER table OPEN in one connection lock DROP TABLE in another one

294

295

--disable_warnings

296

drop table if exists t1;

297

--enable_warnings

298

create table t1 (a int) ENGINE=MEMORY;

299

--echo --> client 2

300

connection locker;

301

--error 1031

302

handler t1 open;

303

--echo --> client 1

304

connection default;

305

drop table t1;

258

# See bug 314871

259

260

## Bug #21281 "Pending write lock is incorrectly removed when its

261

## statement being KILLed"

262

263

#create table t1 (i int);

264

#connection locker;

265

#lock table t1 read;

266

#connection writer;

267

#--send update t1 set i= 10;

268

#connection reader;

269

#let $wait_condition=

270

# select count(*) = 1 from information_schema.processlist

271

# where state = "Table lock" and info = "update t1 set i= 10";

272

#--source include/wait_condition.inc

273

#--send select * from t1;

274

#connection default;

275

#let $wait_condition=

276

# select count(*) = 1 from information_schema.processlist

277

# where state = "Table lock" and info = "select * from t1";

278

#--source include/wait_condition.inc

279

#let $ID= `select id from information_schema.processlist where state = "Table lock" and info = "update t1 set i= 10"`;

280

#--replace_result $ID ID

281

#eval kill query $ID;

282

#connection reader;

283

#--reap

284

#connection writer;

285

#--error ER_QUERY_INTERRUPTED

286

#--reap

287

#connection locker;

288

#unlock tables;

289

#connection default;

290

#drop table t1;

306

291

307

292

308

293

# Bug#32395 Alter table under a impending global read lock causes a server crash

Older »