I understand there was an error. But keeping an eye on the subject I ignored it (though it should have been rectified). I remembered it as my real time experience but that time it was into temporary table. So here I tried it for physical table and it gave same result. Didn't check BOL but looking at past comments seems to be a bug.

Nevertheless a good question and good start to week. 🙂