BUG #14235: inconsistencies with IS NULL / IS NOT NULL - Mailing list pgsql-bugs
| From | andrew@tao11.riddles.org.uk |
|---|---|
| Subject | BUG #14235: inconsistencies with IS NULL / IS NOT NULL |
| Date | |
| Msg-id | 20160708024746.1410.57282@wrigleys.postgresql.org Whole thread Raw |
| Responses |
Re: BUG #14235: inconsistencies with IS NULL / IS NOT NULL
|
| List | pgsql-bugs |
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIzNQpMb2dnZWQgYnk6ICAg ICAgICAgIEFuZHJldyBHaWVydGgKRW1haWwgYWRkcmVzczogICAgICBhbmRy ZXdAdGFvMTEucmlkZGxlcy5vcmcudWsKUG9zdGdyZVNRTCB2ZXJzaW9uOiA5 LjZiZXRhMgpPcGVyYXRpbmcgc3lzdGVtOiAgIGFueQpEZXNjcmlwdGlvbjog ICAgICAgIAoKV2hpbGUgZGlzY3Vzc2luZyB0aGUgaXNzdWVzIHJlc3VsdGlu ZyBmcm9tIHRoZSBzcGVjJ3MgZGVmaW5pdGlvbiBvZiBJUyBOVUxMCmFuZCBJ UyBOT1QgTlVMTCBvbiBjb21wb3NpdGUgdmFsdWVzLCB3ZSBkaXNjb3ZlcmVk IHRoZSBmb2xsb3dpbmcKaW5jb25zaXN0ZW50IGNhc2VzLCBhbGwgb2Ygd2hp Y2ggYXBwZWFyIHRvIGJlIHRoZSBmYXVsdCBvZgpldmFsX2NvbnN0X2V4cHJl c3Npb25zLg0KDQpJbiBzaG9ydCwgdGhlIHRyYW5zZm9ybWF0aW9ucyBhcHBs aWVkIHRvIE51bGxUZXN0IG5vZGVzIGNoYW5nZSB0aGUKc2VtYW50aWNzLCB3 aGljaCBjYW4gdGhlbiBtYWtlIHRoZSBmaW5hbCByZXN1bHQgZGVwZW5kIG9u LCBmb3IgZXhhbXBsZSwKd2hldGhlciBmdW5jdGlvbiBjYWxscyB3ZXJlIGlu bGluZWQgb3Igbm90Lg0KDQoNCmNyZWF0ZSB0eXBlIGN0MSBhcyAoYSBpbnRl Z2VyLCBiIGludGVnZXIpOw0KY3JlYXRlIHR5cGUgY3QyIGFzIChhIGludGVn ZXIsIGIgY3QxKTsNCmNyZWF0ZSB0eXBlIGN0MyBhcyAoYSBpbnRlZ2VyLCBi IGN0Mik7DQoNCmNyZWF0ZSBmdW5jdGlvbiBtYWtlX2N0MShpbnRlZ2VyLGlu dGVnZXIpIHJldHVybnMgY3QxDQogIGxhbmd1YWdlIHNxbCBpbW11dGFibGUN CiAgYXMgJGYkIHNlbGVjdCByb3coJDEsJDIqJDIpOjpjdDE7ICRmJDsNCg0K Y3JlYXRlIGZ1bmN0aW9uIG1ha2VfY3QyKGludGVnZXIsaW50ZWdlcikgcmV0 dXJucyBjdDINCiAgbGFuZ3VhZ2Ugc3FsIGltbXV0YWJsZQ0KICBhcyAkZiQg c2VsZWN0IHJvdygkMSxyb3coJDIsJDIpOjpjdDEpOjpjdDI7ICRmJDsNCg0K Y3JlYXRlIGZ1bmN0aW9uIG1ha2VfY3QzKGludGVnZXIsaW50ZWdlcikgcmV0 dXJucyBjdDMNCiAgbGFuZ3VhZ2Ugc3FsIGltbXV0YWJsZQ0KICBhcyAkZiQg c2VsZWN0IHJvdygkMSxyb3coJDIscm93KCQyLCQyKTo6Y3QxKTo6Y3QyKTo6 Y3QzOyAkZiQ7DQoNCmNyZWF0ZSBmdW5jdGlvbiBzdGFibGVfbnVsbCgpIHJl dHVybnMgaW50ZWdlcg0KICBsYW5ndWFnZSBwbHBnc3FsIHN0YWJsZSBjb3N0 IDENCiAgYXMgJGYkIGJlZ2luIHJldHVybiBudWxsOyBlbmQ7ICRmJDsNCg0K Y3JlYXRlIGZ1bmN0aW9uIHZvbGF0aWxlX251bGwoKSByZXR1cm5zIGludGVn ZXINCiAgbGFuZ3VhZ2UgcGxwZ3NxbCB2b2xhdGlsZSBjb3N0IDEwMDANCiAg YXMgJGYkIGJlZ2luIHJldHVybiBudWxsOyBlbmQ7ICRmJDsNCg0Kc2VsZWN0 IHJvdyhudWxsLG51bGwpOjpjdDEgaXMgbnVsbCBhcyBjdDEsDQogICAgICAg cm93KG51bGwscm93KG51bGwsbnVsbCk6OmN0MSk6OmN0MiBpcyBudWxsIGFz IGN0MiwNCiAgICAgICByb3cobnVsbCxyb3cobnVsbCxyb3cobnVsbCxudWxs KTo6Y3QxKTo6Y3QyKTo6Y3QzIGlzIG51bGwgYXMgY3QzOw0KDQpzZWxlY3Qg cm93KDEsbnVsbCk6OmN0MSBpcyBub3QgbnVsbCBhcyByb3dfY29ucywNCiAg ICAgICAnKDEsKSc6OmN0MSBpcyBub3QgbnVsbCBhcyByb3dfbGl0ZXJhbCwN CiAgICAgICBtYWtlX2N0MSgxLG51bGwpIGlzIG5vdCBudWxsIGFzIGlubGlu ZWRfY29uc3QsDQogICAgICAgbWFrZV9jdDEoMSxzdGFibGVfbnVsbCgpKSBp cyBub3QgbnVsbCBhcyBpbmxpbmVkX2Z1bmMsDQogICAgICAgbWFrZV9jdDEo MSx2b2xhdGlsZV9udWxsKCkpIGlzIG5vdCBudWxsIGFzIGNhbGxlZF9mdW5j Ow0KDQpzZWxlY3Qgcm93KDEscm93KG51bGwsbnVsbCk6OmN0MSk6OmN0MiBp cyBub3QgbnVsbCBhcyByb3dfY29ucywNCiAgICAgICAnKDEsIigsKSIpJzo6 Y3QyIGlzIG5vdCBudWxsIGFzIHJvd19saXRlcmFsLA0KICAgICAgIG1ha2Vf Y3QyKDEsbnVsbCkgaXMgbm90IG51bGwgYXMgaW5saW5lZF9jb25zdCwNCiAg ICAgICBtYWtlX2N0MigxLHN0YWJsZV9udWxsKCkpIGlzIG5vdCBudWxsIGFz IGlubGluZWRfZnVuYywNCiAgICAgICBtYWtlX2N0MigxLHZvbGF0aWxlX251 bGwoKSkgaXMgbm90IG51bGwgYXMgY2FsbGVkX2Z1bmM7DQoNCnNlbGVjdCBy b3coMSxyb3cobnVsbCxyb3cobnVsbCxudWxsKTo6Y3QxKTo6Y3QyKTo6Y3Qz IGlzIG5vdCBudWxsIGFzCnJvd19jb25zLA0KICAgICAgICcoMSwiKCwiIigs KSIiKSIpJzo6Y3QzIGlzIG5vdCBudWxsIGFzIHJvd19saXRlcmFsLA0KICAg ICAgIG1ha2VfY3QzKDEsbnVsbCkgaXMgbm90IG51bGwgYXMgaW5saW5lZF9j b25zdCwNCiAgICAgICBtYWtlX2N0MygxLHN0YWJsZV9udWxsKCkpIGlzIG5v dCBudWxsIGFzIGlubGluZWRfZnVuYywNCiAgICAgICBtYWtlX2N0MygxLHZv bGF0aWxlX251bGwoKSkgaXMgbm90IG51bGwgYXMgY2FsbGVkX2Z1bmM7DQoN CnNlbGVjdCByb3cobnVsbCxudWxsKTo6Y3QxIGlzIG51bGwgYXMgcm93X2Nv bnMsDQogICAgICAgJygsKSc6OmN0MSBpcyBudWxsIGFzIHJvd19saXRlcmFs LA0KICAgICAgIG1ha2VfY3QxKG51bGwsbnVsbCkgaXMgbnVsbCBhcyBpbmxp bmVkX2NvbnN0LA0KICAgICAgIG1ha2VfY3QxKG51bGwsc3RhYmxlX251bGwo KSkgaXMgbnVsbCBhcyBpbmxpbmVkX2Z1bmMsDQogICAgICAgbWFrZV9jdDEo bnVsbCx2b2xhdGlsZV9udWxsKCkpIGlzIG51bGwgYXMgY2FsbGVkX2Z1bmM7 DQoNCnNlbGVjdCByb3cobnVsbCxyb3cobnVsbCxudWxsKTo6Y3QxKTo6Y3Qy IGlzIG51bGwgYXMgcm93X2NvbnMsDQogICAgICAgJygsIigsKSIpJzo6Y3Qy IGlzIG51bGwgYXMgcm93X2xpdGVyYWwsDQogICAgICAgbWFrZV9jdDIobnVs bCxudWxsKSBpcyBudWxsIGFzIGlubGluZWRfY29uc3QsDQogICAgICAgbWFr ZV9jdDIobnVsbCxzdGFibGVfbnVsbCgpKSBpcyBudWxsIGFzIGlubGluZWRf ZnVuYywNCiAgICAgICBtYWtlX2N0MihudWxsLHZvbGF0aWxlX251bGwoKSkg aXMgbnVsbCBhcyBjYWxsZWRfZnVuYzsNCg0Kc2VsZWN0IHJvdyhudWxsLHJv dyhudWxsLHJvdyhudWxsLG51bGwpOjpjdDEpOjpjdDIpOjpjdDMgaXMgbnVs bCBhcwpyb3dfY29ucywNCiAgICAgICAnKCwiKCwiIigsKSIiKSIpJzo6Y3Qz IGlzIG51bGwgYXMgcm93X2xpdGVyYWwsDQogICAgICAgbWFrZV9jdDMobnVs bCxudWxsKSBpcyBudWxsIGFzIGlubGluZWRfY29uc3QsDQogICAgICAgbWFr ZV9jdDMobnVsbCxzdGFibGVfbnVsbCgpKSBpcyBudWxsIGFzIGlubGluZWRf ZnVuYywNCiAgICAgICBtYWtlX2N0MyhudWxsLHZvbGF0aWxlX251bGwoKSkg aXMgbnVsbCBhcyBjYWxsZWRfZnVuYzsNCg0KDQoKCg==
pgsql-bugs by date: