This should work with the current code. This is a bug. This happens with replicated table. Correlated DELETE in the datanode is not propaged to other datanode? Need more description from Abbas though. Run more test and see if this happens only with replicated table.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am closing this one alongwith 3170715 and have opened 3515461 to solve the root issue: DELETE does not work if the WHERE clause is not pushable. There is nothing wrong in the correlated subqueries. Check 3515461 for more details and test cases. That bug description also has a note that the fix for DELETE should be tested with replicated tables as well.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This should work with the current code. This is a bug. This happens with replicated table. Correlated DELETE in the datanode is not propaged to other datanode? Need more description from Abbas though. Run more test and see if this happens only with replicated table.
I am closing this one alongwith 3170715 and have opened 3515461 to solve the root issue: DELETE does not work if the WHERE clause is not pushable. There is nothing wrong in the correlated subqueries. Check 3515461 for more details and test cases. That bug description also has a note that the fix for DELETE should be tested with replicated tables as well.