Re: DBD::Pg 3.3.0 released (driver for Postgres)

On Mon, 2 Jun 2014 13:19:56 -0400, Greg Sabino Mullane
<[email protected]> wrote:

> Version 3.3.0 of DBD::Pg, DBI driver for PostgreSQL, is
> now available. This release enhances UTF-8 support a
> great deal, thanks to the work of Dagfinn Ilmari Mannsåker
> and Nicholas Clark. As always, you can find it on CPAN at:

I am unsure yet if I see this new UTF8 support as improvement for the
general public. An example:

--8<--- dbd-pg3.pl
#!/pro/bin/perl

use 5.18.2;
use warnings;

use DBI;

my $dbh = DBI->connect ("dbi:Pg:");
$dbh->{AutoCommit} = 1;

say "Connected with DBI-$DBI::VERSION using DBD::Pg-$DBD::Pg::VERSION (",
    $dbh->{pg_lib_version}, " -> ", $dbh->{pg_server_version}, ")";

$dbh->do ("create temp table hash (c_hash bytea primary key, v_hash bytea)");

my $stt = $dbh->prepare ("select * from hash");
   $stt->execute;
my @typ = @{$stt->{TYPE}};
   $stt->finish;
my $sth = $dbh->prepare ("insert into hash values (?, ?)");
   $sth->bind_param (1, undef, $typ[0]);
   $sth->bind_param (2, undef, $typ[1]);

say "c_hash $typ[0]\nv_hash $typ[1]";

$sth->execute ("key", "value");
$sth->execute ("eur", "\x{20ac}");

$sth->finish;
$dbh->do ("drop table hash");
$dbh->disconnect;
-->8---

Connected with DBI-1.631 using DBD::Pg-2.18.1 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-2.19.0 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-2.19.1 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-2.19.2 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-2.19.3 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.0.0 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.1.0 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.1.1 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.2.0 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.2.1 (90304 -> 90304)
c_hash -3
v_hash -3
Connected with DBI-1.631 using DBD::Pg-3.3.0 (90304 -> 90304)
c_hash -3
v_hash -3
Wide character in subroutine entry at /home/merijn/dbd-pg3.pl line 27.
Exit 255

That does *not* make me happy

> http://search.cpan.org/dist/DBD-Pg/
> 
> Checksums:
> 
> 547de1382a47d66872912fe64282ff55  DBD-Pg-3.3.0.tar.gz
> 9ec52d0d75463e6a448760e2d2fcbc41ca6201e1  DBD-Pg-3.3.0.tar.gz
> 
> Complete list of changes:
> 
> Version 3.3.0  Released May 31, 2014 (git commit 055f788cf96b380b9fe0e80b6cedb88f8d1799b8)
> 
>   - Major cleanup of UTF-8 support:
>       Fix quoting of UTF-8 values
>       Add support for UTF-8 statement strings
>       Fix UTF-8 support in placeholders and return values
>     [Dagfinn Ilmari Mannsåker] (CPAN bug #95214 and #91655)
>       Test that the Pg server agrees with us about the lengths of input strings.
>       Refactor Unicode test to use anon hashes to describe the tests to run.
>       Test pg_enable_utf8 of -1, in addition to 0 and 1.
>       Extend the Unicode round-trip tests to verify ASCII, BMP and non-BMP code points.
>       Test that characters created in the server reach the client correctly.
> 
>   - Rewrite foreign_key_info to be just one query
>     [Dagfinn Ilmari Mannsåker]
> 
>   - Remove ODBC support from foreign_key_info
>     [Dagfinn Ilmari Mannsåker]
> 
>   - Remove use of dTHX in functions in quote.c and types.c
>     [Nicholas Clark]

-- 
H.Merijn Brand    [email protected]   (072) 567 13 51
PROCURA B.V.    http://www.procura.nl    KvK 37140650
Ban de e-mail disclaimers:  http://tinyurl.com/kmne65