We are aware of this problem. We will deprecate the use of paths in the FROM clause. The problem is that couchmusic1.userprofile evaluates to MISSING in some documents, and when you apply LIMIT 1, you are getting a first document where userprofile is MISSING. The results are confusing.