syntax error at or near "\" at end of the query

James_Pettyjohn · July 2014

I'm trying to use vertica with Golang over ODBC. I can connect OK and am getting an error of "Syntax error at or near "\" at character 31" for the query "select * from public.value_ref" - character 31 would be after the last letter of the table. No variations to the query have resolved error. This does work through JDBC and isql over ODBC with this same DSN.

James_Pettyjohn · July 2014

For anyone else who runs into this, the code.google.com/p/odbc driver appends a null termination character to every query. This doesn't play well with vertica.

Allan_Cochrane_1 · August 2014

Did you manage to get the driver working at all? If so, what changes did you make?

James_Pettyjohn · August 2014

I did manage to get it working by a quick hack to https://code.google.com/p/odbc/source/browse/odbcstmt.go - I added this to line 39:

b=b[0:len(b)-1]

I didn't look into this further as to which was is per spec so I don't know where this chagne should be implemented.

Allan_Cochrane_1 · August 2014

See https://groups.google.com/forum/#!searchin/golang-nuts/vertica/golang-nuts/ysqaztTjQaA/Tcfk9f84qCQJ

syntax error at or near "\" at end of the query

Comments

Leave a Comment