Added test case to validate issue #227

This test case demonstrates issue #227 by using a single connection for executing the query.