theory/pgtap v1.3.0

Release v1.3.0

on GitHub

Changes for v1.3.0:

• Fixed an issue with xUnit tests where they would exit immediately on
  unexpected errors (aside from PL/pgSQL RAISE errors) rather than exit just the
  current test function. Thanks to @kzathey for the report and to @fjf2002 for
  the analysis.
• Fixed a pluralization error reporting xUnit test failures to report "failed 1
  test" instead of "failed 1 tests".
• Removed the indentation for diagnostic comments at the start of subtests to
  make it easier to see where they start and end. This changes the output
  format, which will not affect tests run by pg_prove, but will break tests
  that depend on diffing files, as pg_regress does. Thanks to Matt DeLuco for
  highlighting the visual confusion of the indented diagnostic (#264).
• Added variants of col_is_pk() with schema and without description (variants
  without schema or description already existed). Thanks to Luca Ferrari and
  Matteo Ferrando for the PRs (#178 & #199)!
• Added a note on the use of temporary tables to the fk_ok() documentation, as
  well as a test to ensure the suggested expressions work. Thanks to Jim Nasby
  for highlighting the special treatment of the temporary schema (#109).
• Removed redundant DROP statements from the 1.2.0 upgrade script that
  prevented upgrades from working properly. Thanks to @robins for the PR
  (#300)!
• Fixed a test failure caused by the removal of support for select rules in
  postgres/postgres@b23cd18 (expected in Postgres 16). Thanks to @Deltaus for
  the report (#309)!
• Fixed LIKE expression in schemas_are() to escape the underscore wildcard,
  making it pg\_% instead of pg_%. Thanks to Jehan-Guillaume (ioguix) de
  Rorthais for the PR (#311)!
• Updated function-testing functions to allow short names for argument types, so
  that they can be specified as, e.g., int and bool rather than integer
  and boolean. The return value argument to function_returns and and data
  type tests such as col_type_is and cast_context_is must still use full
  type names. Thanks to @wphilips53 for the suggestion (#292).
• Updated type-testing functions to allow short names for types, and updated
  function-testing functions to allow short names for argument types. This means
  that common aliases for standard types can be specified as, e.g., int and
  bool rather than integer and boolean. Thanks to @wphilips53 for the
  suggestion (#292).
• Tweaked the installation docs for Docker, binary Linux distributions, and
  downloading the source from PGXN. Thanks to @jed-walker-icd (#275) and
  @machineghost (#301) for the suggestions!