- Tables with check constraints are now supported for diff operations (#86, 9eb10ec)
- Skeema no longer defaults to forcing a strict sql_mode or innodb_strict_mode (540de97)
- Skeema's sessions will now use whatever the server global values are set to, minus any rare problematic sql_modes (e.g. ANSI_QUOTES)
- Users can still optionally override this using connect-options if desired
- New linter option lint-zero-date has been added to help catch the most common strict-mode violation relevant to schema management
- Several connection management improvements (00510a8)
- Skeema now auto-detects when the database has been configured to use a relatively low value for max_user_connections or max_connections, and throttles down concurrency accordingly (#157)
- The number of network round-trips per new connection has been reduced, improving performance on a WAN or VPN
- Connection pools are closed more quickly, preventing concurrent sleeping connections during some phases of Skeema's execution
- Several schema introspection changes and performance improvements
- Tables with invisible columns are now supported for diff operations in MySQL 8, in addition to the previous MariaDB support (151bdd3)
skeema init
andskeema pull
now record the current version of Skeema in the new generator option, for use in future backwards-compatibility logic (1db5e93)- workspace=temp-schema: during cleanup, execute DROP TABLEs sequentially (no concurrency) if buffer pool is large and version is pre-8.0.23 (b608688)
- workspace=docker: disable TLS for communication with local Dockerized instance for minor performance increase (0b35439)
- Bug fix: handle lingering int display widths from pre-8.0.19 releases of MySQL 8 that were later upgraded to 8.0.19+ (#158, d578215)
- Bug fix: routine bodies with particular comment format caused lexer errors (#159, 28fbe7a)
- Bug fix: diff support for edge cases of MySQL 8 column default expressions (9e2f21c)