This update is a part of Spine 1.9.0 release.
Notable changes:
-
Widen the database-specific data type for
InboxId
and other IDs (#168).
VARCHAR(512)
is now to store identifiers (turned into strings) for all known Spine-specific tables. -
Improve actual SQL-based querying when running against
MySQL
(#169).
SQL queries generated via Querydsl are optimised, when the underlying RDBMS is MySQL.
In particular:- updates of single Entities or single messages (such as
InboxMessage
) were optimized for MySQL by usingINSERT ... ON DUPLICATE KEY UPDATE …
clause, - MySQL-specific queries are only used if the JDBC driver contains
"mysql"
(with the case ignored) in its FQN, - previously available functionality on trimming the
Aggregate
storage was implemented properly, as its execution against real MySQL server led to SQL errors earlier.
- updates of single Entities or single messages (such as
-
ORDER BY
validation (#169).
TheORDER BY
column names are now checked for correctness prior to using them in a query, addressing #160. -
Proper
Inbox
pagination.
Inbox
contents are now properly paginated, addressing #136. -
Third-party dependency updates:
- Querydsl is now at
5.0.0
.
- Querydsl is now at