RubyForge: SQLite-Ruby: help

Discussion Forums: help

RE: update silently fails on large database [ reply ]
2010-08-20 15:24

Done. Thanks for the pointer, Luis. The rubyforge project page has no contact links at all, so this was the only inlet I could find.

By: Luis Lavena

RE: update silently fails on large database [ reply ]
2010-08-20 11:54

Hello Sterling.

Would you mind post this message, script and maybe download addresses to sqlite3-ruby group?

http://groups.google.com/group/sqlite3-ruby

RubyForge has never been great for the forum section and we believe the group will get better and faster answers to your issue.

Regards.
Luis

By: Sterling Camden

update silently fails on large database [ reply ]
2010-08-20 05:03

I have the following script snippet that fails:

<code>
db = SQLite3::Database.new('spam.db')
spam, good = db.get_first_row("select spam,good from SPAMSTATS where phrase = ' '")
db.execute("update SPAMSTATS set spam = ?, good = ? where phrase = ' '", spam, good)
newspam, newgood = db.get_first_row("select spam, good from SPAMSTATS where phrase = ' '")
assert_equal(spam, newspam)
</code>

at this point, newspam is nil. This same type of code worked up until the database reached a size of 8539779 rows (2388472832 bytes). I think I may have hit a bug. I can upload the database and complete script for anyone who would like to look into this.

TIA