Get META().id of JOINed bucket as keys

SQL++
,
6

I am using CB 4.1 on my production server. However I am testing some queries on 4.5 locally (so far so good. The ones that are working in one, are working in another).

SELECT OBJECT v.id:v.v FOR v IN ARRAY_AGG({"id":meta(users).id , "v":users}) END AS d FROM default m JOIN default users ON KEYS
OBJECT_NAMES(m.followers) WHERE m.type = "user_account_followers" AND m.id = 1 group by m;

throws:

[
  {
    "code": 4210,
    "msg": "Expression must be a group key or aggregate: object (`v`.`id`) : (`v`.`v`) for `v` in array_agg({\"id\": (meta(`users`).`id`), \"v\": `users`}) end as `d`",
    "query_from_user": "SELECT OBJECT v.id:v.v FOR v IN ARRAY_AGG({\"id\":meta(users).id , \"v\":users}) END AS d FROM default m JOIN default users ON KEYS\nOBJECT_NAMES(m.followers) WHERE m.type = \"followers\" AND m.id = 1 group by m;"
  }
]

The second one did worked! The collection name is named as “d”. Is it much complicated to just get an array of objects instead of having an additional object layer?

Apart of that, excellent! Thanks a lot once more @vsr1!

EDIT: Against me I am gonna talk. As I’ve said, I was testing it on 4.5 and it worked like a charm, however it seems to don’t work in 4.1 unfortunately.