fromExprRelids.size()

vcarusi

Hi,
Have you ever met this error ?

2018-06-25 14:30:15.051 Init Session:7f0e102d5700-a000000a15f78d @v_officedw_node0001: VX001/3594: Internal Optimizer Error (11)
DETAIL: fromExprRelids.size() == 1
HINT: Please report this error to Vertica; try restating your query
LOCATION: populateJoinTree, /scratch_a/release/svrtar12486/vbuild/vertica/Optimizer/Path/JoinGraph.cpp:1094

Thank you,
Veronica

Jim_Knicely

Can you post the SQL statement that causes the error?

There is a fix in Vertica 9.1 that addresses a cause of this error. But we won't know if it'd help you until we see your particular statement.

vcarusi

Hi,
I have this error on Vertica Analytic Database v9.1.0-0.
I will try to post the tables structure and the query.
Thank you,
Veronica