Skip Menu |
 

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

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

People
Owner: MICHIELB [...] cpan.org
Requestors: hsk [...] fli-leibniz.de
Cc:
AdminCc:

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



Subject: failure of test rt88006-bit-prepare
Download (untitled) / with headers
text/plain 642b
in DBD-mysql-4.031, test t/rt88006-bit-prepare.t fails (i.e. the "id_binary test contents" test parts) if the created table dbd_mysql_rt88006_bit_prep happens to be a MyISAM table. for an InnoDB table the test succeeds. i do not see what exactly the test should check. is it intentional that, in the create statement, id_binary_test is defined as auto_increment, and later, in the insert statement, id_binary_test is set explicitly, and in kind of wrong order ? then, in the select statement, MyISAM seems to emit values in insertion order, while InnoDB seems to emit in auto_increment variable order. tested with mysql 5.5.33 and 5.5.42
Download (untitled) / with headers
text/plain 125b
Thanks for your bug report. Can you verify this https://github.com/perl5-dbi/DBD-mysql/pull/35 fixes your issue? -- Michiel
From: hsk [...] fli-leibniz.de
Download (untitled) / with headers
text/plain 241b
On Mon Mar 09 13:50:19 2015, MICHIELB wrote: Show quoted text
> Can you verify this https://github.com/perl5-dbi/DBD-mysql/pull/35 > fixes your issue?
thanks for your reply. yes, the "order by" clause fixes it. (still, the test setup seems a bit weird :-)
RT-Send-CC: CAPTTOFU [...] cpan.org
Download (untitled) / with headers
text/plain 267b
On Mon Mar 09 14:22:48 2015, hsk@fli-leibniz.de wrote: Show quoted text
> > (still, the test setup seems a bit weird :-)
Yes it did... I improved it here: https://github.com/perl5-dbi/DBD-mysql/commit/6fe0a1db08c12945ccc16e3804bb9aaf93a0cc77 Thanks for your feedback! -- Michiel


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.