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

Complex query with array and column predicates causes null pointer exception during compilation

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown
    • Analytics CBO Sprint 12, Analytics CBO Sprint 13

    Description

      Here is the query

      explain select count ( * ) from KS1 x where uniq_i > 50 and uniq_i < 60 and (ANY and EVERY v IN x.uarr_i satisfies v > 384 END) and (ANY v IN x.zarr_i satisfies v >= 0 END) and (ANY v IN x.zarr_i satisfies v >= 0 END)

      The problem goes away if the ANY and EVERY predicate is also a ANY IN predicate.

      Problem may be that for the above query there are two selects above the ANY AND EVERY subplan. My code expects only one.

      This is with the CBO code.

      Attachments

        1. q5.sql
          671 kB
        2. scans5.3.txt
          23.06 MB

        Issue Links

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

          Activity

            People

              murali.krishna Murali Krishna
              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