GitHub

Upgrade with Mysql and migration-strategy=manual when db user has non alter table permissions

We are trying to upgrade form 26.2 and getting the following error: liquibase.exception.DatabaseException: ALTER command denied to user 'keycloak'@'localhost' for table 'databasechangelog' [Failed SQL ...
Royal Society of Chemistry

Re-thinking excellence in research - RSC signs DORA

The Royal Society of Chemistry has signed the San Francisco Declaration on Research Assessment (DORA), continuing our drive to modernise how we measure excellence in the chemical sciences. We are the ...
GitHub

[MySQL] Migrated tables CREATE TABLE syntax not idempotent

DROP TABLE IF EXISTS `foo_table`; CREATE TABLE `foo_table` ( `FOO_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `BAZ_NM` varchar(250) DEFAULT NULL, PRIMARY KEY (`FOO_ID`) ); In the resulting output ...
STAREAST

Common Table Expressions in MySQL 8

It is not uncommon that a single SQL statement such as a SELECT statement includes sub-SQL SELECT statements, or sub-queries, that generate a sub-result set within the top-level statement. If these ...