Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13592: Optimizer throws out join constraint causing incorrect result - Mailing list pgsql-bugs

From Kristoffer Gustafsson
Subject Re: BUG #13592: Optimizer throws out join constraint causing incorrect result
Date
Msg-id DB5PR03MB11267FD4C24F019FD448F634C56F0@DB5PR03MB1126.eurprd03.prod.outlook.com
Whole thread Raw
In response to Re: BUG #13592: Optimizer throws out join constraint causing incorrect result  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
VG9tLCBEYXZpZCwNCllvdSBhcmUgY29ycmVjdC4gSSdtIHNvcnJ5LCBnb3R0ZW4gYWNjdXN0b21l
ZCB0byB0aGUgam9pbiBjcml0ZXJpYS90YWJsZSByZWxhdGlvbnNoaXAgdGFraW5nIGZpcnN0IHNl
YXQgb3ZlciBvdGhlciBleHByZXNzaW9uLg0KDQpKdXN0IHRvIGZpbGwgaW4sDQo+IEZvciBleGFt
cGxlLCBpZiBib3RoIEEgYW5kIEMgYXJlIHNtYWxsIGFuZCBib3RoIGNvdWxkIHVzZWZ1bGx5IGJl
IHVzZWQgaW4gYW4gaW5kZXhzY2FuIG9uIGEgbGFyZ2UgQiB0YWJsZSwgam9pbmluZyBBIHRvIEMg
Zmlyc3Qgd291bGQgbWFrZSBwZXJmZWN0IHNlbnNlLg0KDQpBIGlzIG11Y2ggbGFyZ2VyIHRoYW4g
QiBhbmQgQzsgQiBjb250YWlucyB0aGUgbGVhc3QgbnVtYmVyIG9mIGVudHJpZXMgKH42IGluIHRo
aXMgREIpOyBDIHNsaWdodGx5IGxhcmdlciB0aGFuIEIgKH42MCkuIFJlcG9ydCBpbmRpY2F0ZWQg
QiByZXF1aXJlZCBWYWN1dW0vQW5hbHl6ZSBzbyBJIGd1ZXNzIG9wdGltaXplciBzYXcgbW9yZSB0
aGFuIHRob3NlIH42Lg0KDQpHdWVzcyBmaXggd2lsbCBiZSBlaXRoZXIgc2ltaWxhciB0byBleGFt
cGxlIG9yIGZvcmNlIHRoZSBCL0MgcmVsYXRpb24gdG8gZXZhbHVhdGUgZmlyc3QgaW50byBELg0K
DQpBbHNvLCBJIGFwb2xvZ2l6ZSBmb3IgdGhlIGJsb2IgbWVzc2FnZSBpbmNsdWRlZCBhdCBlbmQg
b2YgbWFpbCwgaXQgaXMgYXR0YWNoZWQgYnkgc2VydmVyIG9uIG91dGdvaW5nIG1haWwuDQoNClJl
Z2FyZHMNCktyaXN0b2ZmZXIgR3VzdGFmc3Nvbg0KDQpfX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fXw0KDQoNCg0KRGV0dGEgbWVkZGVsYW5kZSBvY2ggYWxsYSBiaWxhZ29yIMOkciBrb25m
aWRlbnRpZWxsYSBvY2ggYXZzZWRkYSBmw7ZyIGRlbiBuYW1uZ2l2bmEgbW90dGFnYXJlbi4gT20g
ZHUgaGFyIGbDpXR0IGRldHRhIG1lZGRlbGFuZGUgYXYgbWlzc3RhZywgdsOkbmxpZ2VuIG1lZGRl
bGEgb21lZGVsYmFydCBhdnPDpG5kYXJlbiBvY2ggdGEgc2VkYW4gYm9ydCBtZWRkZWxhbmRldC4g
QWxsIG90aWxsw6V0ZW4gbW9kaWZpZXJpbmcsIGFudsOkbmRuaW5nIGVsbGVyIHNwcmlkbmluZyDD
pHIgZsO2cmJqdWRlbi4gQXZzw6RuZGFyZW4gw6RyIGludGUgYW5zdmFyaWcgZsO2ciBkZXR0YSBt
ZWRkZWxhbmRlIG9tIGRldCBoYXIgw6RuZHJhdHMsIGbDtnJmYWxza2F0cywgcmVkaWdlcmF0cywg
c21pdHRhdCBhdiBldHQgdmlydXMgZWxsZXIgc3ByaWRpdHMgdXRhbiB0aWxsc3TDpW5kLiBTa3Jp
diBpbnRlIHV0IGRldHRhIG1lZGRlbGFuZGUgb20gZGV0IGludGUgw6RyIG7DtmR2w6RuZGlndCwg
dMOkbmsgcMOlIG1pbGrDtm4uDQoNClRoaXMgbWVzc2FnZSBhbmQgYW55IGF0dGFjaG1lbnRzIGFy
ZSBjb25maWRlbnRpYWwgYW5kIGludGVuZGVkIGZvciB0aGUgbmFtZWQgYWRkcmVzc2VlKHMpIG9u
bHkuIElmIHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMgbWVzc2FnZSBpbiBlcnJvciwgcGxlYXNlIG5v
dGlmeSBpbW1lZGlhdGVseSB0aGUgc2VuZGVyLCB0aGVuIGRlbGV0ZSB0aGUgbWVzc2FnZS4gQW55
IHVuYXV0aG9yaXplZCBtb2RpZmljYXRpb24sIGVkaXRpb24sIHVzZSBvciBkaXNzZW1pbmF0aW9u
IGlzIHByb2hpYml0ZWQuIFRoZSBzZW5kZXIgaXMgbm90IGxpYWJsZSBmb3IgdGhpcyBtZXNzYWdl
IGlmIGl0IGhhcyBiZWVuIG1vZGlmaWVkLCBhbHRlcmVkLCBmYWxzaWZpZWQsIGluZmVjdGVkIGJ5
IGEgdmlydXMgb3IgZXZlbiBlZGl0ZWQgb3IgZGlzc2VtaW5hdGVkIHdpdGhvdXQgYXV0aG9yaXph
dGlvbi4gRG8gbm90IHByaW50IHRoaXMgbWVzc2FnZSB1bmxlc3MgaXQgaXMgbmVjZXNzYXJ5LCBj
b25zaWRlciB0aGUgZW52aXJvbm1lbnQuDQo=

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #13592: Optimizer throws out join constraint causing incorrect result
Next
From: smilodon100@hotmail.com
Date:
Subject: BUG #13593: ERROR: cannot find xlog functions