Bug#311788: marked as done (libdbd-csv-perl: Error when "update tbl set a = a + 1; ")

Debian Bug Tracking System owner at bugs.debian.org
Mon Jan 2 18:18:15 UTC 2006

Your message dated Mon, 02 Jan 2006 10:02:13 -0800
with message-id <E1EtU0b-0001wN-Pj at spohr.debian.org>
and subject line Bug#311788: fixed in libsql-statement-perl 1.14-2
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

Received: (at submit) by bugs.debian.org; 3 Jun 2005 11:24:53 +0000
>From sugita at d-pad.co.jp Fri Jun 03 04:24:53 2005
Return-path: <sugita at d-pad.co.jp>
Received: from ns.d-pad.co.jp (mail.d-pad.co.jp) [] 
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1DeAIH-0003e6-00; Fri, 03 Jun 2005 04:24:53 -0700
Received: from cabin.d-pad.local (cabin.d-pad.local [])
	by mail.d-pad.co.jp (Postfix) with ESMTP id 22F48310EE8;
	Fri,  3 Jun 2005 20:24:51 +0900 (JST)
Received: by cabin.d-pad.local (Postfix, from userid 1000)
	id 98B38FA862; Fri,  3 Jun 2005 20:24:55 +0900 (JST)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: SUGITA Toshinori <sugita at d-pad.co.jp>
To: Debian Bug Tracking System <submit at bugs.debian.org>
Subject: libdbd-csv-perl: Error when "update tbl set a = a + 1;"
X-Mailer: reportbug 3.12
Date: Fri, 03 Jun 2005 20:24:55 +0900
Message-Id: <20050603112455.98B38FA862 at cabin.d-pad.local>
Delivered-To: submit at bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE 
	autolearn=no version=2.60-bugs.debian.org_2005_01_02

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:
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

Received: (at 311788-close) by bugs.debian.org; 2 Jan 2006 18:10:43 +0000
>From katie at ftp-master.debian.org Mon Jan 02 10:10:43 2006
Return-path: <katie at ftp-master.debian.org>
Received: from katie by spohr.debian.org with local (Exim 4.50)
	id 1EtU0b-0001wN-Pj; Mon, 02 Jan 2006 10:02:13 -0800
From: Gunnar Wolf <gwolf at debian.org>
To: 311788-close at bugs.debian.org
X-Katie: $Revision: 1.65 $
Subject: Bug#311788: fixed in libsql-statement-perl 1.14-2
Message-Id: <E1EtU0b-0001wN-Pj at spohr.debian.org>
Sender: Archive Administrator <katie at ftp-master.debian.org>
Date: Mon, 02 Jan 2006 10:02:13 -0800
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER 
	autolearn=no version=2.60-bugs.debian.org_2005_01_02

Source: libsql-statement-perl
Source-Version: 1.14-2

We believe that the bug you reported is fixed in the latest version of
libsql-statement-perl, which is due to be installed in the Debian FTP archive:

  to pool/main/libs/libsql-statement-perl/libsql-statement-perl_1.14-2.diff.gz
  to pool/main/libs/libsql-statement-perl/libsql-statement-perl_1.14-2.dsc
  to pool/main/libs/libsql-statement-perl/libsql-statement-perl_1.14-2_all.deb

A summary of the changes between this version and the previous one is

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 311788 at bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
Gunnar Wolf <gwolf at debian.org> (supplier of updated libsql-statement-perl package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster at debian.org)

Hash: SHA1

Format: 1.7
Date: Mon,  2 Jan 2006 11:43:30 -0600
Source: libsql-statement-perl
Binary: libsql-statement-perl
Architecture: source all
Version: 1.14-2
Distribution: unstable
Urgency: low
Maintainer: Debian Perl Group <pkg-perl-maintainers at lists.alioth.debian.org>
Changed-By: Gunnar Wolf <gwolf at debian.org>
 libsql-statement-perl - perl SQL::Statement - SQL parsing and processing engine
Closes: 311788
 libsql-statement-perl (1.14-2) unstable; urgency=low
   * Added patch by Niko Tyni allowing for field updates based on its
     previous values (Closes: #311788)
   * No longer ignores failure of the clean target
   * Performs the tests as part of the build process
 17734d5513855f03ba0fdb3ba4cccb6b 724 perl optional libsql-statement-perl_1.14-2.dsc
 5bdd1c8aa0e8e5a8953fa8067c7e8d7b 3728 perl optional libsql-statement-perl_1.14-2.diff.gz
 be9dc571b03e4726773375be996aa60e 126474 perl optional libsql-statement-perl_1.14-2_all.deb

Version: GnuPG v1.4.2 (GNU/Linux)


More information about the pkg-perl-maintainers mailing list