BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't

Поиск
Список
Период
Сортировка
От hcate3@gmail.com
Тема BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't
Дата
Msg-id 20161010185622.1398.15066@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM2MwpMb2dnZWQgYnk6ICAg
ICAgICAgIEhlbnJ5IENhdGUKRW1haWwgYWRkcmVzczogICAgICBoY2F0ZTNA
Z21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogOS41LjIKT3BlcmF0aW5n
IHN5c3RlbTogICB4ODZfNjQtcGMtbGludXgtZ251CkRlc2NyaXB0aW9uOiAg
ICAgICAgCgpXaXRoIHRoaXMgc2V0dXA6DQoNCmRyb3AgdGFibGUgaWYgZXhp
c3RzIHQyOw0KY3JlYXRlIHRhYmxlIHQyICgNCiAgb3JkZXJfa2V5IGludCwN
CiAgZGVjaW1hbF85XzEgICAgIGRlY2ltYWwoOSwxKSwNCiAgZGVjaW1hbF8x
OF8xICAgIGRlY2ltYWwoMTgsMSkpOw0KDQppbnNlcnQgaW50byB0MiB2YWx1
ZXMgKDMsIDkwMS44LCBudWxsKTsNCg0KDQpUaGlzIHF1ZXJ5Og0KDQpzZWxl
Y3QgZGVjaW1hbF85XzEsIGRlY2ltYWxfMThfMSwgKCANCiAgY2FzZSBkZWNp
bWFsXzlfMSANCiAgICAgd2hlbiBudWxsIHRoZW4gMCANCiAgICAgd2hlbiBk
ZWNpbWFsXzlfMSAgdGhlbiAxIGVuZCksICANCiAgY2FzZSAoIA0KICAgIGNh
c2UgZGVjaW1hbF85XzEgDQogICAgICB3aGVuIG51bGwgdGhlbiAwIA0KICAg
ICAgd2hlbiBkZWNpbWFsXzlfMSAgdGhlbiAxIGVuZCkNCiAgICB3aGVuIDEg
dGhlbiAyDQogICAgd2hlbiAwIHRoZW4gMw0KICBlbmQsICANCiAgY2FzZSAo
IA0KICAgIGNhc2UgZGVjaW1hbF85XzEgDQogICAgICB3aGVuIGRlY2ltYWxf
MThfMSB0aGVuIDAgDQogICAgICB3aGVuIGRlY2ltYWxfOV8xICB0aGVuIDEg
ZW5kKQ0KICAgIHdoZW4gMSB0aGVuIDINCiAgICB3aGVuIDAgdGhlbiAzDQog
IGVuZA0KZnJvbSB0MiA7DQoNCg0KcHJvZHVjZXMgdGhlc2UgcmVzdWx0czoN
Cg0KIGRlY2ltYWxfOV8xIHwgZGVjaW1hbF8xOF8xIHwgY2FzZSB8IGNhc2Ug
fCAgY2FzZSAgDQotLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0t
LSstLS0tLS0rLS0tLS0tLS0NCiAgICAgICA5MDEuOCB8ICAgICAgIDxudWxs
PiB8ICAgIDEgfCAgICAyIHwgPG51bGw+DQooMSByb3cpDQoNCg0KSSBleHBl
Y3QgdGhlIGxhc3QgdHdvIGNvbHVtbnMgdG8gYm90aCBoYXZlIGEgdmFsdWUg
b2YgMi4gIA0KDQpUaGUgZm91cnRoIGNvbHVtbiBjb21wYXJlcyB0aGUgcmVz
dWx0IG9mIHRoZSBpbm5lciBjYXNlIHN0YXRlbWVudCB0byBOVUxMCmFuZCBw
cm9kdWNlcyB0aGUgY29ycmVjdCByZXN1bHQuICBUaGUgbGFzdCBjb2x1bW4g
Y29tcGFyZXMgdG8gYSBjb2x1bW4gd2hpY2gKZG9lcyBoYXZlIE5VTEwsIGJ1
dCBzb21lIGhvdyBQb3N0Z3JlcyBnZXRzIGNvbmZ1c2VkIGFuZCByZXR1cm5z
IE5VTEwuICBJdApzaG91bGQgYWxzbyBiZSByZXR1cm5pbmcgMi4NCg0KDQoN
CkhlcmUgaXMgdGhlIHZlcnNpb24gaW5mb3JtYXRpb246DQoNCnliZF90ZXN0
PSMgc2VsZWN0IHZlcnNpb24oKTsNCiAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHZlcnNpb24gICAgICAg
ICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFBvc3RncmVTUUwg
OS41LjIgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgY2xh
bmcgdmVyc2lvbgozLjguMC0ydWJ1bnR1MyAodGFncy9SRUxFQVNFXzM4MC9m
aW5hbCksIDY0LWJpdA0KKDEgcm93KQ0KCgo=

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't