Bug#311788: libdbd-csv-perl: Error when "update tbl set a = a + 1;"
SUGITA Toshinori
SUGITA Toshinori <sugita@d-pad.co.jp>, 311788@bugs.debian.org
Fri, 03 Jun 2005 20:24:55 +0900
Package: libdbd-csv-perl
Version: 0.2100-2
Severity: normal
my perl script get error in bellow SQL statement
update tbl set a = a + 1;
when use column name in right side.
I remember that SQL statement had done correctly in Feb/2005.
Error message is:
DBD::CSV::db do failed: Can't use an undefined value as an ARRAY reference at /usr/share/perl5/SQL/Statement.pm line 1772, <GEN3> line 2.
[for Statement "update test set b = b + 1"] at test.pl line 7.
that test code is:
--
#!/usr/bin/perl
use DBI;
my $dbh = DBI->connect("DBI:CSV:f_dir=.");
$dbh->do("create table test (a int, b int, c int, d int)");
$dbh->do("insert into test values (0, 0, 0, 0)");
$dbh->do("update test set a = 1");
$dbh->do("update test set b = b + 1");
--
-- System Information:
Debian Release: 3.1
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.10
Locale: LANG=ja_JP.eucJP, LC_CTYPE=ja_JP.eucJP (charmap=EUC-JP) (ignored: LC_ALL set to ja_JP.eucJP)
Versions of packages libdbd-csv-perl depends on:
ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu
ii libsql-statement-perl 1.14-1 perl SQL::Statement - SQL parsing
ii libtext-csv-perl 0.23-5 perl Text::CSV_XS - comma-separate
ii perl 5.8.4-8 Larry Wall's Practical Extraction
-- no debconf information