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

Query with outerjoins produces error "Execution internal error: processAnsiExec: annotated value not found"

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Unknown

    Description

      select /* 2321 */ count(1) from R join S USE HASH (PROBE) on R.u64 = S.u64 and S.rand <= 2048 join T USE HASH (PROBE) on S.u256 = T.u256 and T.rand <= 2048 left join U  on T.u1K = U.u1K and U.rand <= 2048 where R.rand <= 2048

      Errors are

      "errors": [
      		 
              {
      		 
                  "code": 5002,
      		 
                  "msg": "Execution internal error: processAnsiExec: annotated value not found for U"
      		 
              },
      		 
              {
      		 
                  "cause": {
      		 
                      "distinctErrors": 1,
      		 
                      "duplicateErrors": 15,
      		 
                      "errorLimit": 16
      		 
                  },
      		 
                  "code": 1195,
      		 
                  "msg": "Request execution aborted as the number of errors raised has reached the maximum permitted."
      		 
              }
      		 
          ],

      Attachments

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

        Activity

          People

            bingjie.miao Bingjie Miao
            murali.krishna Murali Krishna
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty