Message Title

HHH-9027

Also I found workaround for this bug. We just need to fool isCorrelation() check. For this we need add one more subquery.

In my case it is looks like

 
                                                    INSERT INTO A
  (B)
  SELECT ALIAS
    FROM B AS ALIAS
   WHERE EXISTS
   (SELECT ALIAS1
            FROM B AS ALIAS1
           WHERE ALIAS1 = ALIAS
             AND NOT EXISTS (SELECT 1L
                    FROM C AS JUST_TEST
                   WHERE (ALIAS1.ID = JUST_TEST.ID)))
 
                                                

Add Comment

This message was sent by Atlassian JIRA