Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-21191

[N1QL] 'msg\': u\'FROM expression term should not have USE KEYS\'

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.6.2, 5.0.0
    • 5.0.0
    • query
    • 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": [

      { "code": 4110, "msg": "FROM expression term should not have USE KEYS" }

      ],
      "status": "fatal",
      "metrics":

      { "elapsedTime": "3.994578ms", "executionTime": "3.895834ms", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              Prerna.Manaktala Prerna Manaktala (Inactive)
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty