SimpleTesting-PDOException: SQLSTATE[42S02]
This behavior is correct. SimpleTest sets up a new site environment for every test case, using a table name prefix.

You probably forgot to install your module by overriding the setUp() method. Once your module is installed the query should work.