Repro:
#66441
The errors in that PR have the same root cause #72898
Unexpected behaviour:
When error happen on the source table it is muted as nothing happened. Ok is returned to the client.
Should be:
Errors in the source table have to fail the query.