Hi,
I just stumbled that vsql and Vertica JDBC are using different formatting for array datatypes.
$ /opt/vertica/bin/vsql -h myhost -U myuser -w mypwd -c "select array[1,2,3]"
array
[1,2,3]
(1 row)
JDBC (I am using DbVisualizer):
select ARRAY[1,2,3];
{1,2,3}
I thought that DbVisualizer tool has formatting for array datatypes - but it does not.
Vertica JDBC driver v 24.2 API docs are not mentioning anything about handling array type.
Looks like really Vertica JDBC driver return array as string in curly brackets? While vsql return in square brackets?
Thank you
Sergey