We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


INTERNAL 3594: Internal Optimizer Error (11) — Vertica Forum
Options

INTERNAL 3594: Internal Optimizer Error (11)

AxelKAxelK
in General Discussion

 

UPDATE T43013613 SET ATTR9 =
   (SELECT VLU
    FROM T43013613A10 mvs
    WHERE

                    T43013613.KEY = mvs.RFR
            AND (mvs.IDX IS NULL

               OR mvs.IDX = (SELECT MIN(IDX)

                                       FROM T43013613A10
                                       WHERE RFR = T43013613.KEY)))

 

INTERNAL 3594: Internal Optimizer Error (11)

DETAIL: !contain_vars_above_level(node, level+1)

HINT: Please report this error to Vertica; try restating your query

 

Restarting query does not change execution result ;)

 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...