Re: Quoting of values in arrays in broken in DBD::Pg, can you help fix it? ( CPAN RT#58552 ) [SumsaultRT #9386]

Mark Stosberg <mark-WmyhgDpj2fCHT8/[email protected]> Sat, 08 Oct 2011 21:39:50 -0400
Newsgroups gmane.comp.db.postgresql.dbdpg
Message-ID <[email protected]>
On 10/07/2011 04:59 PM, Tim Landscheidt wrote:
> mark-WmyhgDpj2fCHT8/[email protected] (Mark Stosberg) wrote:
> 
>> If you use DBD::Pg and also use PostgreSQL arrays, you should be aware
>> there is an open bug with quoting PostgreSQL array values. A bug report
>> about the issue is here, including some related test cases and work on
>> some patches:
> 
>> https://rt.cpan.org/Public/Bug/Display.html?id=58552
> 
>> However, the proposed fix is not passing all the test cases. The
>> solution will need someone with XS skills, who also has confidence about
>> exactly what the correct quoting behavior should be.
> 
>> I'm affected by the issue and would personally appreciate the help.
> 
> First, I wholeheartedly agree that Noah's patch should fi-
> nally be integrated. It's always a pleasure to see when
> someone presents a working solution to a real problem, and
> very sad if that is then shelved for now over a year :-(.
> 
>   But I cannot reproduce your problem with 2.17.1 + Noah's
> patch:

Thanks for the reply, Tim.

My problem with Noah's patch is that it didn't find the new test that I
added to the ticket.

https://rt.cpan.org/Ticket/Attacahment/973506/506656/

So, either my test is wrong, or Noah's patch is incomplete. Could you
help confirm which is the case?

    Mark