All versions since 5.11.5
5.11.5
All inherited from the latest NSchema.Core update.
Fixed
- Every remaining authored expression settles. Column defaults and generated expressions, index and exclusion predicates, and a domain’s checks and default are opaque SQL, rewritten by the engine, so a handwritten one would never match. All are now kept and declared like-for-like as they are for triggers, routines etc. An expression the database no longer reports is still drift, not a spelling to restore.
- Renaming a type no longer retypes the columns declared against it. The rename moved the type but left every reference naming the old one, so each column read as a retype.
- Recreate is now correctly blocked by dependents. Recreating a type that’s in use now causes an error.
- An identity that explicitly declares no options no longer differs from one that does so implicitly. No options at all and a set of unstated ones now compare equal.
- A sequence altered for one reason no longer restates the others. The change carries the folded options, so a plan that changes the cache does not also restate a start it never asked to change.
- Identity and sequence restarts now warn correctly. Restarts are data hazards: restarting the counter, means duplicate values are issued, meaning inserts collide with what is already stored.
5.12.0
Added
- NSQL extension. Project files can now be written as
.nsqlfiles, which can be syntax highlighted using NSchema.Core’s TextMate grammar.
Changed
- Default extension. When scaffolding or importing project files, the default file extension is now
.nsql
5.13.0
Added
- Tab completion installs itself. The first time
nschemaruns at an interactive terminal, it installs completion for the current shell. - The install is gated behind a
[y/N]prompt when a startup file would have to be edited. - It never triggers on CI, in pipes, or more than once per shell (a decline is remembered).
Changed
- Repository merge. The
NSchema.Coreengine now lives in this repository and ships with the CLI from a shared tag, with one version covering both packages. completion installavoids startup-file edits where it can. It now prefers a directory the shell loads completions from automatically.
5.14.0 Latest
Added
- Publication support.
CREATE PUBLICATION ...is now valid syntax under NSchema. Support will be added downstream in due course where possible. - Replica identity.
CREATE TABLE … ( … ) REPLICA IDENTITY {FULL | NOTHING | USING INDEX name};can be used to configure a row’s identity to subscribers.