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: mysql> select core.levenshtein("otto","atta"); +---------------------------------+ | core.levenshtein("otto","atta") | +---------------------------------+ | 2 | +---------------------------------+ 1 row in set (0.00 sec) 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 DBD-mysql versions is 4.00.5 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 mySQL Version is 5.0.70 Reproducible: Always Steps to Reproduce: 1. $sth=$db->prepare("select core.levenshtein('otto','atta')"); 2. $sth->execute(); 3. print $sth->rows(); Actual Results: 2^64 - 1 rows reported by $sth->rows(); no result set ( ->fetch returns undef ) Expected Results: mysql> select core.levenshtein("otto","atta"); +---------------------------------+ | core.levenshtein("otto","atta") | +---------------------------------+ | 2 | +---------------------------------+ 1 row in set (0.00 sec)
please test with the newer DBD-mysql 4.01.2 and reopen if needed.
