Details
Description
Query issued:
SELECT tasks_points.task1 AS task from default_shadow WHERE join_mo>7 GROUP BY tasks_points.task1 HAVING COUNT(tasks_points.task1) > 0 AND (MIN(join_day)=1 OR MAX(join_yr=2011)) ORDER BY tasks_points.task1;
Above query works well in n1ql.
For analytics it gives error:
"msg": "Cannot resolve ambiguous alias reference for undefined identifier tasks_points"
Query works well for n1ql.
Document:
{
"tasks_points":
,
"name": "employee-9",
"mutated": 0,
"skills": [
"skill2010",
"skill2011"
],
"join_day": 9,
"join_mo": 10,
"email": "9-mail@couchbase.com",
"test_rate": 10.1,
"join_yr": 2011,
"_id": "query-testemployee10153.1877827-1",
"VMs": [
,
{ "RAM": 10, "os": "windows", "name": "vm_11", "memory": 10 } ],
"job_title": "Engineer"
}