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)



Subject: mysql_bind_type_guessing regression. Numbers are being quoted again
Download (untitled) / with headers
text/plain 848b
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?
Download (untitled) / with headers
text/plain 1.2k
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?
Closing ticket.


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.