If I take $X$ to be a degenerate random variable, i.e. $X=1$ WP1 and $Y=X$ defined over the singleton sample space $\Omega=\{1\}$. Then
$$\mathbb{P}(X=1|Y=1)=1=\mathbb{P}(X=1)$$
i.e. I'd assume they're independent. But, we have
$$\rho_{XY}=\frac{\mathbb{E}(XY)-\mathbb{E}(X)\mathbb{E}(Y)}{\sigma_X\sigma_Y}=\frac{0}{0}$$
which is undefined, not zero. Where am I being imprecise here/what's the misunderstanding? Thanks!