Skip Menu |
 

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 97541
Status: resolved
Priority: 0/
Queue: DBD-mysql

People
Owner: Nobody in particular
Requestors: mail [...] oliwel.de
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



MIME-Version: 1.0
X-Spam-Status: No, score=-1.9 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9] autolearn=ham
X-Spam-Flag: NO
X-Virus-Checked: Checked
Content-Type: multipart/signed; boundary="------------ms090908040905040903080900"; micalg="sha1"; protocol="application/pkcs7-signature"
Message-ID: <53D4DE26.3050801 [...] oliwel.de>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -1.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 3EB0D240401 for <cpan-bug+DBD-mysql [...] hipster.bestpractical.com>; Sun, 27 Jul 2014 07:10:53 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ikQu8yhfpyLu for <cpan-bug+DBD-mysql [...] hipster.bestpractical.com>; Sun, 27 Jul 2014 07:10:51 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 7E2B72400D2 for <bug-DBD-mysql [...] rt.cpan.org>; Sun, 27 Jul 2014 07:10:51 -0400 (EDT)
Received: (qmail 22461 invoked by alias); 27 Jul 2014 11:10:48 -0000
Received: from mail.serverpilot.net (HELO mail.serverpilot.net) (82.135.58.65) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Sun, 27 Jul 2014 04:10:43 -0700
Received: (qmail 10586 invoked from network); 27 Jul 2014 11:10:31 -0000
Received: from unknown (HELO ?10.16.6.42?) (oliver.welter [...] leitwelt.com [...] 185.31.62.230) by 0 with ESMTPA; 27 Jul 2014 11:10:31 -0000
Delivered-To: cpan-bug+DBD-mysql [...] hipster.bestpractical.com
Subject: mysql_bind_type_guessing fails on single "special" character
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.0
Return-Path: <mail [...] oliwel.de>
X-RT-Mail-Extension: dbd-mysql
X-Original-To: cpan-bug+DBD-mysql [...] hipster.bestpractical.com
X-Spam-Check-BY: la.mx.develooper.com
Date: Sun, 27 Jul 2014 13:10:30 +0200
X-Spam-Level:
To: bug-DBD-mysql [...] rt.cpan.org
From: Oliver Welter <mail [...] oliwel.de>
X-RT-Interface: Email
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 1074
Hi, this is a followup on #48242 (https://rt.cpan.org/Public/Bug/Display.html?id=48242). mysql_bind_type_guessing detects a value which consists of only a single character (plus,minus,dot,e) as a number, resulting in an invalid mysql statement. Reproduce: my $sth = $dbh->prepare('insert into test (test) values (?)'); $sth->execute(('+')); $sth->execute(('.')); $sth->execute(('-')); $sth->execute(('e')); Causes "syntax error near ')'" resp. " Unknown column 'e' in 'field list". Reason: Parts of the patch to solve 48242 have been reverted later, see github commits: 6e296abd - introduces "seen_digit" 1474dcb0 - removes the flag by commenting it + /* Not sure why this was changed */ + /* seen_digit= 1; */ + /* Need to revisit this */ + /*if (len == 0 || cp - string < (int) len || seen_digit == 0) {*/ + if (len == 0 || cp - string < (int) len) { I did not have a full view on the code, but reactivating these lines SHOULD fix the issue without any side effects. Oliver -- Protect your environment - close windows and adopt a penguin!
Content-Description: S/MIME Cryptographic Signature
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Disposition: attachment; filename="smime.p7s"
Content-Transfer-Encoding: base64
Content-Length: 4074
Download smime.p7s
application/pkcs7-signature 3.9k

Message body not shown because it is not plain text.

X-RT-Interface: REST
MIME-Version: 1.0
X-Mailer: MIME-tools 5.504 (Entity 5.504)
RT-Message-ID: <rt-4.0.18-28699-1510688731-802.97541-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Content-Disposition: inline
Content-Transfer-Encoding: binary
Content-Length: 78


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.