0.55.4

Merged PRs

doltgresql

• 2353: allow cte in CREATE VIEW
  Also fixes:
  • string_agg with separator cast with text type
  • fix parse procedure and sequence name in GRANT privileges ON statement
• 2350: add plpgsql-dynexecute statement for CREATE FUNCTION
  Also fixes:
  • type resolution in DECLARE
  • add support for TG_OP special variable usage for triggers
• 2349: Checking for table relation respects temporary tables
  Fixes #2326
  When checking for whether a root has a relation, we should respect temporary tables in addition to our existing checks for regular tables.
• 2346: Added test framework for testing wire data
  This is a precursor for:
  • #2317
    Currently, we have no in-engine way of ensuring that the proper data is received on the wire for any given sequence of messages that were sent. This means that we must rely on client tests to ensure that the correct data is sent, with the expectation that they'll fail if we change something. This isn't conducive to our standard debugging workflow, so this adds the ability to perform wire tests and verification from within the Go testing environment, which is resistant to change (client tests could fail due to a library update that is outside of our control) and easily debuggable.
    For most of these tests, I'll be using WireShark to ensure that our output is exactly the same as a standard Postgres server.

Closed Issues

• 2326: Cannot create keyless temporary tables with serial columns