It doesn't crashed in the last version in our repository.
=# select 'x'::hstore || ('a=>"1"':: hstore) ; ?column?
---------------"x", "a", "1"
(1 row)
On Wed, Jan 15, 2014 at 3:53 AM, Erik Rijkers <er@xs4all.nl> wrote:
> On Mon, January 13, 2014 16:36, Andrew Dunstan wrote:
>> A new version of the patch is attached. It includes all of Erik's docs
>
>> [ nested_hstore_and_jsonb-2.patch ]
>
>
> This crashes the server:
>
> testdb=# select 'x' || ('a=>"1"':: hstore) ;
> The connection to the server was lost. Attempting reset: Failed.
>
> logging:
> TRAP: FailedAssertion("!(value->array.nelems == 1)", File: "jsonb_support.c", Line: 904)
> 2014-01-15 00:32:01.854 CET 1206 LOG: server process (PID 3918) was terminated by signal 6: Aborted
> 2014-01-15 00:32:01.854 CET 1206 DETAIL: Failed process was running: select 'x' || ('a=>"1"':: hstore) ;
>
>
> Btw, I find it strange that:
>
> testdb=# select ('a=>""':: hstore) #%> '{a}' ;
> ?column?
> ----------
> ""
> (1 row)
>
> so that:
>
> Time: 0.641 ms
> testdb=# select ( ('a=>""':: hstore) #%> '{a}' ) = '' ;
> ?column?
> ----------
> f
> (1 row)
>
> testdb=# select ( ('a=>""':: hstore) #%> '{a}' ) = '""' ;
> ?column?
> ----------
> t
> (1 row)
>
> Maybe there is a rationale, but it seems to me that
> ('a=>""':: hstore) #%> '{a}'
> should deliver the empty string '', and not two double quotes.
>
>
> Thanks,
>
> Erik Rijkers
>
>
>
>
>
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers