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

[XDCR] Adv filtering some number functions not working as expected

    XMLWordPrintable

Details

    • Untriaged
    • Centos 64-bit
    • No

    Description

      According to the design doc, niql number functions are supported in adv filtering, but ASIN and ACOS functions are not working as expected.
      https://docs.google.com/document/d/19PkXWG8ovTS-E7l2Fqg_kRwsPTh_wHhjrrFBFPOWzQs/edit?pli=1#heading=h.jue93z4nyvp5

      However, ATAN() in adv filter matches niql results.

      doc:

      {
        "string_short": "x",
        "string_medium": ")nx.\n\tPfDEEptfV2o",
        "int": 93,
        "float": 16.770881608010846,
        "string_long": "KfdVIYXB4Hk@uA9ZrChdOGP\r^lEd/l lQaAEoqGTfznioxXTsxlDy\fkBWmIiAe\nRPqm6.-\\RK%ZE&WzSn)rvt_IJi",
        "string_vlong": "egof$\ryps<QmEaQhg",
        "bool": false
      }
      

      working filter (the doc matches this filter and is replicated to target):
      ATAN(int)<>3.05682983181e+307

      not working (doc matches filter but is NOT replicated to target):
      ASIN(int)<>3.05682983181e+307
      ACOS(int)<>3.05682983181e+307

      Following queries return 1 when the above doc is present in src:

      SELECT COUNT(*) FROM default WHERE 'ACOS(int)<>3.05682983181e+307'
      SELECT COUNT(*) FROM default WHERE 'ASIN(int)<>3.05682983181e+307' 
      

      Attachments

        Issue Links

          Activity

            People

              neil.huang Neil Huang
              pavithra.mahamani Pavithra Mahamani (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty