Subject: | Empty Postgres arrays not mapping to undef |
Reported by Alex Cheshev on the DBI mailing list.
$dbh->do("CREATE TABLE uno (dos integer[] DEFAULT '{}')");
$dbh->do("INSERT INTO uno DEFAULT VALUES");
$sth = $dbh->prepare("SELECT dos FROM uno");
$sth->execute();
print Dumper $sth->fetchall_arrayref();
Expected:
$VAR1 = [
[
[
undef
]
]
];
Actual:
Argument "" isn't numeric in subroutine entry...
$VAR1 = [
[
[
0
]
]
];