Merged PRs

doltgresql

• 1439: Added WHEN support for triggers This adds support for WHEN on triggers, which is probably the last major trigger addition that we'll need for now.
• 1437: Fixes for prepared statements, removed custom literal type Removes doltgres's custom Literal type, uses the GMS version everywhere. This fixes various incompatibilities in GMS where an expression.Literal is expected. This is an alternate approach to the first attempt here: https://github.com/dolthub/doltgresql/pull/1406
• 1436: Added dropping triggers when dropping a table
• 1433: Add skipped test for erroring prepared query with offset
• 1432: Add support for UPDATE ... RETURNING Adds support for basic usage of UPDATE with a RETURNING clause. Limitations:
• Does not support * as an expression yet – an additional analyzer change is needed to expand * into column names. Fixes: https://github.com/dolthub/doltgresql/issues/1421 Depends on: https://github.com/dolthub/go-mysql-server/pull/2955
• 1426: Added support for triggers This adds partial support for triggers. This should cover a decent chunk of the functionality that will be expected. Notably, this is still missing:
• FOR EACH STATEMENT
• TRUNCATE
• INSTEAD OF timing
• Deferring
• Specific column triggers for UPDATE
• CONSTRAINT TRIGGERS
• Referenced tables (seemingly used for the internal foreign key implementation?)
• Transition tables
• String arguments
• The rest of the variables available inside a trigger interpreted function
• 1417: Unskipping tests
• 1411: Fixed interpretation calls within DML This implements the changes necessitated by the following fix:
• https://github.com/dolthub/go-mysql-server/pull/2949 We had a bug where calls to any DML statements that included an interpreted function would remove the DML's ability to actually affect the data. The GMS PR implements the core fix, and this PR implements the companion changes.
• 1408: Bug fix for dolt_ tables with incompatible types Fixes https://github.com/dolthub/doltgresql/issues/1405 This works by placing a typecast on unconverted dolt_ table fields so that they work in any expression that requires a doltgresType.
• 1403: Add support for SET DEFAULT foreign key referential action Fixes: https://github.com/dolthub/doltgresql/issues/798 Depends on: https://github.com/dolthub/go-mysql-server/pull/2944 Depends on: https://github.com/dolthub/dolt/pull/9121
• 1401: typo in README
• 1400: Updated readme for beta
• 1399: Add auto gc behavior interface to avoid breakage
• 1392: Add skipped tests for insert...returning bugs, fix referenced schema in column name error Fixes https://github.com/dolthub/doltgresql/issues/1394

Closed Issues

• 1421: UPDATE...RETURNING not yet supported
• 759: TSVECTOR support
• 797: Allow TEXT columns in keys (without prefix length)
• 32: Event errors in log
• 1063: Weird behavior with WHERE clause
• 1043: using column in function when creating view panics
• 1402: Unable to create FK on TEXT column to a non-pk TEXT column
• 1405: Limit on dolt_branches table returns plan is not resolved because of node '*plan.Limit' error
• 1410: undefined: reservedKeywords error during Android cross-compilation on Termux
• 798: Support for ON UPDATE/DELETE SET DEFAULT
• 1142: Panic on converting regclass to string
• 1394: INSERT with RETURNING doesn't work with referenced schema in column name