| Subject: | method `values' gives inconsistent bind value |
I tested with code as following:
use SQL::Abstract;
use Data::Dumper qw(Dumper);
my $sql = SQL::Abstract->new;
my $row = { 'time' => ['now()']};
my ($stmt, @v1) = $sql->insert('table', $row);
my @v2 = $sql->values($row);
print Dumper(\@v1, \@v2), "\n";
Output:
$VAR1 = [];
$VAR2 = [
[
'now()'
]
];
So if the where clause contains array ref as field's value, the code snippet in
"PERFORMANCE" can not used.
I don't know whether this is a bug, but I think if it can fix it may be better.