X-Recipient: archive-cygwin AT delorie DOT com
X-SWARE-Spam-Status: No, hits=-497760.4 required=5.0 	tests=AWL,BAYES_00,LOCALPART_IN_SUBJECT
X-Spam-Check-By: sourceware.org
X-MDAV-Processed: mail1.multiplay.co.uk, Thu, 07 Jan 2010 21:30:07 +0000
X-Spam-Processed: mail1.multiplay.co.uk, Thu, 07 Jan 2010 21:30:06 +0000 	(not processed: message from trusted or authenticated source)
X-MDRemoteIP: 213.123.247.160
X-Return-Path: prvs=1623dfa582=killing AT multiplay DOT co DOT uk
X-Envelope-From: killing AT multiplay DOT co DOT uk
X-MDaemon-Deliver-To: cygwin AT cygwin DOT com
Message-ID: <19C1823A54BB4C058061C783D86F41F8@multiplay.co.uk>
From: "Steven Hartland" <killing AT multiplay DOT co DOT uk>
To: "Cygwin List" <cygwin AT cygwin DOT com>
Subject: cygwin, perl or DBI seriously broken in 1.7.1?
Date: Thu, 7 Jan 2010 21:29:57 -0000
MIME-Version: 1.0
Content-Type: text/plain; 	format=flowed; 	charset="iso-8859-1"; 	reply-type=original
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

Unless I'm going mad it seems either cygwin itself, perl, DBI or DBD::mysql
have been broken in 1.7.1 or the update to perl 5.10.

I'm running a script which has been working here for years
but is now broken and from what I can tell the issue is
fairly fundamental so I'm currently suspecting an issue
in perl 5.10. Thought I'd switch back to 5.8 but that's
not available by the setup.exe any more so I'm a bit stuck.

Anyway the details are:

use DBI;
use Data::Dumper;
// Setup db connection...
my $sql = "SELECT 214, 16, 150, 15, 55000, 5120, 5, 25769803776 FROM dual;
my $sth = $dbh->prepare( $sql );
$sth->execute or die "failed to execute";
my @array = $sth->fetchrow_array;
print Dumper( \@array );

Now assuming no errors @array should contain 8 items but it doesn't
instead I "randomly" get just the last value:
$VAR1 = [
          '25769803776'
        ];
or the correct value:
$VAR1 = [
          '214',
          '16',
          '150',
          '15',
          '55000',
          '5120',
          '5',
          '25769803776'
        ];

So what on earth is going on?

    Regards
    Steve


--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple