From: Rick James
Date: September 4 2012 6:43pm
Subject: RE: Aggregate
List-Archive: http://lists.mysql.com/mysql/228111
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148B889260@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

aW50KDEpIGRvZXMgbm90IG1lYW4gd2hhdCB5b3UgdGhpbmsuICBQcm9iYWJseSB5b3Ugd2FudCBU
SU5ZSU5UIFVOU0lHTkVELg0KaW50KDI1KSwgYmlnaW50KDI1MCkgLS0gRWg/DQpJTlQgaXMgYWx3
YXlzIDQgYnl0ZXMgKDMyLWJpdHMpOyBCSUdJTlQgaXMgYWx3YXlzIDggYnl0ZXMuDQoNClVzZSBV
TlNJR05FRCB3aGVyZXZlciBhcHByb3ByaWF0ZS4NCg0KWW91IGhhdmUgREFURVRJTUUgYW5kIFRJ
TUVTVEFNUC4gIEtlZXAgaW4gbWluZCB0aGF0IFRJTUVaT05FIGlzIHRpbWV6b25lLWF3YXJlOyBE
QVRFVElNRSBpcyBub3QuDQoNClRoZSB0d28gdGFibGVzIGhhdmUgYSBsb3Qgb2YgdGhlIHNhbWUg
ZmllbGRzIC0tIHlvdSBtYXkgbmVlZCB0byByZXRoaW5rIHRoZSBzY2hlbWEuDQpCb3RoIHRhYmxl
cyBoYXZlIHRoZSBzYW1lIFBSSU1BUlkgS0VZLCBhbmQgaXQgaXMgQVVUT19JTkNSRU1FTlQuICBU
aGlzIGlzIGFsbW9zdCBjZXJ0YWlubHkgYSBtaXN0YWtlLg0KDQpXb3VsZG4ndCBvbmUgImFydGlj
bGUiIGhhdmUgbXVsdGlwbGUgImRpc2N1c3Npb25zIj8NCg0KUGxlYXNlIHJlc3RydWN0dXJlIHRo
ZSB0YWJsZXMgYmVmb3JlIHdlIHRyeSB0byBkaXNjdXNzIHlvdXIgQWdncmVnYXRlIHF1ZXN0aW9u
Lg0KDQo+IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQo+IEZyb206IFJvbiBQaWdnb3R0IFtt
YWlsdG86cm9uLnBpZ2dvdHRAYWN0c21pbmlzdHJpZXMub3JnXQ0KPiBTZW50OiBGcmlkYXksIEF1
Z3VzdCAzMSwgMjAxMiAzOjIyIEFNDQo+IFRvOiBteXNxbEBsaXN0cy5teXNxbC5jb20NCj4gU3Vi
amVjdDogQWdncmVnYXRlDQo+IA0KPiANCj4gSSBhbSB1bnN1cmUgb2Ygd2hpY2ggQWdncmVnYXRl
IGZ1bmN0aW9uIHRvIHVzZSB3aXRoIHRoZSBxdWVyeSAoYmVsb3cpDQo+IFJpZ2h0IG5vdyB0aHJl
YWRfZGF0ZV9yZWZlcmVuY2UgYW5kIGxhc3RfcG9zdF9tZW1iZXJzaGlwX3JlZmVyZW5jZQ0KPiBw
cm9kdWNlIE5VTEwgcmVzdWx0cy4gSSBleHBlY3QgdGhlIE5VTEwgcmVzdWx0IGlzIGJlY2F1c2Ug
b2YgdGhlIExFRlQNCj4gT1VURVIgSk9JTiBhbmQgdGhlcmUgYmVpbmcgbm8gbWF0Y2hpbmcgSk9J
TiBpbiB0aGUgdGFibGUNCj4gYXJ0aWNsZXNfZGlzY3Vzc2lvbiAsIGFzIHdlbGwgYXMgdGhlIEdS
T1VQIEJZIChsaW1pdGluZyAxIHJlY29yZCByZXN1bHQNCj4gcGVyIHRocmVhZCkNCj4gDQo+IA0K
PiBTRUxFQ1QgYGFydGljbGVzYC5gcmVmZXJlbmNlYCAsIGBhcnRpY2xlc2AuYGFydGljbGVfdGl0
bGVgICwgSUYoDQo+IGBhcnRpY2xlc2AuYGRhdGVfc3VibWl0dGVkYCA+IGBhcnRpY2xlc19kaXNj
dXNzaW9uYC5gZGF0ZV9zdWJtaXR0ZWRgICwNCj4gQ09OVkVSVF9UWihgYXJ0aWNsZXNgLmBkYXRl
X3N1Ym1pdHRlZGAsJyswMDowMCcsJyR1c2VyX3RpbWVfem9uZV9wcmVmZXINCj4gZW5jZV90aW1l
X3N0cmluZycpICwNCj4gQ09OVkVSVF9UWihgYXJ0aWNsZXNfZGlzY3Vzc2lvbmAuYGRhdGVfc3Vi
bWl0dGVkYCwnKzAwOjAwJywnJHVzZXJfdGltZV8NCj4gem9uZV9wcmVmZXJlbmNlX3RpbWVfc3Ry
aW5nJykgKSBBUyB0aHJlYWRfZGF0ZV9yZWZlcmVuY2UgLCBJRigNCj4gYGFydGljbGVzYC5gZGF0
ZV9zdWJtaXR0ZWRgID4gYGFydGljbGVzX2Rpc2N1c3Npb25gLmBkYXRlX3N1Ym1pdHRlZGAgLA0K
PiBgYXJ0aWNsZXNgLmBtZW1iZXJzaGlwX3JlZmVyZW5jZWAgLA0KPiBgYXJ0aWNsZXNfZGlzY3Vz
c2lvbmAuYG1lbWJlcnNoaXBfcmVmZXJlbmNlYCApIEFTDQo+IGxhc3RfcG9zdF9tZW1iZXJzaGlw
X3JlZmVyZW5jZSBGUk9NIGBhcnRpY2xlc2AgTEVGVCBPVVRFUiBKT0lODQo+IGBhcnRpY2xlc19k
aXNjdXNzaW9uYCBPTiBgYXJ0aWNsZXNgLmByZWZlcmVuY2VgID0NCj4gYGFydGljbGVzX2Rpc2N1
c3Npb25gLmBhcnRpY2xlc19yZWZlcmVuY2VgIFdIRVJFIGBhcnRpY2xlc2AuYGFwcHJvdmVkYA0K
PiBJTiAoIDEgLCAyICwgMyApIEdST1VQIEJZIGBhcnRpY2xlc2AuYHJlZmVyZW5jZWANCj4gDQo+
IA0KPiBUaGUgcHVycG9zZSBvZiB0aGlzIHF1ZXJ5IGlzIHRvIHNob3cgYSBzdW1tYXJ5IG9mIHRo
ZSBkaXNjdXNzaW9uDQo+IHRocmVhZHMgd2l0aCBkYXRlIG9mIHRoZSBtb3N0IHJlY2VudCBwb3N0
ICggdGhyZWFkX2RhdGVfcmVmZXJlbmNlICkgYW5kDQo+IHRoZSBtZW1iZXIgIyBvZiB0aGF0IHBv
c3QgKCBsYXN0X3Bvc3RfbWVtYmVyc2hpcF9yZWZlcmVuY2UgKS4NCj4gDQo+IEkgYW0gd2FudGlu
ZyB0byBtYWtlIHRoZSB0aHJlYWRzIGluZGV4IGludG8gNCBxdWVyaWVzIHRvIGFsbG93IGZvcg0K
PiBkaWZmZXJlbnQgT1JERVIgQlkgb3B0aW9uczoNCj4gDQo+IC0gbmV3ZXN0IHRvIG9sZGVzdCBw
b3N0cyAoYmFzZWQgb24gdGhlIGRhdGUgZmllbGQpDQo+IC0gb2xkZXN0IHRvIG5ld2VzdCBwb3N0
cyAoYmFzZWQgb24gdGhlIGRhdGUgZmllbGQpDQo+IC0gdGhyZWFkIHRpdGxlcyBhbHBoYWJldGlj
YWwNCj4gLSBieSBhbGlhcyBhbHBoYWJldGljYWxseSAoVGhpcyB3aWxsIG5lZWQgYW4gSU5ORVIg
Sk9JTiB0byB0aGUg4oCcZm9ydW0NCj4gcHJvZmlsZXPigJ0gdGFibGUuIFRoZSB0YWJsZXMgYXJ0
aWNsZXMgYW5kIGFydGljbGVzX2Rpc2N1c3Npb24gb25seSBzdG9yZQ0KPiB0aGUgYXV0b19pbmNy
ZW1lbnQgdmFsdWUgb2YgdGhlIG1lbWJlciBhY2NvdW50ICMgKQ0KPiANCj4gDQo+IFRoZSB0YWJs
ZSBzdHJ1Y3R1cmUgZm9yIGFydGljbGVzDQo+IA0KPiBDUkVBVEUgVEFCTEUgSUYgTk9UIEVYSVNU
UyBgYXJ0aWNsZXNgICgNCj4gYHJlZmVyZW5jZWAgaW50KDI1KSBOT1QgTlVMTCBBVVRPX0lOQ1JF
TUVOVCwgYG1lbWJlcnNoaXBfcmVmZXJlbmNlYA0KPiBpbnQoMjUpIE5PVCBOVUxMLCBgbGFuZ3Vh
Z2VzX2xpc3RfcmVmZXJlbmNlYCBpbnQoMTApIE5PVCBOVUxMLA0KPiBgYXJ0aWNsZV90aXRsZWAg
dmFyY2hhcigyNTApIENPTExBVEUgdXRmOF91bmljb2RlX2NpIE5PVCBOVUxMLA0KPiBgYXJ0aWNs
ZWAgbG9uZ3RleHQgQ09MTEFURSB1dGY4X3VuaWNvZGVfY2kgTk9UIE5VTEwsIGBhcnRpY2xlX3N1
bW1hcnlgDQo+IHZhcmNoYXIoMjUwMCkgQ09MTEFURSB1dGY4X3VuaWNvZGVfY2kgTk9UIE5VTEws
IGByZW1lbWJlcl9uZXdfcG9zdGluZ2ANCj4gaW50KDEpIE5PVCBOVUxMIENPTU1FTlQgJzEtIFll
cyAmIDAtIE5vJywgYGRhdGVfc3VibWl0dGVkYCB0aW1lc3RhbXANCj4gTk9UIE5VTEwgREVGQVVM
VCBDVVJSRU5UX1RJTUVTVEFNUCwNCj4gYG1lbWJlcnNoaXBfcmVmZXJlbmNlX3BvaW50c19hd2Fy
ZGVkYCBpbnQoMTApIE5PVCBOVUxMLCBgYXBwcm92ZWRgDQo+IGludCgxKSBOT1QgTlVMTCwNCj4g
YGluYXBwcm9wcmlhdGVfY29udGVudF9mbGFnZ2VkX2J5X21lbWJlcnNoaXBfcmVmZXJlbmNlYCBp
bnQoMjUpIE5PVA0KPiBOVUxMLCBgaW5hcHByb3ByaWF0ZV9jb250ZW50X2ZsYWdfcmVhc29uc19y
ZWZlcmVuY2VgIGludCgyKSBOT1QgTlVMTCwNCj4gYGluYXBwcm9wcmlhdGVfY29udGVudF9mbGFn
X2NvbW1lbnRzYCB2YXJjaGFyKDI1MDApIENPTExBVEUNCj4gdXRmOF91bmljb2RlX2NpIE5PVCBO
VUxMLA0KPiBgaW5hcHByb3ByaWF0ZV9jb250ZW50X2ZsYWdnZWRfZGF0ZV9zdWJtaXR0ZWRgIGRh
dGV0aW1lIE5PVCBOVUxMLA0KPiBgaW5hcHByb3ByaWF0ZV9jb250ZW50X2ZsYWdfbW9kZXJhdG9y
X21lbWJlcnNoaXBfcmVmZXJlbmNlYCBpbnQoMjUpIE5PVA0KPiBOVUxMLCBgaW5hcHByb3ByaWF0
ZV9jb250ZW50X2ZsYWdfbW9kZXJhdG9yX2NvbW1lbnRzYCBsb25ndGV4dCBDT0xMQVRFDQo+IHV0
ZjhfdW5pY29kZV9jaSBOT1QgTlVMTCwNCj4gYGluYXBwcm9wcmlhdGVfY29udGVudF9mbGFnX21v
ZGVyYXRvcl9yZXZpZXdfZGF0ZWAgZGF0ZXRpbWUgTk9UIE5VTEwsDQo+IGBodG1sX2hlYWRfa2V5
d29yZF8xYCB2YXJjaGFyKDEwMCkgQ09MTEFURSB1dGY4X3VuaWNvZGVfY2kgTk9UIE5VTEwsDQo+
IGBodG1sX2hlYWRfa2V5d29yZF8yYCB2YXJjaGFyKDEwMCkgQ09MTEFURSB1dGY4X3VuaWNvZGVf
Y2kgTk9UIE5VTEwsDQo+IGBodG1sX2hlYWRfa2V5d29yZF8zYCB2YXJjaGFyKDEwMCkgQ09MTEFU
RSB1dGY4X3VuaWNvZGVfY2kgTk9UIE5VTEwsDQo+IGBodG1sX2hlYWRfa2V5d29yZF80YCB2YXJj
aGFyKDEwMCkgQ09MTEFURSB1dGY4X3VuaWNvZGVfY2kgTk9UIE5VTEwsDQo+IGBodG1sX2hlYWRf
a2V5d29yZF81YCB2YXJjaGFyKDEwMCkgQ09MTEFURSB1dGY4X3VuaWNvZGVfY2kgTk9UIE5VTEws
DQo+IGBodG1sX2hlYWRfZGVzY3JpcHRpb25gIHZhcmNoYXIoNTAwKSBDT0xMQVRFIHV0ZjhfdW5p
Y29kZV9jaSBOT1QgTlVMTCwNCj4gYHZpZXdzYCBiaWdpbnQoMjUwKSBOT1QgTlVMTCwgUFJJTUFS
WSBLRVkgKGByZWZlcmVuY2VgKQ0KPiANCj4gDQo+IFRoZSB0YWJsZSBzdHJ1Y3R1cmUgZm9yIGFy
dGljbGVzX2Rpc2N1c3Npb24NCj4gDQo+IENSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIGBhcnRp
Y2xlc19kaXNjdXNzaW9uYCAoIGByZWZlcmVuY2VgIGludCgyNSkNCj4gTk9UIE5VTEwgQVVUT19J
TkNSRU1FTlQsIGBhcnRpY2xlc19yZWZlcmVuY2VgIGludCgyNSkgTk9UIE5VTEwsDQo+IGBtZW1i
ZXJzaGlwX3JlZmVyZW5jZWAgaW50KDI1KSBOT1QgTlVMTCwgYCBsYW5ndWFnZXNfbGlzdF9yZWZl
cmVuY2VgDQo+IGludCgxMCkgTk9UIE5VTEwsIGBkaXNjdXNzaW9uYCBsb25ndGV4dCBDT0xMQVRF
IHV0ZjhfdW5pY29kZV9jaSBOT1QNCj4gTlVMTCwgYHJlbWVtYmVyX2Rpc2N1c3Npb25fcG9zdGlu
Z2AgaW50KDEpIE5PVCBOVUxMIENPTU1FTlQgJzEtIFllcyAmDQo+IDAtIE5vJywgYGRhdGVfc3Vi
bWl0dGVkYCB0aW1lc3RhbXAgTk9UIE5VTEwgREVGQVVMVCBDVVJSRU5UX1RJTUVTVEFNUCwNCj4g
YG1lbWJlcnNoaXBfcmVmZXJlbmNlX3BvaW50c19hd2FyZGVkYCBpbnQoMTApIE5PVCBOVUxMLCBg
YXBwcm92ZWRgDQo+IGludCgxKSBOT1QgTlVMTCBDT01NRU5UICcxLSBhdXRvIGFwcHJvdmFsOyAy
LSBmbGFnIGZvciByZXZpZXc7IDMtDQo+IHJldmlldyBhcHByb3ZhbDsgNC0gcmV2aWV3IGRlZW1l
ZCBpbmFwcHJvcHJpYXRlIGFuZCBwb3N0aW5nIG9mZmxpbmUnLA0KPiBgaW5hcHByb3ByaWF0ZV9j
b250ZW50X2ZsYWdnZWRfYnlfbWVtYmVyc2hpcF9yZWZlcmVuY2VgIGludCgyNSkgTk9UDQo+IE5V
TEwsIGBpbmFwcHJvcHJpYXRlX2NvbnRlbnRfZmxhZ19yZWFzb25zX3JlZmVyZW5jZWAgaW50KDIp
IE5PVCBOVUxMLA0KPiBgaW5hcHByb3ByaWF0ZV9jb250ZW50X2ZsYWdnZWRfY29tbWVudHNgIHZh
cmNoYXIoMjUwMCkgQ09MTEFURQ0KPiB1dGY4X3VuaWNvZGVfY2kgTk9UIE5VTEwsDQo+IGBpbmFw
cHJvcHJpYXRlX2NvbnRlbnRfZmxhZ2dlZF9kYXRlX3N1Ym1pdHRlZGAgZGF0ZXRpbWUgTk9UIE5V
TEwsDQo+IGBpbmFwcHJvcHJpYXRlX2NvbnRlbnRfZmxhZ19tb2RlcmF0b3JfbWVtYmVyc2hpcF9y
ZWZlcmVuY2VgIGludCgyNSkgTk9UDQo+IE5VTEwsIGBpbmFwcHJvcHJpYXRlX2NvbnRlbnRfZmxh
Z19tb2RlcmF0b3JfY29tbWVudHNgIGxvbmd0ZXh0IENPTExBVEUNCj4gdXRmOF91bmljb2RlX2Np
IE5PVCBOVUxMLA0KPiBgaW5hcHByb3ByaWF0ZV9jb250ZW50X2ZsYWdfbW9kZXJhdG9yX3Jldmll
d19kYXRlYCBkYXRldGltZSBOT1QgTlVMTCwNCj4gYHZpZXdzYCBiaWdpbnQoMjUwKSBOT1QgTlVM
TCwgUFJJTUFSWSBLRVkgKGByZWZlcmVuY2VgKQ0KPiANCj4gSSBhcHByZWNpYXRlIGFueSBoZWxw
IHlvdSBhcmUgYWJsZSB0byBnaXZlIG1lLg0KPiANCj4gUm9uIFBpZ2dvdHQNCj4gDQo+IA0KPiAN
Cj4gd3d3LlRoZVZlcnNlT2ZUaGVEYXkuaW5mbw0K