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

[ANSI JOINS] Plan error: buildOrScanNoPushdown: missing OR subterm

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0
    • 5.5.0
    • query
    • 5.1.0-1511
    • Untriaged
    • Unknown

    Description

      The setup is the traditional rqg ansi join setup, the 5 buckets with a secondary key on each field in a bucket and a secondary key that contains each field in the bucket. Same buckets as were backuped in MB-27201.

      This query:

      SELECT  t_3.*  FROM  multiple_table_db_2143_simple_table_1 t_3  LEFT JOIN  multiple_table_db_2143_simple_table_10 t_4 ON ( ((t_3.decimal_field1 >= t_4.decimal_field1) AND (t_3.decimal_field1 < t_4.decimal_field1) OR t_3.char_field1 IS NOT NULL) )      WHERE  ((t_4.bool_field1 AND t_3.primary_key_id IS NOT NULL)) OR ((NOT (t_3.bool_field1) AND t_3.decimal_field1 = 4968))

       

      returns this error:

      [
      {
      "code": 4321,
      "msg": "Plan error: buildOrScanNoPushdown: missing OR subterm",
      "query_from_user": "SELECT t_3.* FROM multiple_table_db_102_simple_table_1 t_3 LEFT JOIN multiple_table_db_102_simple_table_10 t_4 ON ( ((t_3.decimal_field1 >= t_4.decimal_field1) AND (t_3.decimal_field1 < t_4.decimal_field1) OR t_3.char_field1 IS NOT NULL) ) WHERE ((t_4.bool_field1 AND t_3.primary_key_id IS NOT NULL)) OR ((NOT (t_3.bool_field1) AND t_3.decimal_field1 = 4968))"
      }
      ]

      The explain is the same error. Logs will be attached 

      Attachments

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

        Activity

          People

            ajay.bhullar Ajay Bhullar
            ajay.bhullar Ajay Bhullar
            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