comdb2 icon indicating copy to clipboard operation
comdb2 copied to clipboard

{174996173}: Workaround for remote-insert that reads from the same remote

Open riverszhang89 opened this issue 9 months ago • 0 comments

Dorin pointed out the bug, that if a query reads from a remote table and inserts the results into another table in the same remote database, the query will hang (e.g., INSERT INTO remote.t1 SELECT * FROM remote.t2).

This patch works it around by always using a temptable plan for such a query.

riverszhang89 avatar Apr 30 '24 15:04 riverszhang89