> IMO, let's not change the 1) behaviour to 3) with the patch. If agreed,
> I can do the following way in ExplainOneUtility and will add a comment on
> why we are doing this.
>
> if (es->analyze)
> (void) CheckRelExistenceInCTAS(ctas, true);
>
> Thoughts?
Agreed.
Just in case, I took a look at Oracle 12’s behavior about [explain CTAS].
Oracle 12 will output the plan without throwing any msg in this case.
Best regards,
houzj