[Dbi-interbase-devel] "SELECT fieldname AS alias" doesn't work

[Michael S. <mi...@ch...>]

Hello dbi-interbase-devel,

my $sth = $dbh->prepare(
  "SELECT GOODS_NAME || '(' || GOODS_ID || ')' AS AAA FROM GOODS");
$sth->execute;
my $h = $sth->fetchrow_hashref;
print Dumper $h;
$sth = $dbh->prepare("SELECT GOODS_NAME,GOODS_ID FROM GOODS");
$sth->execute;
my $h = $sth->fetchrow_hashref;
print Dumper $h;

prints

$VAR1 = {
          '' => 'CPU Thomson 166 ST6x86P166+(1)'
        };
$VAR1 = {
          'GOODS_ID' => 1,
          'GOODS_NAME' => 'CPU Thomson 166 ST6x86P166+'
        };

Best regards,
 Michael                          mailto:mi...@ch...