The problem lies in an error in the query evaluation on 26.0.188, causing the columns from the pivot to receive the wrong alias. As a result, cfd.id is not recognised, but id is.
A new release is available that should resolve this issue. The necessary changes are available from release 26.0.195 and in all future BETA versions.
This new release is/has been deployed in production on Invantive Cloud.
For more information, see: