Perl length() returns the wrong value on array elements returned by fetchrow_arrayref() about dbdpg HOT 5 CLOSED

@masterchiefaragorn Thanks for reporting this! I found using git bisect that the bug was introduced between version 2.19.3 and 2.20.1_2 on 2 July 2013.

I added a unit test that demonstrates the problem and found a couple of ways to fix it in #73 and #74 and want to hear back from the primary author @turnstep on:

• which fix is better
• whether there could be negative side effects from them
• whether we need similar fixes elsewhere in the code

@machack666 You may be interested to take a look at this too.

from dbdpg.

@jonjensen, Thanks for jumping on this! It's likely not necessary to say this, but this bug also manifests for the more-oft-used fetch() method, since that is an alias to fetchrow_arrayref().

I'm surprised that our team has gone 7 years without encountering this.

from dbdpg.

Thanks, @jonjensen and @turnstep! I've rolled this out to one production server to see how it behaves in the real world.

from dbdpg.

This is now part of the 3.13.0 release

from dbdpg.

Sadly I can confirm this problem exists on Perl 5.22.0 + DBD::Pg 3.12.0 + Postgres 12. I used nearly your identical script.

The problem did not exist on Perl 5.14.1 + DBD::Pg 2.18.1 + Postgres 9.2.

from dbdpg.