1.9.4

Released: February 16, 2023

bug

• [bug] [mssql] Ongoing fixes for SQL Server server default comparisons under autogenerate,
  adjusting for SQL Server's collapsing of whitespace between SQL function
  arguments when reporting on a function-based server default, as well as its
  arbitrary addition of parenthesis within arguments; the approach has now
  been made more aggressive by stripping the two default strings to compare
  of all whitespace, parenthesis, and quoting characters.

  References: #1177

• [bug] [postgresql] Fixed PostgreSQL server default comparison to handle SQL expressions
  sent as text() constructs, such as text("substring('name', 1, 3)"),
  which previously would raise errors when attempting to run a server-based
  comparison.

• [bug] [autogenerate] Removed a mis-use of the
  EnvironmentContext.configure.render_item callable where the
  "server_default" renderer would be erroneously used within the server
  default comparison process, which is working against SQL expressions, not
  Python code.

  References: #1180

• [bug] [commands] Fixed regression introduced in 1.7.0 where the "config" object passed to
  the template context when running the merge() command
  programmatically failed to be correctly populated. Pull request courtesy
  Brendan Gann.