This is an automated email from the ASF dual-hosted git repository. ptuomola pushed a commit to branch develop in repository https://gitbox.apache.org/repos/asf/fineract.git
commit 63e427333e063ece7a29f3beb4d03a202843f71f Author: Joseph Makara <[email protected]> AuthorDate: Mon Mar 29 11:55:37 2021 +0300 Fix Duplicate entry whilst issue (FINERACT-854) --- .../sql/migrations/core_db/V365__reportCategoryList-FINERACT-1306.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/fineract-provider/src/main/resources/sql/migrations/core_db/V365__reportCategoryList-FINERACT-1306.sql b/fineract-provider/src/main/resources/sql/migrations/core_db/V365__reportCategoryList-FINERACT-1306.sql index 23253a3..794ab21 100644 --- a/fineract-provider/src/main/resources/sql/migrations/core_db/V365__reportCategoryList-FINERACT-1306.sql +++ b/fineract-provider/src/main/resources/sql/migrations/core_db/V365__reportCategoryList-FINERACT-1306.sql @@ -19,9 +19,9 @@ -- two tables added: ReportCategoryList and FullReportList (FINERACT-1306) INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) -SELECT "ReportCategoryList", 'Table', '(NULL)', '(NULL)', '(NULL)', 1, 1 +SELECT 'ReportCategoryList', 'Table', NULL, NULL, NULL, 1, 1 ON DUPLICATE key UPDATE report_name = 'ReportCategoryList'; INSERT INTO stretchy_report (report_name, report_type, report_category, report_sql, description, core_report, use_report) -SELECT "FullReportList", 'Table', '(NULL)', '(NULL)', '(NULL)', 1, 1 +SELECT 'FullReportList', 'Table', NULL, NULL, NULL, 1, 1 ON DUPLICATE key UPDATE report_name = 'FullReportList';
