Skip Menu |

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

Report information
The Basics
Id: 50243
Status: rejected
Priority: 0/
Queue: DBD-mysql
People
Owner: MICHIELB [...] cpan.org
Requestors: avri [...] iskoot.com
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: 4.013
Fixed in: (no value)

History Show all quoted text
  Tue Oct 06 05:15:45 2009 http://users.livejournal.com/stone_/ - Ticket created
Subject: mysql_bind_type_guessing regression. Numbers are being quoted again
I installed 4.013 to fix the problem with quoting numbers in bindings, but found it did not work. Here is my mysql log after running make test on 4.013 119 Query insert into t1 (id) values ('9999999999999999') 119 Query update t1 set id = '9999999999999998' 119 Query insert into t1 (id) values ('9999999999999997') 119 Query update t1 set id = '9999999999999996' where id = '9999999999999997' 119 Query select * from t1 So I installed 4.012 instead and found it worked correctly. 153 Query insert into t1 (id) values ('9999999999999999') 153 Query update t1 set id = '9999999999999998' 153 Query insert into t1 (id) values ('9999999999999997') 153 Query update t1 set id = 9999999999999996 where id = 9999999999999997 153 Query select * from t1 Did the fix to #48242 break this?
  Fri Feb 06 10:41:47 2015 MICHIELB [...] cpan.org - Correspondence added
I do realize this is a VERY old ticket, but I'd want to ask you if you can provide a test case? I want to make sure this problem is gone now. If you don't have time/interest/resources to help out, this is also OK, in that case I'll close the ticket. -- Michiel On Tue Oct 06 05:15:45 2009, http://users.livejournal.com/stone_/ wrote: Show quoted text
> I installed 4.013 to fix the problem with quoting numbers in bindings, > but found it did not work. > > Here is my mysql log after running make test on 4.013 > > 119 Query insert into t1 (id) values ('9999999999999999') > 119 Query update t1 set id = '9999999999999998' > 119 Query insert into t1 (id) values ('9999999999999997') > 119 Query update t1 set id = '9999999999999996' where id > = '9999999999999997' > 119 Query select * from t1 > > So I installed 4.012 instead and found it worked correctly. > > 153 Query insert into t1 (id) values ('9999999999999999') > 153 Query update t1 set id = '9999999999999998' > 153 Query insert into t1 (id) values ('9999999999999997') > 153 Query update t1 set id = 9999999999999996 where id = > 9999999999999997 > 153 Query select * from t1 > > > Did the fix to #48242 break this?
  Fri Feb 06 10:41:47 2015 The RT System itself - Status changed from 'new' to 'open'
  Fri Feb 06 10:41:53 2015 MICHIELB [...] cpan.org - Status changed from 'open' to 'stalled'
  Thu Aug 11 11:16:07 2016 MICHIELB [...] cpan.org - Correspondence added
Closing ticket.
  Thu Aug 11 11:16:08 2016 The RT System itself - Status changed from 'stalled' to 'open'
  Thu Aug 11 11:16:09 2016 MICHIELB [...] cpan.org - Status changed from 'open' to 'rejected'
  Thu Aug 11 11:16:09 2016 MICHIELB [...] cpan.org - Taken