reported Result Set: 2^64-1 [rt.cpan.org #48158]

[mbeijen]

trafficstars

Migrated from rt.cpan.org#48158 (status was 'new')

Requestors:

• [email protected]

From [email protected] on 2009-07-24 11:46:14:

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 
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