From: eagle eyes joe <jalotta@...>
Date: 2004-09-26T09:59:52+09:00
Subject: MySql::Result#each_hash deletes data

Greetings:

  You can only read a Mysql::Result object once because
each_key deletes the values as it reads them.   This is unexpected and I 
think it should be fixed.

This little program shows what I mean:


[Abba:/tmp] josephal% cat resulttest 
#!/usr/bin/ruby

require 'mysql'

m = Mysql.new("localhost", "root", "", "Development")

r = m.query("select * from processedfiles limit 5")

r.each_hash { |row| print "#{row['name']}\n" }

print "---------------------------------------\n"

r.each_hash { |row| print "#{row['name']}\n" }

print "------------------- -\nthis is the end\n"


[Abba:/tmp] josephal% resulttest 
AD030220
AD030221
AD030228
AD030307
AD000428
---------------------------------------
------------------- -
this is the end
[Abba:/tmp] josephal%