Skip to content

Pistachio

v0.20.0 Bugfix

This release fixes issues for SREs watching stability and regressions.

Published 3mo Relational Databases
✓ No known CVEs patched
Read the diff → Tool health → What is this tool? →

✓ No known CVEs patched in this version

Topics

cli database-migration database-migrations db-migration ddl declarative
+7 more
declarative-migrations go postgresql schema-changes schema-management schema-migration schema-migrations

Summary

AI summary

Fixes handling of NOT VALID constraints in parser and diff logic.

Full changelog

Changelog

  • f50d342c3ea7c6296da4861a85d7359d7e054859 Merge pull request #83 from winebarrel/add-cli-scenario-tests
  • 3ec702928263f306c5d0b8000ea68acc151f8f62 Narrow assert_no_drop pattern to protected drop types only
  • 19a7ab88c0c8eac873ae99a323b08d1738492189 Add -X to psql invocations to skip .psqlrc
  • 6182c3615817360aa3688fc2409af4f96f821431 Fix set -e compatibility and remove redundant 2>&1
  • 9a3950b2a8cc7bc584c7e8755df5fb84decd7c5e Skip grep checks when pist plan fails in Part 3
  • 637e6260c1d084e0d769463cc2e0626bd16516b7 Address Copilot review: TEST_PIST_CONN_STR fallback, consistent grep
  • 4fe911410e6b014396e4247987444332c2dbeccb Address Copilot review: psql error handling, drop assertions
  • b8c76b74ecd2b3bebfc5c7169c47f301d8a19f3b Address Copilot review feedback on drop policy tests
  • 77f8a078e96bad7ef2d208838d9a74ba23db424c Merge remote-tracking branch 'origin/main' into add-cli-scenario-tests
  • ba83d05fd05fe5ab96f608cb942083934adfc65a Fix .gitignore to only ignore root-level SQL files
  • 2f933aa92aa654de043828009a73c808f3c6a7aa Add drop policy scenario tests
  • a16007b5b365034e4a389d3f1787d1375b4df6e5 Address Copilot review feedback on helper.sh
  • e2fbb791272e7ed692d0393a026d28e7bdbf7b99 Add scenario tests for chinook, lego, periodic_table, and titanic
  • 4a9c122be4bc7a6a731d91e3d8a9e72ef531996d Add test-scenario step to CI workflow
  • 5ac8e33ea1b68a8351b18c98e55df848594608d8 Add CLI scenario tests for world and usda sample schemas
  • 72455433ee27bf46fd2e15316dd0221cf0820bdb Merge pull request #82 from winebarrel/add-sample-schemas-world-usda
  • 070ab0a4b01196f4c191d3cbb64709eee9afb1a6 Add world and usda sample schemas to make schema
  • a25263e89cfce2395544c73b726a44ff4ac1f611 Merge pull request #81 from winebarrel/improve-test-coverage
  • 90df3de1f223e4abaf5b275aaa8f52fce52b8f71 Improve test coverage for diff and root packages
  • d40f6e21eeb8e397d57cc2461196c352fd69bc0d Merge pull request #80 from winebarrel/add-missing-test-cases
  • 8f5f4799c5d511f788bf6de82bffda2e7f8a2404 Add missing test cases for parser, plan, apply, and dump
  • 1d68ea4dfec7306c7ca15adfa6f451b85b627f97 Merge pull request #79 from winebarrel/fix-not-valid-double
  • dc78115b65e8aec32092145f309bceb622e13bd3 Assert Definition does not contain NOT VALID in parser tests
  • 0063826fe6401dfaf25f39013b34902dde77e6ae Strip NOT VALID from catalog constraint definitions
  • 552ae38778cce51f9b64d4d31c818c0cf4103928 Fix double NOT VALID in FK and check constraint definitions
  • 0eed9b1b2b42e7335f5a71b582b8b147d7a26042 Merge pull request #78 from winebarrel/add-claude-md
  • bdc2737d9e11825eb6fb2dbae921137c5f132671 Clarify TEST_OPTS and make schema description in CLAUDE.md
  • eafecb8949db954e4280d0a4ae4f46c2346b979f Fix testdata description to include both integration and unit tests
  • 2c59669eb35a521f02c37adae41d6d5031575169 Fix test package naming convention and fixture format descriptions
  • 15e8f1df3abac3c013d4206d4048004e62e1476a Add CLAUDE.md with project documentation and development workflow
  • 812864d8c9f915cb60abdc5e749b0e255e96a007 Merge pull request #77 from winebarrel/fix-not-valid-diff
  • 6bcb5fc1a43bb424dc35428982016006c95ce8b2 Return rename mapping directly from detectRenames functions
  • c4c2d76226479b5ca086fdbc53167312a335ecf4 Fix rename-already-applied + recreation for FK and check constraints
  • 386ac95101a8428b4427a4b8d218462a0286fb2e Fix rename + recreation ordering for check constraints
  • 67e5a16f44816b429b1a2d23f5301b73ab21684f Fix rename + recreation ordering for foreign keys
  • e1cb0dc6684c84fb97e714e479ea0e39d3484baa Add test for check constraint definition + validated simultaneous change
  • ff829291601a756e051e0a887af6d21f81de901c Support NOT VALID for check constraints
  • e33ccbab95b5755c4af2b475abd7abc0a2852c5c Add test for rename + validated to NOT VALID transition
  • d76d6a0d93755a2cd3d3d13fbaacceedbad6a0c4 Use VALIDATE CONSTRAINT for NOT VALID → validated transition
  • 4b7245bc20bdf17277ac11cfb6e50d2c9d148eac Add test cases for NOT VALID FK diff: add with NOT VALID, definition + validated change
  • 079af0413d7d69d214f3e885667a2206ce473ca4 Fix diffForeignKeys to detect NOT VALID changes
View diff on GitHub

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

Share this release

Share on X Share on Bluesky

Track Pistachio

Get notified when new releases ship.

Sign up free

About Pistachio

All releases →

Related context

Beta — feedback welcome: [email protected]