| Subject: | reported Result Set: 2^64-1 |
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 textmysql>
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