Why is a remote INSERT with a fullselect statement not completely evaluated remotely?

You can check several elements of the subselect to determine why a remote INSERT with a fullselect statement is not completely evaluated remotely.

Considerations:
  • Could the subselect be completely evaluated on the remote data source? If no, examine the subselect.
  • Does the subselect contain a set operator? If yes, does this data source support set operators as input to an INSERT?
  • Does the subselect reference the target table? If yes, does this data source allow this syntax?