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

Owner: MICHIELB [...]
Requestors: hsk [...]

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 fixes your issue? -- Michiel
From: hsk [...]
Download (untitled) / with headers
text/plain 241b
On Mon Mar 09 13:50:19 2015, MICHIELB wrote: Show quoted text
> Can you verify this > 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 [...]
Download (untitled) / with headers
text/plain 267b
On Mon Mar 09 14:22:48 2015, wrote: Show quoted text
> > (still, the test setup seems a bit weird :-)
Yes it did... I improved it here: Thanks for your feedback! -- Michiel

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

Please report any issues with to