From: Rick James
Date: April 24 2012 7:47pm
Subject: RE: Why does the limit use the early row lookup.
List-Archive: http://lists.mysql.com/mysql/227244
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1485A7D9F7@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

aHR0cDovL3d3dy5wZXJjb25hLmNvbS9wcGMyMDA5L1BQQzIwMDlfbXlzcWxfcGFnaW5hdGlvbi5w
ZGYNCg0KTGV0IG1lIGtub3cgaWYgdGhhdCBpcyBub3QgY2xlYXIgZW5vdWdoLg0KDQo+IC0tLS0t
T3JpZ2luYWwgTWVzc2FnZS0tLS0tDQo+IEZyb206IFpoYW5nemhpZ2FuZyBbbWFpbHRvOnp6Z2Fu
Z18yMDA4QHlhaG9vLmNvbS5jbl0NCj4gU2VudDogTW9uZGF5LCBBcHJpbCAyMywgMjAxMiA2OjU2
IFBNDQo+IFRvOiBSaWNrIEphbWVzDQo+IENjOiBteXNxbEBsaXN0cy5teXNxbC5jb20NCj4gU3Vi
amVjdDogUkU6IFdoeSBkb2VzIHRoZSBsaW1pdCB1c2UgdGhlIGVhcmx5IHJvdyBsb29rdXAuDQo+
IA0KPiA+IElmIHlvdSBhcmUgZG9pbmcgUGFnaW5hdGlvbiB2aWEgT0ZGU0VUIGFuZCBMSU1JVCAt
LSBEb24ndC4gIEluc3RlYWQsDQo+ID4gcmVtZW1iZXIgd2hlcmUgeW91ICJsZWZ0IG9mZiIuDQo+
ID4gKE1vcmUgZGV0YWlscyB1cG9uIHJlcXVlc3QuKQ0KPiANCj4gVGhhbmtzIGZvciB5b3VyIGFu
c3dlci4NCj4gDQo+IENhbiB5b3UgdGVsbCB1cyB0aGUgYmV0dGVyIGFwcHJvYWNoIGFib3V0IHBh
Z2luYXRpb24gdG8gcHJldmVudCB0byBzY2FuDQo+IGFsbCB0YWJsZSByb3dzPw0KPiBIb3cgdG8g
dXNlICJsZWZ0IG9mZiI/DQo+IA0KPiANCj4gDQo+IA0KPiAtLS0gMTLlubQ05pyIMjTml6XvvIzl
kajkuowsIFJpY2sgSmFtZXMgPHJqYW1lc0B5YWhvby1pbmMuY29tPiDlhpnpgZPvvJoNCj4gDQo+
ID4g5Y+R5Lu25Lq6OiBSaWNrIEphbWVzIDxyamFtZXNAeWFob28taW5jLmNvbT4NCj4gPiDkuLvp
opg6IFJFOiBXaHkgZG9lcyB0aGUgbGltaXQgdXNlIHRoZSBlYXJseSByb3cgbG9va3VwLg0KPiA+
IOaUtuS7tuS6ujogIuW8oOW/l+WImiIgPHpoaWdhbmdAbGVqdS5zaW5hLmNvbS5jbj4sICJteXNx
bEBsaXN0cy5teXNxbC5jb20iDQo+ID4gPG15c3FsQGxpc3RzLm15c3FsLmNvbT4NCj4gPiDml6Xm
nJ86IDIwMTLlubQ05pyIMjTml6Us5ZGo5LqMLOS4iuWNiDI6NTQNCj4gPiBJbm5vREIgb3IgTXlJ
U0FNPw0KPiA+IFBSSU1BUlkgS0VZIChpZCkgaXMgYSBzZXBhcmF0ZSBpbmRleCBpbiBNeUlTQU0s
IHNvIHNjYW5uaW5nDQo+ID4gMTAwMDAxMCByb3dzIGlzIGZhc3RlciB0aGFuIGZvciBJbm5vREIs
IHdoZXJlIHRoZSBQSyBpcyAiY2x1c3RlcmVkIg0KPiA+IHdpdGggdGhlIGRhdGEuwqAgVGhhdCBp
cywgTXlJU0FNIHNjYW5zIGEgbmFycm93LCAyLWNvbHVtbiwgaW5kZXggKGlkICsNCj4gPiBwb2lu
dGVyKTsgSW5ub0RCIHNjYW5zIHdpZGUgcm93cyAoYWxsIGNvbHVtbnMpLg0KPiA+DQo+ID4gVGhl
cmUgaXMgbm8gd2F5IHRvIGF2b2lkIHNjYW5uaW5nIDEwMDAwMTAgcm93cyBvZiBzb21ldGhpbmcg
KGRhdGEgb3INCj4gPiBpbmRleCkuDQo+ID4NCj4gPiBJZiB5b3UgYXJlIGRvaW5nIFBhZ2luYXRp
b24gdmlhIE9GRlNFVCBhbmQgTElNSVQgLS0gRG9uJ3QuwqAgSW5zdGVhZCwNCj4gPiByZW1lbWJl
ciB3aGVyZSB5b3UgImxlZnQgb2ZmIi4NCj4gPiAoTW9yZSBkZXRhaWxzIHVwb24gcmVxdWVzdC4p
DQo+ID4NCj4gPiBZb3UgY2FuIHRyaWNrIE15U1FMIGludG8gZG9pbmcgImxhdGUgcm93IGxvb2t1
cCIgdmlhIGEgInNlbGYNCj4gPiBqb2luIjoNCj4gPiBTRUxFQ1QgYi4qDQo+ID4gwqAgwqAgRlJP
TSB0YmwgYQ0KPiA+IMKgIMKgIEpPSU4gKCBTRUxFQ1QgaWQgRlJPTcKgIHRibCBPUkRFUiBCWSBp
ZCBMSU1JVCAxMDAwMDAwLCAxMCkgYg0KPiA+IMKgIMKgIMKgIMKgIE9OIGEuaWQgPSBiLmlkDQo+
ID4NCj4gPiBNZWFud2hpbGUsIHNlZSBpZiBpdCBpcyBhbHJlYWR5IGEgZmVhdHVyZSByZXF1ZXN0
IGF0IGJ1Z3MubXlzcWwuY29tDQo+IC4NCj4gPiBJZiBub3QsIGFkZCBpdC4NCj4gPg0KPiA+IFBy
b2JhYmx5IHRoZSBvcHRpbWl6YXRpb24gbmVlZHMgaGV1cmlzdGljcyB0byBkZWNpZGUgd2hpY2gg
d2F5IHRvDQo+IGdvLg0KPiA+IFRoZSBjaG9pY2Ugb2YgZWFybHkgdnMgbGF0ZSBtYXkgZGVwZW5k
IG9uIGFsbCBvZiB0aGVzZToNCj4gPiDCoCAqIE9GRlNFVA0KPiA+IMKgICogTElNSVQNCj4gPiDC
oCAqIE51bWJlciBvZiByb3dzIGluIHRoZSB0YWJsZQ0KPiA+IMKgICogV2lkdGggb2YgdGhlIHRh
YmxlIHZlcnN1cyB3aWR0aCBvZiB0aGUga2V5IGludm9sdmVkLg0KPiA+DQo+ID4gPiAtLS0tLU9y
aWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiA+ID4gRnJvbTog5byg5b+X5YiaIFttYWlsdG86emhpZ2Fu
Z0BsZWp1LnNpbmEuY29tLmNuXQ0KPiA+ID4gU2VudDogVGh1cnNkYXksIEFwcmlsIDE5LCAyMDEy
IDc6MzAgUE0NCj4gPiA+IFRvOiBteXNxbEBsaXN0cy5teXNxbC5jb20NCj4gPiA+IFN1YmplY3Q6
IFdoeSBkb2VzIHRoZSBsaW1pdCB1c2UgdGhlIGVhcmx5IHJvdyBsb29rdXAuDQo+ID4gPg0KPiA+
ID4gRGVhciBhbGw6DQo+ID4gPg0KPiA+ID4gSSBlbmNvdW50ZWQgYSBxdWVzdGlvbiB0aGF0IHRo
ZSBsaW1pdCBpcyBub3QgdXNlIGluZGV4DQo+ID4gdG8gbG9va3VwIHJvdw0KPiA+ID4gd2hlbiBJ
IGlzc3VlIGEgc3FsLg0KPiA+ID4NCj4gPiA+IFRoZW9yZXRpY2FsbHksIHRoZSBsb2NrIGlzIHVz
ZWQgd2hlbiB0aGUgc3FsIHVwZGF0ZQ0KPiA+IHRhYmxlIGRhdGEgYW5kDQo+ID4gPiB1cGRhdGUg
dGFibGUgaW5kZXhlcywgSXQgZW5zdXJlcyB1cGRhdGluZyBkYXRhIGFuZA0KPiA+IHVwZGF0aW5n
IGluZGV4ZXMgYXJlDQo+ID4gPiBzeW5jaHJvbm91cy4NCj4gPiA+DQo+ID4gPiBXaHkgZG9lcyB0
aGUgbGltaXQgdXNlIGVhcmx5IHJvdyBsb29rdXAgYnV0IG5vdCBsYXRlDQo+ID4gcm93IGxvb2t1
cD8NCj4gPiA+DQo+ID4gPiBGb3IgZXhhbXBsZSA6DQo+ID4gPg0KPiA+ID4gQ3JlYXRlIHRhYmxl
IHRlc3QgKGlkIGludCBwcmltYXJ5IGtleSwgbmFtZSBjaGFyKDIwKSk7DQo+ID4gPg0KPiA+ID4g
c2VsZWN0ICogZnJvbSB0ZXN0IG9yZGVyIGJ5IGlkIGxpbWl0IDEwMDAwMDAsIDEwLg0KPiA+ID4N
Cj4gPiA+IFRoZSBhYm92ZSBzcWwgaXMgdmVyeSBzbG93IHdoZW4gb25lIGZldGNoIGNvbHVtbiBp
cyBub3QNCj4gPiBpbiB0aGUgaW5kZXhlcw0KPiA+ID4gYW5kIHRoZSBvZmZzZXQgaXMgbW9yZSB0
aGFuIG1pbGxpb24uDQo+ID4gPg0KPiA+ID4gVGhlIGFib3ZlIHNxbCBjb3VudCBvZmYgdGhlIDEw
MDAwMTAgcm93cyBhbmQgcmV0dXJuIHRoZQ0KPiA+IHRvcCAxMCByb3dzLg0KPiA+ID4NCj4gPiA+
IEJ1dCB0aGUgc3FsOiBzZWxlY3QgaWQgZnJvbSB0ZXN0IG9yZGVyIGJ5IGlkIGxpbWl0DQo+ID4g
MTAwMDAwMCwgMTAgaXMgdmVyeQ0KPiA+ID4gZmFzdO+8jGl0IHNraXBzIHRvIGNvdW50IG9mZiB0
aGUgMTAwMDAwMCByb3dzIGJ5IHVzaW5nDQo+ID4gaW5kZXhlcywgYW5kDQo+ID4gPiBjb3VudCBv
ZmYNCj4gPiA+IDEwIHJvd3Mgb25seS4NCj4gPiA+DQo+ID4gPiBJIGRvbuKAmXQga25vdyB0aGUg
cmVhc29uLg0KPiA+ID4NCj4gPiA+IE15IHBvaW50IGlzIHRoYXQgdGhlIGxpbWl0IGNhbiB1c2Ug
bGF0ZSByb3cgbG9va3VwOg0KPiA+IGxvb2t1cCByb3dzIGFmdGVyDQo+ID4gPiBjaGVja2luZyBp
bmRleGVzIHRvIG9wdGltaXplIHRoZSBzZWxlY3Qgc3BlZWQuDQo+ID4gPg0KPiA+ID4gQnV0IHRo
ZSBteXNxbCBvcHRpbWl6ZXIgZG8gaXQgd2l0aCB0aGUgZWFybHkgcm93DQo+ID4gbG9va3VwOiBs
b29rdXAgYWxsDQo+ID4gPiByb3dzIGJlZm9yZSBjaGVja2luZyBpbmRleGVzIHdoZW4gdGhlIG9u
ZSBmZXRjaCBjb2x1bW4NCj4gPiBpcyBub3QgaW4gdGhlDQo+ID4gPiBpbmRleGVzLg0KPiA+ID4N
Cj4gPiA+IFRlbGwgbWUgd2h5Pw0KPiA+ID4NCj4gPiA+IFRoYW5rcw0KPiA+ID4NCj4gPiA+DQo+
ID4gPg0KPiA+ID4gU2luY2VyZWx5IHlvdXJzLA0KPiA+ID4NCj4gPiA+IFpoaWdhbmcgemhhbmcN
Cj4gPg0KPiA+DQo+ID4gLS0NCj4gPiBNeVNRTCBHZW5lcmFsIE1haWxpbmcgTGlzdA0KPiA+IEZv
ciBsaXN0IGFyY2hpdmVzOiBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQo+IA0KPiA+IFRv
IHVuc3Vic2NyaWJlOsKgIMKgIGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlzcWwNCj4gDQo+ID4N
Cj4gPg0K