Hi,
I was asking this question some time ago and was under impression that this will be fixed in 8.x. In general problem is, CREATE TEMP TABLE AS SELECT does not report any rows to the engine, seems like, so GET DIAGNOSTICS ROW_COUNT after the statement returns 0 as well as FOUND false. This was working in 7.3, but behavior changed in 7.4.
My question is, will it be fixed or should I consider not stop using get diagnostic after ‘create temp table as select’ from now on. Honstly this was a very convinient feature especialy knowing that select count(*) not a fastes possible operation.
Thank you.