How do you pass query as parameter for ARRAY_SYMDIFF function

Couchbase Server
5

Hi @vsr1

Thank you for your reply. but i do get following error on this . I dont think I should get the error .

WITH fvs AS ( SELECT META().id, favoriteGenres AS fg
FROM couchmusic4-mini
WHERE type = “userprofile”)
SELECT f1.id, f2.id, ARRAY_SYMDIFF(f1.fg,f2.fg)
FROM fvs AS f1 UNNEST fvs AS f2
WHERE f1.id != f2.id;

I do get syntax error on this query :slight_smile:

[
{
“code”: 3000,
“msg”: “Duplicate result alias id.”,
“query”: “WITH fvs AS ( SELECT META().id, favoriteGenres AS fg\n FROM couchmusic4-mini\n WHERE type = "userprofile")\nSELECT f1.id, f2.id, ARRAY_SYMDIFF(f1.fg,f2.fg)\nFROM fvs AS f1 UNNEST fvs AS f2\nWHERE f1.id != f2.id;”
}
]