Postgres Pro
Downloads
Home   >   mailing lists

BUG #14205: Weird cast long int values to numeric leading to seq scan - Mailing list pgsql-bugs

From maxim.boguk@gmail.com
Subject BUG #14205: Weird cast long int values to numeric leading to seq scan
Date
Msg-id 20160621144200.5792.49545@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14205: Weird cast long int values to numeric leading to seq scan  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIwNQpMb2dnZWQgYnk6ICAg
ICAgICAgIE1ha3N5bSBCb2d1awpFbWFpbCBhZGRyZXNzOiAgICAgIG1heGlt
LmJvZ3VrQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS4zCk9w
ZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246ICAgICAgICAK
CklmIGFuIGlucHV0IHZhbHVlIG9mIHRoZSBmaWVsZD12YWx1ZSBnb2VzIG92
ZXIgYmlnaW50IHJhbmdlLCB0aGUgZGF0YWJhc2UKc3dpdGNoZXMgdG8gdGhl
IGZpZWxkOjpudW1lcmljPXZhbHVlOjpudW1lcmljIHBsYW4sIHdoaWNoIGxl
YWRzIHRvIHRoZSBzZXEKc2NhbiBhcyByZXN1bHQuDQoNClRoZXJlIGlzIHR3
byBxdWVyeSB3aGVyZSBwcm9ibGVtIHZpc2libGUgKGlkIGFueSBvZiBpbnQv
YmlnaW50KToNCkdvb2Qgb25lIChpbmRleCBzY2FuKToNCmV4cGxhaW4gc2Vs
ZWN0ICogZnJvbSBqb2JzIHdoZXJlIGlkPTEwMDAwMDAwMDAwMDAwMDAwMDA7
DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTg0K
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogSW5kZXggU2NhbiB1c2lu
ZyBqb2JzX3BrZXkgb24gam9icyAgKGNvc3Q9MC41Ny4uMC43OSByb3dzPTEg
d2lkdGg9NTI3KQ0KICAgSW5kZXggQ29uZDogKGlkID0gJzEwMDAwMDAwMDAw
MDAwMDAwMDAnOjpiaWdpbnQpDQoNCg0KQmFkIG9uZSAocGxlYXNlIG5vdGUg
dGhlIHNlcSBzY2FuIGFuZCByb3dzIGVzdGltYXRpb24pOg0KZXhwbGFpbiBz
ZWxlY3QgKiBmcm9tIGpvYnMgd2hlcmUgaWQ9MTAwMDAwMDAwMDAwMDAwMDAw
MDA7DQogICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFODQot
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFNlcSBTY2FuIG9uIGpvYnMgIChjb3N0
PTAuMDAuLjI3MjI5MjUuMjAgcm93cz02NDU3MDAgd2lkdGg9NTI3KQ0KICAg
RmlsdGVyOiAoKGlkKTo6bnVtZXJpYyA9ICcxMDAwMDAwMDAwMDAwMDAwMDAw
MCc6Om51bWVyaWMpDQoNClRoaXMgcHJvYmxlbSBiZWhhdmlvciBzdGF5cyB0
aGUgc2FtZSBvdmVyIGFsbCByYW5nZSA5LjIgLSA5LjUgdmVyc2lvbnMuDQpJ
dCBwcm92aWRlcyBhbiBlYXN5IHdheSB0byBEb1MgdGhlIGRhdGFiYXNlL3By
b2plY3QgKDUtMTAtMjAgc2VxIHNjYW4gb3ZlcgpsYXJnZSB0YWJsZSB1c3Vh
bGx5IG1lYW4gdG8gdW5yZXNwb25zaXZlIGRhdGFiYXNlIGJlY2F1c2UgSU8g
b3IgQ1BVCm92ZXJsb2FkKS4NCg0KVGhpcyBwcm9ibGVtIGRvZXNuJ3QgYWZm
ZWN0IHNlcnZlciBzaWRlIHByZXBhcmVkIHF1ZXJpZXMgd2l0aCBwbGFjZWhv
bGRlcnMsCmJ1dCBnaXZlbiBhbG1vc3QgdWJpcXVpdG91cyB1c2FnZSBvZiB0
aGUgcGdib3VuY2VyIGluIG1ham9yaXR5IG9mIHRoZSB3ZWIKcHJvamVjdHMg
dGhlIHNlcnZlciBzaWRlIHByZXBhcmVkIGRpc2FibGVkIGFsbW9zdCBldmVy
eXdoZXJlLg0KDQpJIGRvbid0IGtub3cgaXMgaXQgJ3dvcmsgYXMgZGVzaWdu
ZWQnIG9yIHJlc3VsdCBvZiBzb21lIG92ZXJzaWdodCwgYnV0IElNSE8KY3Vy
cmVudCBiZWhhdmlvciBicm9rZW4gZnJvbSBjb21tb24gc2Vuc2UgcG9pbnQg
b2YgdmlldyAoZXZlbiBpZiBwcm92aWRlcwpjb3JyZWN0IGVtcHR5IHJlc3Vs
dCwgYWZ0ZXIgc2VxdWVudGlhbGx5IHNjYW5uaW5nIHdob2xlIDEwMEdiIHRh
YmxlKS4NCg0KUFM6IEkga25vdyB0aGF0IGl0IGdvb2QgcHJhY3RpY2UgdG8g
dmFsaWRhdGUgaW5wdXQgYmVmb3JlIHNlbmQgaXQgdG8gdGhlCmRhdGFiYXNl
IGluIGFueSBjYXNlLCBidXQgZnJvbSBteSBleHBlcmllbmNlIHRoZSBiZXN0
IHdoYXQgSSBldmVyIHNlZW4gaW4KcmVhbCBwcm9qZWN0cyBpdCB2ZXJpZmlj
YXRpb24gaW5wdXQgdmFsdWUgdmlhIC9eXGQrJC8gd2hpY2ggcHJvdmlkZSBu
byByZWFsCnByb3RlY3Rpb24gYWdhaW4gdGhpcyBpc3N1ZS4NCgoK

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #14204: COMPATIBILITY
Next
From: Tom Lane
Date:
Subject: Re: BUG #14205: Weird cast long int values to numeric leading to seq scan