Hi, iam trying to sort based on geopoint and i am getting the following results, Typesense: 27.1 Collection A

{
  "name": "A",
  "fields": [
    {
      "name": "title",
      "type": "string"
    },
    {
      "name": "b_id",
      "type": "string",
      "reference": "B.id"
    },
    {
      "name": "location",
      "type": "geopoint"
    }
  ]
}

Sample Document:

{
  "id": "a.1",
  "title": "1st Document",
  "b_id": "b.1",
  "location": [
    52.47288,
    -1.899156
  ]
}

Collection B

{
  "name": "B",
  "fields": [
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "geoLat",
      "type": "geopoint"
    }
  ]
}

Sample Document

{
  "geoLat": [
    52.47288,
    -1.899156
  ],
  "id": "b.1",
  "name": "1st Document in B"
}

When i try to query collection A with sort_by as

location(52.5191058, -1.8820982):asc

The result has

"geo_distance_meters": {
     "location": 5266
 }

When i try to use sort_by using geoLat from collection B in gives me a different distance even though both location values are same

$B(geoLat(52.5191058, -1.8820982):asc)

Result:

"geo_distance_meters": {
      "geoLat": 2147483647
 }

We fixed a few bugs related to geosort on joined collections. Can you please try on

28.0.rc16

Sure

We release GA versions as and when we accumulate enough changes. But we do have folks using RC builds in production. They are generally stable and contain a mix of new features and bug fixes.

Understood, Thanks