Concurrent queries on flex table from java giving strange error

knbny

I have a normal flex table with a __raw__ column. I am attempting a query that looks something like this:

 

SELECT MAPTOSTRING(__raw__)

FROM MY_TABLE

WHERE VERSION = (

SELECT MAX(CAST(VERSION AS FLOAT))

FROM MY_TABLE INNER_QUERY

)

AND TITLE = 'TITLE'

ORDER BY AUTHOR;

 

Version, Title and Author are all keys held in the JSON saved in the binary __raw__ column. This query runs fine when run from DbVisualizer or a standalone query from a tomcat server. My problem is that multiple REST calls making this query on different parameterized titles throw the VJDBC Error 3854 AKA:

 

[Vertica][VJDBC](3854) ERROR: Length of a string in a return type must be greater than zero

 

I cannot seem to find any useful information on this error nor can I determine the root cause of it. Can anyone help?

wilsonshi

Same problem here. Any updates on this?

Arumugaguru_M

Got the Same Issue? Any update please.

Ariel_Cary

This problem has been fixed as of 7.2.3-4. There used to be a problem with concurrent accesses to a map when querying virtual columns.

 

See note for VER-47352 at:

https://my.vertica.com/docs/ReleaseNotes/7.2.x/Vertica_7.2.x_Release_Notes.htm#7.2.3-4