Postgres Pro
Downloads
Home   >   mailing lists

BUG #14449: inconsistency in behaviour of json/jsonb returning functions for sql NULL and json NULL values - Mailing list pgsql-bugs

From rainer.steinmueller@kit.edu
Subject BUG #14449: inconsistency in behaviour of json/jsonb returning functions for sql NULL and json NULL values
Date
Msg-id 20161205175354.4360.29511@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14449: inconsistency in behaviour of json/jsonb returning functions for sql NULL and json NULL values
List pgsql-bugs
Tree view 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQ0OQpMb2dnZWQgYnk6ICAg
ICAgICAgIFJhaW5lciBTdGVpbm3DvGxsZXIKRW1haWwgYWRkcmVzczogICAg
ICByYWluZXIuc3RlaW5tdWVsbGVyQGtpdC5lZHUKUG9zdGdyZVNRTCB2ZXJz
aW9uOiA5LjYuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiAzLjE2LjM2
LTErZGViOHUyIHg4Nl82NCBHTlUvTGludXgKRGVzY3JpcHRpb246ICAgICAg
ICAKCiMgYWxsIHRoZSBmb2xsb3dpbmcgc3FsIHN0YXRlbWVudHMgYXJlIHRl
c3RlZCB3aXRoIHBzcWwuDQojIHRyeSB0byBjYXN0IG9yIHRvIGNvbnZlcnQg
YSBzcWwgTlVMTCB2YWx1ZSB0byBqc29uL2pzb25iIG51bGwgZG9lcyBub3QK
Z2VuZXJhdGUgdGhlIGRlc2lyZWQgcmVzdWx0Og0KDQpuZXQ9PiBzZWxlY3Qg
dG9fanNvbmIobnVsbDo6dGV4dCk7DQogdG9fanNvbmINCi0tLS0tLS0tLS0N
Cg0KKDEgcm93KQ0KDQojIHRoaXMgaXMgdGhlIGNvcnJlY3QgcmVzdWx0Og0K
DQpuZXQ9PiBzZWxlY3QganNvbmJfYnVpbGRfb2JqZWN0KCdmMScsIG51bGwp
IC0+ICdmMSc7DQogP2NvbHVtbj8NCi0tLS0tLS0tLS0NCiBudWxsDQooMSBy
b3cpDQoNCg0KIyB0aGUgc2FtZSBiZWhhdmlvdXIgZm9yIG1hbmlwdWxhdGlu
ZyBqc29uYjoNCiMgdGhpcyBzdGF0ZW1lbnQgZG9lcyBub3QgZ2VuZXJhdGUg
dGhlIGRlc2lyZWQgcmVzdWx0IGFuZCB3b3JzdCwgaXQgZGVzdHJveXMKdGhl
IHdob2xlIGpzb25iIGRhdGE6DQoNCm5ldD0+IHNlbGVjdCBqc29uYl9zZXQo
J3siZjEiOjEsImYyIjoiYWJjIn0nLCAne2YxfScsIG51bGwpOw0KIGpzb25i
X3NldA0KLS0tLS0tLS0tLS0NCg0KKDEgcm93KQ0KDQojIHRoZSBmb2xsb3dp
bmcgZG9lcyB3ZWxsIChidXQgd29ya3Mgb25seSBmb3IganNvbmIgZHVlIHRv
IHRoZSB8fApvcGVyYXRvcik6DQoNCm5ldD0+IHNlbGVjdCAneyJmMSI6MSwi
ZjIiOiJhYmMifSc6Ompzb25iIHx8IGpzb25iX2J1aWxkX29iamVjdCgnZjEn
LApudWxsKTsNCiAgICAgICAgID9jb2x1bW4/DQotLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0NCiB7ImYxIjogbnVsbCwgImYyIjogImFiYyJ9DQooMSBy
b3cpDQoNCiMgcHJvYmxlbTogaG93IHRvIHNldCBhIGpzb25iIG51bGwgdmFs
dWUgb3ZlciBtb3JlIHRoYW4gMSBsZXZlbCAodGhlIHBhdGgKYXJyYXkgaW4g
YXJnMiBoYXMgbW9yZSB0aGFuIDEgZWxlbWVudCkgbGlrZSB0aGlzOg0KIyBz
ZWxlY3QganNvbmJfc2V0KCd7ImYxIjoxLCJmMiI6ImFiYyIsImYzIjoge319
JywgJ3tmMyxmNH0nLCBudWxsKTsNCg0KIyBpbiBteSBvcGluaW9uLCBqc29u
L2pzb25iIHJldHVybmluZyBmdW5jdGlvbnMNCiMgdG9fanNvbigpLCB0b19q
c29uYigpLCBqc29uYl9zZXQoKSwganNvbmJfaW5zZXJ0KCkNCiMgc2hvdWxk
IG5ldmVyIHJldHVybiBzcWwgbnVsbCB2YWx1ZXMgaWYgdGhleSByZWNlaXZl
IGEgc3FsIG51bGwgYXJndW1lbnQKKGFzIHZhbHVlIHRoYXQgaXMgdG8gY29u
dmVydCBpbXBsaWNpdGx5KS4NCgoK

pgsql-bugs by date:

Previous
From: VICTOR MIGUEL MORALES CAYUELA
Date:
Subject: Re: Segmentation fault in PQexec
Next
From: Tom Lane
Date:
Subject: Re: BUG #14448: create table as values - type check skipped