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

[FTS] Differing ES and FTS results for geospatial queries

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Critical
    • None
    • 7.1.2
    • fts
    • None
    • Untriaged
    • 1
    • No

    Description

      This ticket is a log of geospatial queries that return differing results with ES and FTS during functional testing. 

      The dataset for this testing is attached as `geoshape2.json`. The plots contain the query shape and the differing hits plotted as a GeoJSON file for convenient visualisation using geojson.io 

      1. A multipolygon 'intersects' query results in FTS returning 1 hit and ES returning none. 

      The executor logs showing the test failure are available on this link

      The query is in `query.json` and the plot is in `map(1).geojson`. 

       

      2. A polygon 'within' query results in FTS returning a point, but ES returns no hits.

      The executor logs showing the test failure are available here: http://qa.sc.couchbase.com/job/test_suite_executor/491922/console.

      The query is in `query2.json`. The plot is in in `map(2).geojson`. 

       

      3. A polygon 'intersects' query results in FTS returning an additional hit compared to the ES hits.

      The query is in `query3.json`. The plot is in `map(3).geojson`.

       

      4. A polygon 'within' query returning an additional hit in FTS compared to the ES hits.

      The query is in `query4.json`. The plot is in `map(4).geojson`.

       

      5. A polygon 'intersects' query returns 2 additional ES hits compared to FTS.

      The query is in `query5.json`. The plot is in `map(5).geojson`. 

       

      6. A polygon 'within' query returns an additional ES hit compared to the FTS hits.

      The query is in `query6.json`. The plot is in `map(6).geojson`. 

       

       

       

       

       

       

       

      Attachments

        1. geoshape2.json
          11 kB
        2. map (1).geojson
          3 kB
        3. map (2).geojson
          0.7 kB
        4. map (3).geojson
          0.5 kB
        5. map (4).geojson
          0.4 kB
        6. map (5).geojson
          0.5 kB
        7. map (6).geojson
          0.6 kB
        8. query.json
          9 kB
        9. query2.json
          2 kB
        10. query3.json
          1 kB
        11. query4.json
          1.0 kB
        12. query5.json
          1.0 kB
        13. query6.json
          1 kB
        14. run-1-plot-geodesic.png
          run-1-plot-geodesic.png
          174 kB
        15. run-3-plot-geodesic.png
          run-3-plot-geodesic.png
          182 kB
        16. run-4-plot-geodesic.png
          run-4-plot-geodesic.png
          211 kB
        17. run-5-plot-geodesic.png
          run-5-plot-geodesic.png
          268 kB
        18. run-6-plot.png
          run-6-plot.png
          668 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Sreekanth Sivasankaran Sreekanth Sivasankaran (Inactive)
            aditi.ahuja Aditi Ahuja
            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