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

Aggregate Pushdown does not work with +Inf values

    XMLWordPrintable

Details

    • Untriaged
    • Centos 64-bit
    • Unknown

    Description

      When trying to pushdown a query, the indexer doesn't handle +inf values and maybe also -inf values.

      Query:

      SELECT SUM(EXP(decimal_field1) )
      FROM simple_table_db_74549072_simple_table
      WHERE decimal_field1 < 4987 and decimal_field1 > 4512
      GROUP BY int_field1

      Index: 

      CREATE INDEX simple_table_aggregate_pushdown_index_30464775
      ON simple_table_db_74549072_simple_table( decimal_field1 , EXP( decimal_field1 ) + 2 , RADIANS( decimal_field1 ) - 2 , FLOOR( decimal_field1 ) - 2 , int_field1 ) USING GSI

      Error:

      [
      {
      "code": 5000,
      "msg": " json: unsupported value: +Inf from [127.0.0.1:9101] - cause: json: unsupported value: +Inf from [127.0.0.1:9101]",
      "query_from_user": "SELECT SUM(EXP(decimal_field1) )\nFROM simple_table_db_74549072_simple_table \nWHERE decimal_field1 < 4987 and decimal_field1 > 4512\nGROUP BY int_field1"
      }
      ]

      I have attached backups

       

      ./cbbackupmgr config --archive /opt/couchbase/bin/backup --repo temp
      ./cbbackupmgr backup --archive /opt/couchbase/bin/backup --repo temp --host couchbase://192.168.10.10 --username Administrator --password password

      Attachments

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

        Activity

          People

            prathibha Prathibha Bisarahalli (Inactive)
            korrigan.clark Korrigan Clark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty