Merged PRs

dolt

• 8432: support partial foreign key updates companion pr: https://github.com/dolthub/go-mysql-server/pull/2690

go-mysql-server

• 2696: clear warnings better and separate warning count from actual warnings This PR cleans up the logic surrounding warnings and clearing them. The important part was separating the number of "new" warnings from the list of warnings themselves. Every query should clear out the warnings from the previous query. The exception is show warnings, which only clears the "count" of warnings. When a server runs a query that produces a warning, it immediately calls show warnings. Since the show warnings query itself should NOT clear the warnings, the warning count would always be > 0, and incorrectly indicate that show warnings produced a warning. This causes an infinite loop in .NET. Now, we always clear the warning count, and only clear the warnings themselves when the query is not show warnings. We've also had this weird problem of having to double clear warnings, which this should address. fixes:
  • https://github.com/dolthub/dolt/issues/8440
  • https://github.com/dolthub/dolt/issues/6921
• 2695: add view column information to information_schema.columns This PR has information_schema reparse create view statements to fill in missing information for the information_schema.columns table. There maybe small differences in column type for more complex views, but should be fine. Implementing using view.TextDefinition would be slightly easier/cleaner, but for some reason its sometimes empty? Seems like something to do with fragments on dolt side. fixes: https://github.com/dolthub/dolt/issues/3168
• 2692: alter underlying enum values to preserve enum strings fixes: https://github.com/dolthub/dolt/issues/7472
• 2691: Bug fix for DESCRIBE with a schema name
• 2690: only check references for updated columns fixes: https://github.com/dolthub/dolt/issues/2690
• 2689: Support for schema name in SHOW TABLE statements This provides support for show tables from public and show table from mydb.public in postgres dialects.

Closed Issues

• 8440: Connector/NET: A warning causes stack overflow
• 6921: warnings are not clearing from running the same queries multiple times
• 2690: When updating rows, Dolt requires all values in the row to satisfy constraints, not just the values changed
• 3168: information_schema.columns does not contain all associated view information
• 7472: Dolt doesn't update enum/set values when the type is changed