File "/Users/dpage/git/pgadmin4/web/pgadmin/feature_tests/pg_datatype_validation_test.py", line 42, in runTest
self._check_datatype()
File "/Users/dpage/git/pgadmin4/web/pgadmin/feature_tests/pg_datatype_validation_test.py", line 111, in _check_datatype
assert False, "{0} does not match with {1}".format(val, expected_output[cnt])
AssertionError: ARRAY[1, 2, 'nan']::float[] does not match with 1, 2, 'nan'
Yes this issue is already logged in redmine. When we execute SELECT ARRAY[1, 2, 'nan']::float[]; from Query tool, we don't get output. The "Data Output" panel remains blank and in message panel we get {"info":"","success":1,"errormsg":"","data":{"rows_affected":1,"result":[[[1.0,2.0,NaN]]],"additional_messages":null,"status":"Success"},"result":null}.
Due to this error, I have executed different query for each value. If I run a single query, the test case fails and I can't get the desired output.
I have also tried to clear the SQL editor for each query and avoid loading Query tool for their respective call but I couldn't.
I will work on your other suggestion.
On Thu, May 11, 2017 at 10:11 AM, Dave Page <dpage@pgadmin.org> wrote: