Changelog

Support casting between PostGIS geometry and geography types (close #1983) (#2495)

This adds a new _cast operator to boolean comparison expressions for fields of type geometry and geography. This allows queries to take advantage of both the more efficient and featureful operations on geometry and the more accurate distance calculations of geography, regardless of how the data is actually stored. The following syntax is used for queries that use casts:

{
  geometry_table(where: {
    geometry_col: {
      _cast: {
        geography: {
          _st_d_within: {
            distance: 1000000
            from: { type: "Point", coordinates: [1, 50] }
          }
        }
      }
    }
  }){
    name
  }
}

Other server changes

• Increase idle GC interval to workaround CPU leak issue (#2581)

• Schema cache update events from schema syncing when Hasura is horizontally scaled do not accumulate anymore (close #2542) (#2585)

• Better SQL generation when row limit is part of a permission rule (#2630)

• Fix a bug in the pg_dump api when there are unicode characters in the dump (fix #2571) (#2647)

• Fix an issue with logging when body parsing fails (fix #2555) (#2556)

Console & CLI features and fixes

• column comparision operators(like ceq,cgte, etc.) in console's permission builder are now supported (close #2040) (#2606)

  E.g. To allow the role category_manager to edit rows in the products table that exceed the configured maximum for the category (in the same table), you can define the following permission using the console:

  

• allow adding frequently used columns while creating tables + show table triggers on modify page (closes #1462) (#2240)

• add multiline and rich editing to text fields (close #458) (#2498)

• warnings are shown for names of tables, columns and relationships that do not conform to GraphQL naming convention (close #212) (#2422)

  

• error stack trace is now shown on console's error page for easier bug reports (close #2598) (#2597)

• A newAbout page is available in the console with versions info (#2334)

• fix re-introspection on header change in console graphiql (#2522)

• fix column valid typecasts logic in console (close #2519) (#2543)

• update console UI for RawSQL & Migration pages, and for notifications (#2563)

• fix issue with using citext columns in row permission builder (#2622)

• fix radio btn selection on data input in edit row page (close #2595) (#2600)

• legacy code/support for query templates removed (#2560)

• A flag to disable ci colors is now available (close #2072) (#2634)