BUG #15999: jsonb_populate_record fails with array column

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15999: jsonb_populate_record fails with array column

PG Doc comments form
The following bug has been logged on the website:

Bug reference:      15999
Logged by:          Richard
Email address:      [hidden email]
PostgreSQL version: 9.6.15
Operating system:   Debian / Windows
Description:        

given the following simplified table with one row inserted:

> create table testa ( id serial, test text[] default
'{"test","test2"}'::text[] );
> insert into testa values (default);

when we try to populate a record of testa type we run into trouble with
postgres in version 9.6.15

> select jsonb_populate_record(null::testa , to_jsonb(testa))  FROM testa;
ERROR:  22P02: malformed array literal: "["test", "test2"]"
DETAIL:  "[" must introduce explicitly-specified array dimensions.
LOCATION:  array_in, arrayfuncs.c:269

with postgres 10 and higher we get the expected result:

> select jsonb_populate_record(null::testa , to_jsonb(testa))  FROM testa;
jsonb_populate_record
═════════════════════
(1,"{test,test2}")
(1 row)

whe the array column is null, and therefor no contained array in the jsonb
representation, everything works fine under 9.6.15

> update testa set test = null;
> select jsonb_populate_record(null::testa , to_jsonb(testa))  FROM testa;
jsonb_populate_record
═════════════════════
(1,)
(1 row)

Reply | Threaded
Open this post in threaded view
|

Re: BUG #15999: jsonb_populate_record fails with array column

Tom Lane-2
PG Bug reporting form <[hidden email]> writes:
> given the following simplified table with one row inserted:

>> create table testa ( id serial, test text[] default
> '{"test","test2"}'::text[] );
>> insert into testa values (default);

> when we try to populate a record of testa type we run into trouble with
> postgres in version 9.6.15

>> select jsonb_populate_record(null::testa , to_jsonb(testa))  FROM testa;
> ERROR:  22P02: malformed array literal: "["test", "test2"]"
> DETAIL:  "[" must introduce explicitly-specified array dimensions.
> LOCATION:  array_in, arrayfuncs.c:269

Yeah, this is something we aren't going to risk changing pre-v10.
cf35346e8 is what fixed it, but that was a pretty massive rewrite
with bugs of its own, and IIRC it changed some other behaviors
that were less obviously bugs than the case you're complaining of.

                        regards, tom lane