How to trigger the error messages in ODBCMessages.xml and VerticaMessages.xml

CharlieCai

Hi Team,
Could you please help to give example which can easily trigger the error message in ODBCMessages.xml or VerticaMessages.xml?
I'd like to test and confirm if relative path works for ErrorMessagesPath in vertica.ini
Thanks & Regards,
Jinlei

Bryan_H

On Linux, you can test with "isql" client in verbose mode:
$ isql -v vertica
SQL> select count(distinct x), listagg(y) from myTable;
[42703]ERROR 2624: Column "x" does not exist

CharlieCai

@Bryan_H said:
On Linux, you can test with "isql" client in verbose mode:
$ isql -v vertica
SQL> select count(distinct x), listagg(y) from myTable;
[42703]ERROR 2624: Column "x" does not exist

Thanks for your reply.
Yes, I will get the same error, but this error template could not be found in ODBCMessages.xml or VerticaMessages.xml.
Instead, I can find one similar error in ODBCMessages.xml
<!-- Error thrown when a specified column name is invalid or not found. -->
<Error Key="InvalidColumnName" Params="1" NativeErrorCode="20021">Invalid column name: %1%</Error>

Could you please help to provide more information on how to make error messages in these two xml files take effort?