You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
2289: Table types are handled by all relevant ALTER TABLE statements
This adds the remaining ALTER TABLE statements that have special hooks for table types.
2272: Correctly support foreign key constraint violation checks during merge
This PR is mostly tests. See dolthub/dolt#10418 for most of the logic.
adds information_schema.constraint_column_usage system view as table
fix parsing schema table with double quotes in functions
allow int to be casted in regtype as int4
2268: sqlAlchemy integration tests
Integration tests for sqlAlchemy.
Pretty similar to our standard dolt sqlAlchemy tests, with a couple of differences. I used the newer version of sqlAlchemy (2.0.46) and had to make some setup changes using features that were introduced in 2.x builds.
psycopg2 seems to convert row results into python lists as well so the expected results had to be changed. I couldn't find confirmation but it seems like that would be the expected behavior (from what claude found).
2254: Issue #2197 Part 2
This fixes the other issues brought up in:
#2197
This also adds support for column access, which is used by the UPDATE statement when a new column is added.
2235: Fix windows binary name in build script
I found that starting from version 0.54.4 (after #2061), binaries for Windows are built with empty names. This PR should fix that.
2231: Add client tests for psycopg2 python client
Adds regression tests using psycopg2 for fix from #2216
#2206
I've added a skipped test to verify that the syntax error portion is fixed, however we don't yet support expression index attributes, so the test overall fails. However, the issue only covers the syntax portion which we're addressing here.
2226: Bump Dolt version
I accidentally merged #2196 while it contained a replace directive pointing to a fork of Dolt.
This PR contains the actual dolt version bump.
2223: put pg_catalog implicitly on the search_path when it isn't there already pg_catalog is always implicitly the first element on the search_path, unless it's explicitly included elsewhere: https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-CATALOG
We weren't implementing this behavior, causing us to fail to resolve ::regclass expressions in some cases with a "no such relation" error for all pg_catalog tables.
This fix isn't complete, because the same logic should also apply to all table lookups. i.e. users should be able to create a table named pg_class, and what the name pg_class resolves to depends on whether the pg_catalog schema is explicitly present in the search_path and where it is relative to the user's other schemas. That's a pretty obscure bug and is left unaddressed for now.
Fixes #2217
2219: additional tests for merging foreign keys and constraint violations
2216: Bug fix: don't send RowDescription message with each spooled batch of rows
Ensure that RowDescription messages are sent only once, at the beginning of query results. Sending multiple times, at the start of each batch of spooled rows, breaks some clients, such as psycopg2.
Note that this wasn't causing a problem in the other clients we use for testing. To properly regression test this, we should follow up with adding a test suite for psycopg2.
Related to #2143
Add adapter and test expectations for the new dolt_status_ignored system table from dolthub/dolt#10227.
This table provides the same information as dolt_status plus an additional ignored boolean column.
Changes
Add DoltgresDoltStatusIgnoredTableAdapter in server/tables/dtables/status_ignored.go
