Follow on to Issue # 327

[RickL18393]

In the attached log I found the error message, Wed Nov 20 07:20:57 2024 - [ERROR] sql2c_string()@convert.c:3489 [STMT@0x00000230C2E6C6F0] can't convert Soham Sarkar to double, at row 7594. Looking at the previous rows, it appears that the #3 column contains the invalid data. However, I have checked the third and fourth (In case this is a zero based index) columns and neither of them are defined as a numeric data type so I do not understand why the ElasticSearch ODBC driver is attempting to convert a character string into a double.

A little more background, I am not pulling all the columns available in the table. I am assuming that the column # is assigned to the third column I selected and not the actual third column in the table. Is this correct? I have checked the actual third column in the table, which is a REAL/float data type, but it does not contain any character string data that I can see.

Am I reading this log correctly?

Thanks,
Rick L.

esodbc_20241120072056_8c37f8d3110e45509651c681c5b9d344.ece.optum.com_9243_20420-1.log

[bpintea]

@RickL18393, I've reopened #327, will close this one. Will try to have a look at the log one of the following days.