From: | Oleg Bartunov <obartunov(at)gmail(dot)com> |
---|---|
To: | Erik Rijkers <er(at)xs4all(dot)nl> |
Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, David Wheeler <david(at)justatheory(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: nested hstore patch - FailedAssertion("!(value->array.nelems == 1) |
Date: | 2014-01-15 07:01:52 |
Message-ID: | CAF4Au4zzzVh-qXGxMVyABFgyEn34pRwRO=wfbCm_yEZGvkVZ1A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)xs4all(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2014-01-15 07:06:49 | Re: Turning recovery.conf into GUCs |
Previous Message | Jaime Casanova | 2014-01-15 07:00:51 | Re: Turning recovery.conf into GUCs |