Apache Derby 10.5.1.1 was released two days ago. See the full announcement here.
In addition to lots of bug fixes and documentation fixes, there are a number of new features in this release, including
- SQL roles
- Read more in my previous blog entry
- SQL generated columns
- Read more in my previous blog entry
- LOB improvements
- Many performance and usability improvements for BLOBs and CLOBs
- Replication improvements
- Replication is now also possible with encrypted databases
- SQL OFFSET/FETCH (aka limit functionality)
- Read more in my previous blog entry
- In-memory storage engine
- Read more in my previous blog entry
- Update Statistics Stored Procedure
- Refresh outdated index cardinality statistics in an easier fashion. More info here and here
Also, the index split deadlock frequently seen in previous releases has been fixed.
