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

Aggregate/Order should be avoiding produce result on error

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown

    Description

       

      INSERT INTO default (KEY TO_STR(k), VALUE v)
      SELECT  {"a":d, k, "comment":RPAD("a",1000,"b")} AS v
      FROM ARRAY_RANGE(0,10000) AS d
      UNNEST ARRAY_RANGE(0,5000) AS u
      LET k = (d*5000)+u;
      

       

      Create Primary index on default;

       

      SELECT d.a, COUNT(1) AS cnt
      FROM default AS d
      GROUP BY d.a
      ORDER BY cnt DESC
      LIMIT 20;
      

       

       

      Generate error By setting the backfill size to small .

      As this stop and go due to aggregate/order by. When error it should stop. Should not continue or give wrong info.

       

      At least error from indexer client should treat as Fatal and don't accumulate till allowed Limit. 

       

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-58442
          # Subject Branch Project Status CR V

          Activity

            People

              pierre.regazzoni Pierre Regazzoni
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty