Skip Menu |
 

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

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

People
Owner: Nobody in particular
Requestors: layer23 [...] gmx.de
Cc:
AdminCc:

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



Subject: reported Result Set: 2^64-1
Download (untitled) / with headers
text/plain 1.2k
if i use stored procedures in a select statement, $sth->rows() reports a result set of 18446744073709551615 ( 2^64 - 1) rows. a following ->fetch returns undef. the same statement with the mysql cli works fine: Show quoted text
mysql> select core.levenshtein("otto","atta");
+---------------------------------+ | core.levenshtein("otto","atta") | +---------------------------------+ | 2 | +---------------------------------+ 1 row in set (0.00 sec) Show quoted text
mysql>
the stored proc. 'levenshtein' can be downloaded here: http://codejanitor.com/wp/2007/02/10/levenshtein-distance-as-a-mysql-stored-function/ also tried different sql_modes. perl version is v5.8.8 distribution is gentoo ( last synced today ) necronomicon etc # cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 2 model name : Intel(R) Pentium(R) 4 CPU 3.00GHz stepping : 9 cpu MHz : 2992.585 cache size : 512 KB fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 2 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid bogomips : 5976.88


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.