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.
We really need to figure this out. The tests are taking far too long to run, which will make it impractical for me and the other committers to execute them when reviewing patches.
Please take Navnath's help if you think it would be useful.
I will work on your other suggestion.
Thanks.
On Thu, May 11, 2017 at 10:11 AM, Dave Page <dpage@pgadmin.org> wrote: