Re: Bug in jsonb minus operator

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in jsonb minus operator
Date: 2015-05-18 01:08:05
Message-ID: CAM3SWZSrh-60HKXfnvxpczUDb7Gbtq8M51sSpbpM9SgcXOZqCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, May 17, 2015 at 8:04 AM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> Sure. I thought we'd covered this but it's possible that we didn't, or that
> it got rebroken. There have been complaints about the limitation on values
> containing jbvBinary, so let's just remove it if that can be done simply, as
> it seems to be a not uncommonly encountered problem.
>
> Are you going to submit a patch for that?

I'll try and come up with something. It's not a trivial fix.

> Assuming the above fix we won't have to teach it anything new, right?

I'm not 100% sure, but I think not.

>> On that topic, I think it's sloppy that "Table
>> 9-41. Additional jsonb Operators" isn't clear about the fact that the
>> "operator - text" op matches things on the same basis as the existence
>> operators -- notice how the existence operator notes with emphasis
>> that it cares about array *string* values only.
>
>
> OK, please submit a patch that you think clears it up.

I was going to better document the new operators anyway, so I'll get
this in passing.

> The heading on jsonb_op.c (note spelling) suggests that it's for indexed
> operations. I don't mind rearranging the code layout to something people
> think more logical, but I also don't want to engage in unnecessary code
> churn. I'm not that religious about the organization.

I see what you mean.

> It was always known that some cases would not work with TESTS - that was
> part of Tom's reservation about the whole thing. You can say

Sure, but you added it, and you mentioned jsonb in the commit message,
before jsonb was even committed to the master branch. :-)

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-05-18 01:31:09 DROP TRANSFORM parsetree representation is no good
Previous Message Haribabu Kommi 2015-05-18 00:58:08 Re: Parallel Seq Scan