Added connection to the several places to allow function with global dialect. Removing test that expects to fail.