ODBC Returning strange value

[augusto.ferronato]

Hello,
i configured the ODBC on Zabbix, but the return is strange

PostgreSQL Database:

The zabbix return the value:


But, in the ISQL it's ok:



I doesn't know what is wrong.

Zabbix: 3.2.1
ODBC Driver settings:
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbcw.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1


Thanks

[plui]

What if instead of "select 1", you have "select 1 as test"?

[augusto.ferronato]

Hello,
Thanks, but the problem it's not in the query, but in the Zabbix.

Thanks

[Atsushi]

Perhaps, it seems to be a problem in the following URL.

ZBX-11213
DB Monitoring stopped working after upgrade to 3.2

https://support.zabbix.com/browse/ZBX-11213

I think that it will be fixed in the next version.

[GPegel]

I experience the exact same problem as augusto.ferronato. I have this not only in version 3.2.1 but also in another environment with version 3.0.5.

I see that I do not have this problem in an environment with version 3.0.4. So it seems that version 3.0.4 is working well.

[augusto.ferronato]

Hello,
Thanks, i think we need wait the 3.2.2 =\

Thanks