~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed : revision 1.2.3

1

2011-12-13 The InnoDB Team

2

3

* handler/ha_innodb.cc, innodb.test, innodb.result:

4

Fix Bug#13117023: InnoDB was incrementing the handler_read_key,

5

also the SSV::ha_read_key_count, at the wrong place.

6

7

2011-12-10 The InnoDB Team

8

9

* include/page0page.h, page/page0page.c:

10

Fix Bug#13418887 ERROR IN DIAGNOSTIC FUNCTION PAGE_REC_PRINT()

11

12

2011-11-10 The InnoDB Team

13

14

* handler/ha_innodb.cc, row/row0ins.c, innodb_replace.test:

15

Fix Bug#11759688 52020: InnoDB can still deadlock

16

on just INSERT...ON DUPLICATE KEY a.k.a. the reintroduction of

17

Bug#7975 deadlock without any locking, simple select and update

18

19

2011-11-08 The InnoDB Team

20

21

* btr/btr0pcur.c, include/btr0pcur.h, include/btr0pcur.ic:

22

Fix Bug#13358468 ASSERTION FAILURE IN BTR_PCUR_GET_BLOCK

23

24

2011-10-27 The InnoDB Team

25

26

* row/row0mysql.c:

27

Fix Bug #12884631 62146: TABLES ARE LOST FOR DDL

28

29

2011-10-25 The InnoDB Team

30

31

* handler/ha_innodb.cc, row/row0ins.c:

32

Fix Bug#13002783 PARTIALLY UNINITIALIZED CASCADE UPDATE VECTOR

33

34

2011-10-20 The InnoDB Team

35

36

* btr/btr0cur.c:

37

Fix Bug#13116045 Compilation failure using GCC 4.6.1 in btr/btr0cur.c

38

39

2011-10-12 The InnoDB Team

40

41

* btr/btr0cur.c, btr/btr0sea.c, buf/buf0buf.c, buf/buf0lru.c,

42

ha/ha0ha.c, handler/ha_innodb.cc, ibuf/ibuf0ibuf.c, include/btr0sea.h,

43

include/btr0types.h, include/buf0buf.h, include/ha0ha.h,

44

include/ha0ha.ic, include/row0upd.ic, include/sync0sync.h,

45

page/page0page.c, sync/sync0sync.c:

46

Fix Bug#13006367 62487: innodb takes 3 minutes to clean up

47

the adaptive hash index at shutdown

48

49

2011-10-04 The InnoDB Team

50

51

* include/sync0rw.h, sync/sync0rw.c:

52

Fix Bug#13034534 RQG TESTS FAIL ON WINDOWS WITH CRASH NEAR

53

RW_LOCK_DEBUG_PRINT

54

55

2011-09-20 The InnoDB Team

56

57

* row/row0purge.c:

58

Fix Bug#12963823 CRASH IN PURGE THREAD UNDER UNUSUAL CIRCUMSTANCES

59

60

2011-09-12 The InnoDB Team

61

62

* row/row0sel.c:

63

Fix Bug#12601439 CONSISTENT READ FAILURE IN COLUMN PREFIX INDEX

64

65

2011-09-08 The InnoDB Team

66

67

* btr/btr0cur.c, include/page0page.h, include/row0upd.ic:

68

Fix Bug#12948130 UNNECESSARY X-LOCKING OF ADAPTIVE HASH INDEX

69

70

2011-09-06 The InnoDB Team

71

72

* buf/buf0buddy.c:

73

Fix Bug#12950803 62294: BUF_BUDDY_RELOCATE CALLS GETTIMEOFDAY

74

WHILE HOLDING BUFFER POOL MUTEX

75

76

2011-09-06 The InnoDB Team

77

78

* include/trx0undo.h, trx/trx0rec.c, trx/trx0undo.c:

79

Fix Bug#12547647 UPDATE LOGGING COULD EXCEED LOG PAGE SIZE

80

81

2011-08-29 The InnoDB Team

82

83

* btr/btr0btr.c, btr/btr0cur.c, fsp/fsp0fsp.c,

84

include/btr0btr.h, include/btr0cur.h, include/fsp0fsp.h,

85

include/mtr0mtr.h, include/mtr0mtr.ic, mtr/mtr0mtr.c,

86

row/row0ins.c, row/row0row.c, row/row0upd.c, trx/trx0undo.c:

87

Fix Bug#12704861 Corruption after a crash during BLOB update

88

and other regressions from the fix of Bug#12612184

89

90

2011-08-15 The InnoDB Team

91

92

* btr/btr0btr.c, btr/btr0cur.c, btr/btr0pcur.c, btr/btr0sea.c,

93

dict/dict0crea.c, dict/dict0dict.c, ibuf/ibuf0ibuf.c,

94

include/btr0btr.h, include/btr0btr.ic, include/sync0sync.h,

95

sync/sync0sync.c:

96

Fix Bug#11766591 59733: Possible deadlock when buffered changes

97

are to be discarded in buf_page_create()

98

99

2011-08-08 The InnoDB Team

100

101

* row/row0sel.c:

102

Fix Bug#12835650 VARCHAR maximum length performance impact

103

104

2011-08-08 The InnoDB Team

105

106

* handler/ha_innodb.cc:

107

Fix Bug#12770537 I_S.TABLES.DATA_LENGTH DOES NOT SHOW ON-DISK SIZE

108

FOR COMPRESSED INNODB

109

110

2011-07-19 The InnoDB Team

111

112

* buf/buf0buf.c, buf/buf0rea.c, handler/ha_innodb.cc,

113

include/buf0buf.h, include/buf0buf.ic, include/srv0srv.h,

114

srv/srv0srv.c:

115

Fix Bug#12356373 by reintroducing random readahead

116

117

2011-06-30 The InnoDB Team

118

119

* row/row0row.c:

120

Fix Bug#12637786 Wrong secondary index entries on CHAR and VARCHAR

121

columns in ROW_FORMAT=DYNAMIC and ROW_FORMAT=COMPRESSED

122

123

2011-06-16 The InnoDB Team

124

125

* btr/btr0cur.c, buf/buf0buddy.c, buf/buf0buf.c, buf/buf0lru.c,

126

include/buf0buddy.h, include/buf0buddy.ic, include/buf0buf.h,

127

include/buf0buf.ic, include/buf0lru.h, include/buf0types.h:

128

Fix Bug#61188 DROP TABLE extremely slow

129

130

2011-06-16 The InnoDB Team

131

132

* buf/buf0buddy.c, buf/buf0buf.c, buf/buf0flu.c, buf/buf0lru.c,

133

include/buf0buf.h, include/buf0lru.h:

134

Fix Bug#61341 buf_LRU_insert_zip_clean can be O(N) on LRU length

135

136

2011-06-16 The InnoDB Team

137

138

* page/page0zip.c, rem/rem0rec.c:

139

Fix Bug#61191 question about page_zip_available()

140

141

2011-06-16 The InnoDB Team

142

143

* btr/btr0btr.c, btr/btr0cur.c, include/btr0btr.h, include/btr0cur.h,

144

include/btr0cur.ic, include/buf0buf.h, include/buf0buf.ic,

145

include/page0cur.ic, include/page0page.h, include/page0page.ic,

146

include/sync0rw.ic, include/sync0sync.h, page/page0cur.c,

147

page/page0page.c, row/row0ins.c, row/row0upd.c,

148

sync/sync0rw.c, sync/sync0sync.c:

149

Fix Bug#12612184 Race condition after btr_cur_pessimistic_update()

150

151

2011-06-09 The InnoDB Team

152

* btr/btr0cur.c, include/rem0rec.h, include/rem0rec.ic,

153

* row/row0row.c, row/row0vers.c, trx/trx0rec.c:

154

Instrumentation for Bug#12612184 Race condition in row_upd_clust_rec()

155

156

2011-05-19 The InnoDB Team

157

158

* row/row0row.c:

159

Fix Bug#12429576 Assertion failure on purge of column prefix index

160

161

2011-04-07 The InnoDB Team

162

163

* handler/ha_innodb.cc, handler/ha_innodb.h, handler/handler0alter.cc:

164

Fix Bug #52409 Assertion failure: long semaphore wait

165

166

2011-04-07 The InnoDB Team

167

168

* handler/ha_innodb.cc, include/trx0trx.h, include/trx0undo.h,

169

log/log0log.c, trx/trx0sys.c, trx/trx0trx.c, trx/trx0undo.c:

170

Fix Bug #59641 Prepared XA transaction in system after hard crash

171

causes future shutdown hang

172

173

2011-03-30 The InnoDB Team

174

175

* srv/srv0srv.c, sync/sync0arr.h, sync/sync0arr.c:

176

Fix Bug#11877216 InnoDB too eager to commit suicide on a busy server

177

178

2011-03-15 The InnoDB Team

179

180

* btr/btr0cur.c, page/page0zip.c:

181

Fix Bug#11849231 inflateInit() invoked without initializing all memory

182

183

2011-02-28 The InnoDB Team

184

185

* btr/btr0sea.c, buf/buf0buf.c, buf/buf0lru.c:

186

Fix Bug#58549 Race condition in buf_LRU_drop_page_hash_for_tablespace()

187

and compressed tables

188

189

2011-02-15 The InnoDB Team

190

191

* sync/sync0rw.c, innodb_bug59307.test:

192

Bug#59307 Valgrind: uninitialized value in

193

rw_lock_set_writer_id_and_recursion_flag()

194

195

2011-02-14 The InnoDB Team

196

197

* handler/handler0alter.cc:

198

Bug#59749 Enabling concurrent reads while creating non-primary

199

unique index gives failures

200

201

2011-01-31 The InnoDB Team

202

203

* btr/btr0cur.c, include/row0upd.h,

204

row/row0purge.c, row/row0umod.c, row/row0upd.c:

205

Bug#59230 assert 0 row_upd_changes_ord_field_binary()

206

in post-crash rollback or purge

207

208

2011-01-27 The InnoDB Team

209

210

* btr/btr0cur.c:

211

Bug#59465 btr_estimate_number_of_different_key_vals use

212

incorrect offset for external_size

213

214

2011-01-27 The InnoDB Team

215

216

* include/trx0trx.h, trx/trx0trx.c:

217

Bug#59440 Race condition in XA ROLLBACK and XA COMMIT

218

after server restart

219

220

2011-01-25 The InnoDB Team

221

222

* row/row0upd.c:

223

Bug#59585 Fix 58912 introduces compiler warning

224

due to potentially uninitialized variable

225

226

2011-01-25 The InnoDB Team

227

228

* mtr/mtr0log.c:

229

Bug#59486 Incorrect usage of UNIV_UNLIKELY() in mlog_parse_string()

230

231

2011-01-25 The InnoDB Team

232

233

* row/row0vers.c:

234

Fix Bug#59464 Race condition in row_vers_build_for_semi_consistent_read

235

236

2011-01-25 The InnoDB Team

237

238

* btr/btr0btr.c, btr/btr0cur.c, btr/btr0sea.c,

239

buf/buf0buddy.c, buf/buf0buf.c, buf/buf0lru.c,

240

include/buf0buf.h, include/buf0buf.ic, include/buf0lru.h,

241

mem/mem0mem.c, page/page0zip.c:

242

Fix Bug#59707 Unused compression-related parameters

243

in buffer pool functions

244

245

2011-01-18 The InnoDB Team

246

247

* include/sync0rw.h, sync/sync0arr.c, sync/sync0rw.c:

248

Fix Bug#59579 rw_lock_debug_print outputs to stderr, not to

249

SHOW ENGINE INNODB STATUS

250

251

2011-01-14 The InnoDB Team

252

* btr/btr0cur.c, dict/dict0dict.c, handler/ha_innodb.cc,

253

include/btr0cur.h, include/dict0mem.h, include/rem0cmp.h,

254

include/rem0cmp.ic, include/srv0srv.h, rem/rem0cmp.c,

255

srv/srv0srv.c, innodb_bug30423.test:

256

Fix Bug#30423 InnoDBs treatment of NULL in index stats causes

257

bad "rows examined" estimates

258

259

2011-01-06 The InnoDB Team

260

* row/row0merge.c:

261

Fix Bug#59312 Examine MAX_FULL_NAME_LEN in InnoDB to address

262

possible insufficient name buffer

263

264

2011-01-06 The InnoDB Team

265

* dict/dict0dict.c, handler/ha_innodb.cc, handler/i_s.cc,

266

include/univ.i:

267

Fix Bug#58643 InnoDB: too long table name

268

269

2011-01-06 The InnoDB Team

270

* handler/i_s.cc, include/trx0i_s.h, trx/trx0i_s.c:

271

Fix Bug#55397 cannot select from innodb_trx when trx_query contains

272

blobs that aren't strings

273

274

2011-01-04 The InnoDB Team

275

* dict/dict0dict.c:

276

Fix Bug#59197 double quote in field comment prevents foreign

277

key constraint creation

278

279

2010-12-21 The InnoDB Team

280

* include/btr0cur.h, include/row0upd.h, btr/btr0cur.c,

281

row/row0umod.c, row/row0upd.c:

282

Fix Bug#55284 Double free of off-page columns due to lock wait

283

while updating PRIMARY KEY

284

285

2010-12-21 The InnoDB Team

286

287

* include/data0data.h, include/data0data.ic, include/row0upd.h,

288

btr/btr0cur.c, row/row0purge.c, row/row0umod.c, row/row0upd.c,

289

innodb.result, innodb.test:

290

Fix Bug#58912 InnoDB unnecessarily avoids update-in-place

291

on column prefix indexes

292

293

2010-12-09 The InnoDB Team

294

295

* buf/buf0lru.c:

296

Fix Bug#57600 output of I/O sum[%lu] can go negative

297

298

2010-11-11 The InnoDB Team

299

300

* thr/thr0loc.c, trx/trx0i_s.c:

301

Fix Bug#57802 Empty ASSERTION parameter passed to the HASH_SEARCH macro

302

303

2010-11-10 The InnoDB Team

304

305

* dict/dict0dict.c, handler/handler0alter.cc, include/dict0dict.h

306

row/row0merge.c:

307

Fix Bug#55084 InnoDB crash and corruption after ALTER TABLE

308

309

2010-11-10 The InnoDB Team

310

311

* srv/srv0start.c:

312

Fix Bug#48026 Log start and end of InnoDB buffer pool

313

initialization to the error log

314

315

2010-11-03 The InnoDB Team

316

317

* include/btr0btr.h, include/btr0btr.ic, dict/dict0crea.c:

318

Fix Bug#57947 InnoDB diagnostics shows btr_block_get calls

319

instead of real callers

320

321

2010-11-03 The InnoDB Team

322

323

* fil/fil0fil.c, fsp/fsp0fsp.c, handler/ha_innodb.cc,

324

include/fil0fil.h, include/univ.i:

325

Fix Bug #54538 - use of exclusive innodb dictionary lock limits

326

performance.

327

328

2010-11-02 The InnoDB Team

329

330

* btr/btr0cur.c, dict/dict0dict.c, dict/dict0load.c,

331

handler/ha_innodb.cc, include/dict0dict.h, row/row0mysql.c,

332

innodb_bug53046.result, innodb_bug53046.test:

333

Fix Bug#53046 dict_update_statistics_low can still be run

334

concurrently on same table

335

336

2010-11-02 The InnoDB Team

337

338

* row/row0sel.c:

339

Fix Bug#57799 READ UNCOMMITTED access failure of off-page

340

DYNAMIC or COMPRESSED columns again

341

342

2010-10-24 The InnoDB Team

343

344

* row/row0mysql.c

345

Fix Bug#57700 Latching order violation in

346

row_truncate_table_for_mysql()

347

348

2010-10-20 The InnoDB Team

349

350

* dict/dict0load.c

351

Fix Bug#57616 Sig 11 in dict_load_table() when failed to load

352

index or foreign key

353

354

2010-10-19 The InnoDB Team

355

356

* btr/btr0cur.c, buf/buf0buf.c, buf/buf0flu.c, handler/ha_innodb.cc,

357

ibuf/ibuf0ibuf.c, include/btr0cur.h, include/buf0flu.h,

358

include/ibuf0ibuf.h, include/row0mysql.h,

359

row/row0mysql.c, row/row0sel.c,

360

innodb_bug56680.test, innodb_bug56680.result:

361

Fix Bug#56680 InnoDB may return wrong results from a

362

case-insensitive covering index

363

364

2010-10-18 The InnoDB Team

365

366

* handler/ha_innodb.cc, handler/ha_innodb.h, innodb_bug57252.result,

367

innodb_bug57252.test:

368

Fix Bug#57252 disabling innobase_stats_on_metadata disables ANALYZE

369

370

2010-10-14 The InnoDB Team

371

372

* handler/ha_innodb.cc, innodb_bug56143.result, innodb_bug56143.test:

373

Fix Bug#56143 too many foreign keys causes output of show create

374

table to become invalid

375

376

2010-10-14 The InnoDB Team

377

378

* srv/srv0start.c:

379

Fix Bug#57397 io_handler_thread() will never cleanup

380

381

2010-10-11 The InnoDB Team

382

383

* row/row0sel.c

384

Fix Bug #57345 btr_pcur_store_position abort for load with

385

concurrent lock/unlock tables

386

387

2010-10-11 The InnoDB Team

388

389

* row/row0mysql.c, innodb_bug56947.result, innodb_bug56947.test:

390

Fix Bug #56947 InnoDB leaks memory when failing to create a table

391

392

2010-10-06 The InnoDB Team

393

394

* row/row0mysql.c, innodb_bug57255.result, innodb_bug57255.test

395

Fix Bug #57255 Cascade Delete results in "Got error -1 from

396

storage engine"

397

398

2010-09-27 The InnoDB Team

399

400

* row/row0sel.c, innodb_bug56716.result, innodb_bug56716.test:

401

Fix Bug#56716 InnoDB locks a record gap without locking the table

402

403

2010-09-06 The InnoDB Team

404

405

* dict/dict0load.c, innodb_bug53756.test innodb_bug53756.result:

406

Fix Bug#53756 ALTER TABLE ADD PRIMARY KEY affects crash recovery

407

408

2010-08-24 The InnoDB Team

409

410

* handler/ha_innodb.c, dict/dict0dict.c:

411

Fix Bug#55832 selects crash too easily when innodb_force_recovery>3

412

413

2010-08-03 The InnoDB Team

414

415

* include/dict0dict.h, include/dict0dict.ic, row/row0mysql.c:

416

Fix Bug#54678 InnoDB, TRUNCATE, ALTER, I_S SELECT, crash or deadlock

417

418

2010-08-03 The InnoDB Team

419

420

* dict/dict0load.c, handler/ha_innodb.cc, include/db0err.h,

421

include/dict0load.h, include/dict0mem.h, include/que0que.h,

422

row/row0merge.c, row/row0mysql.c:

423

Fix Bug#54582 stack overflow when opening many tables linked

424

with foreign keys at once

425

426

2010-08-03 The InnoDB Team

427

428

* include/ut0mem.h, ut/ut0mem.c:

429

Fix Bug#55627 segv in ut_free pars_lexer_close innobase_shutdown

430

innodb-use-sys-malloc=0

431

432

2010-08-01 The InnoDB Team

433

434

* handler/ha_innodb.cc:

435

Fix Bug#55382 Assignment with SELECT expressions takes unexpected

436

S locks in READ COMMITTED

437

438

2010-07-27 The InnoDB Team

439

440

* include/mem0pool.h, mem/mem0mem.c, mem/mem0pool.c, srv/srv0start.c:

441

Fix Bug#55581 shutdown with innodb-use-sys-malloc=0: assert

442

mutex->magic_n == MUTEX_MAGIC_N.

443

444

2010-06-30 The InnoDB Team

445

446

* btr/btr0sea.c, ha/ha0ha.c, handler/ha_innodb.cc, include/btr0sea.h:

447

Fix Bug#54311 Crash on CHECK PARTITION after concurrent LOAD DATA

448

and adaptive_hash_index=OFF

449

450

2010-06-29 The InnoDB Team

451

* row/row0row.c, row/row0undo.c, row/row0upd.c:

452

Fix Bug#54408 txn rollback after recovery: row0umod.c:673

453

dict_table_get_format(index->table)

454

455

2010-06-29 The InnoDB Team

456

457

* btr/btr0cur.c, include/btr0cur.h, include/row0mysql.h,

458

row/row0merge.c, row/row0sel.c:

459

Fix Bug#54358 READ UNCOMMITTED access failure of off-page DYNAMIC

460

or COMPRESSED columns

461

1

462

2010-06-24 The InnoDB Team

2

463

3

464

* handler/ha_innodb.cc: