changed integration test to actually test output of a canned query