Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.0.0
-
4.7.0-1177,Regression seen from 4.6.0-3318
-
Untriaged
-
Yes
Description
Job which failed:
cen006-p0-tools-vset01-08-index
Test which failed:
./testrunner -i /tmp/n1ql_set3.ini gsi_type=forestdb,primary_indx_type=GSI,doc-per-day=6,use_rest=True,nodes_init=2 -t tuqquery.tuq_index.QueriesJoinViewsTests.test_run_query,to_run=test_where_in_subquery_equal_more,index_field=join_day
Query issued:
RUN QUERY select name, tasks_ids,join_day from default where join_day>=2 and tasks_ids[0] IN (select ARRAY_AGG(DISTINCT task_name) as names from default d use keys ["test_task-1", "test_task-2"] where project!='AB')[0].names
Index created:
RUN QUERY CREATE INDEX my_index_899fjoin_day ON default(join_day) USING VIEW
Error reported:
[2016-10-02 15:12:13,058] - [rest_client:778] ERROR - http://172.23.106.10:8093/query?scan_consistency=REQUEST_PLUS&creds=%5B%5D&statement=select+name%2C+tasks_ids%2Cjoin_day+from+default+where+join_day%3E%3D2+and+tasks_ids%5B0%5D+IN+%28select+ARRAY_AGG%28DISTINCT+task_name%29+as+names+from+default+d+use+keys+%5B%22test_task-1%22%2C+%22test_task-2%22%5D+where+project%21%3D%27AB%27%29%5B0%5D.names error 500 reason: unknown {
"requestID": "688bc646-0198-43ae-926f-dd20d73204ca",
"errors": [
],
"status": "fatal",
"metrics":
}
Attachments
Issue Links
- blocks
-
MB-22188 4.6.2 Minor Release
- Closed
For Gerrit Dashboard: MB-21191 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
68495,3 | MB-21191. Subquery expression is Identifier and not an alias in parent treat as keyspace | master | query | Status: MERGED | +2 | +1 |
73325,2 | MB-21191. Subquery expression is Identifier and not an alias in parent treat as keyspace | watson++ | query | Status: MERGED | +2 | +1 |