pwargulak opened a new pull request, #6747: URL: https://github.com/apache/fineract/pull/6747
## Description [FINERACT-3001](https://issues.apache.org/jira/browse/FINERACT-3001) Adds `0093_wc_loan_foreign_key_indexes.xml` with indexes on `m_wc_loan_charge(loan_id)`, `m_wc_loan_disbursement_detail(wc_loan_id)` and `m_wc_loan_transaction_relation` (`from_loan_transaction_id`, `to_loan_transaction_id`, `to_loan_charge_id`). The first had no index on any database; the others are foreign keys, which PostgreSQL does not index. On PostgreSQL the indexes are built with `CREATE INDEX CONCURRENTLY` outside a transaction, as in `0177_acc_journal_entry_index.xml`; on MySQL/MariaDB a plain `CREATE INDEX`, which takes over from the index backing the foreign key. Each changeset is guarded by an index-exists precondition. Run locally: on the three changes together (FINERACT-3000, 3001, 3002) on develop 537e19aaa9: spotless, checkstyle, rat, javadoc, spotbugs and the Liquibase DDL safety check are clean; the core build; the unit suites of `fineract-provider` (1899 tests), `fineract-working-capital-loan` (1721) and `fineract-cob` (5), no failures; and all 76 Working Capital and COB integration test classes (748 tests) on PostgreSQL, MariaDB and MySQL, where the five indexes were checked to exist. Not run: the other integration test classes and the e2e (Cucumber) suite. ## Checklist - [x] Write the commit message as per [our guidelines](https://github.com/apache/fineract/blob/develop/CONTRIBUTING.md#pull-requests) - [x] Acknowledge that we will not review PRs that are not passing the build _("green")_ - it is your responsibility to get a proposed PR to pass the build, not primarily the project's maintainers. - [x] Create/update [unit or integration tests](https://fineract.apache.org/docs/current/#_testing) for verifying the changes made. - [x] Follow our [coding conventions](https://cwiki.apache.org/confluence/display/FINERACT/Coding+Conventions). - [ ] Add required Swagger annotation and update API documentation at fineract-provider/src/main/resources/static/legacy-docs/apiLive.htm with details of any API changes - [x] [This PR must not be a "code dump"](https://cwiki.apache.org/confluence/display/FINERACT/Pull+Request+Size+Limit). Large changes can be made in a branch, with assistance. Ask for help on the [developer mailing list](https://fineract.apache.org/#contribute). - [x] If merging this PR resolves a JIRA issue, I will mark that issue as resolved and set "Fix Version/s" appropriately. - [x] I followed the [AI Policy](https://github.com/apache/fineract/blob/develop/CONTRIBUTING.md#ai-policy). -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
