Correlation between two constant variables using the different approaches [duplicate]

Question

Let's say we have a vector X = (1, 1, 1) and Y = c(2, 2, 2). I want to calculate correlation between those. Taking Pearson correlation brings us nowhere, because standard deviation of both of these equals 0 so we divide by 0. It means that Pearson correlation suggests us that correlation is undefined. However let's use geometric approach which says that correlation coefficient can be calculated as :

So by substituting our two vectors we get :

$$r = \frac{1\cdot 2 + 1 \cdot 2 + 1 \cdot 2}{\sqrt{1^2+1^2+1^2}\cdot\sqrt{2^2+2^2+2^2}} = \frac{6}{\sqrt{3}\cdot \sqrt{12}} = \frac{6}{\sqrt{36}}=1$$

Why these approaches gives different results, while they are equivalent ? Which result is accurate ?

Answer 1

Thanks to @user2974951 who points at very good threads on the topics. There is also this one : Is there any relationship among cosine similarity, pearson correlation, and z-score?, which shows that Pearson correlation is cosine similarity between centered vectors, which $X$ and $Y$ in your example are not. If you center them (i.e., substract their means), you'll have $r=\text{cos}(\theta)=0$.