sqlite3.3.7 gives "SQL logic error or missing database"

Railsters:

I ported a working project to a new hard drive, and had such a pleasant afternoon with this issue:

    http://www.railsweenie.com/forums/5/topics/1496

The bug report says the problem is pilot error.

However, I get the bug before querying anything. I get it especially annoyingly from test_dummy with nothing in it. The bug refers to the calls below setup():

SQLite3::SQLException: SQL logic error or missing database     /var/lib/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/errors.rb:94:in `check'     /var/lib/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/resultset.rb:76:in `check'     /var/lib/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/resultset.rb:68:in `commence'     /var/lib/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/resultset.rb:61:in `initialize'     /var/lib/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/statement.rb:163:in `new'

I think I have this bug:

    http://www.railsweenie.com/forums/5/topics/1496

Here's the potential cause:

"I got the same message. The problem was there were files in test/unit for models that had been deleted. You'll get the same message if you run a single test, e.g. if you have a file test/unit/foo_test.rb but no table for foos typing the shell command

% ruby test/unit/foo_test.rb

will give the same error."

So when I move all my non-Model unit tests out of the unit test folder, and put them into the functional folder, and everything works.

So that doesn't appear to be pilot error, huh, if all these tests work fine with MySQL for the test database, and if all these tests worked fine with slightly older version ticks.

Some version dumps:

rails (1.2.3) sqlite3-ruby (1.1.0.1) (This is _why's sensibility repack.) ZenTest (3.6.0)

Using the latest sqlite3-ruby, and the one that came with my Fiesty Fawn, also didn't help.

Should we open a bug ticket for this?