Project

General

Profile

bug #9634

Update AgentBase and DescriptiveDataSet titleCache length where needed

Added by Andreas Müller 5 months ago. Updated 4 months ago.

Status:
Closed
Priority:
Highest
Category:
cdm
Target version:
Start date:
05/27/2021
Due date:
% Done:

100%

Severity:
normal
Found in Version:

Description

In some databases the AgentBase titleCache has only length 255, not 800. Also the DescriptiveDataSet titleCache has usually only 255, not 800. This needs to be updated. On production AgentBase and DescriptiveDataSet and both it's AUD tables have already been fixed.

ALTER TABLE `AgentBase`
    CHANGE COLUMN `titleCache` `titleCache` VARCHAR(800) NULL DEFAULT NULL COLLATE 'utf8_general_ci' AFTER `protectedtitlecache`;
ALTER TABLE `AgentBase_AUD`
    CHANGE COLUMN `titleCache` `titleCache` VARCHAR(800) NULL DEFAULT NULL COLLATE 'utf8_general_ci' AFTER `protectedtitlecache`;
ALTER TABLE `DescriptiveDataSet`
    CHANGE COLUMN `titleCache` `titleCache` VARCHAR(800) NULL DEFAULT NULL COLLATE 'utf8_general_ci' AFTER `protectedTitleCache`;
ALTER TABLE `DescriptiveDataSet_AUD`
    CHANGE COLUMN `titleCache` `titleCache` VARCHAR(800) NULL DEFAULT NULL COLLATE 'utf8_general_ci' AFTER `protectedTitleCache`;

The above is only for MySQL. Maybe it is enough to udpate MySQL.

Statement to find open issues on MySQL:

SELECT *
FROM COLUMNS c
WHERE c.COLUMN_NAME = 'titleCache' AND c.CHARACTER_MAXIMUM_LENGTH <> 800 
ORDER BY c.TABLE_SCHEMA, c.TABLE_NAME

Associated revisions

Revision b69c47b9 (diff)
Added by Andreas Müller 4 months ago

ref #9634 Increase size for AgentBase.titleCache to 800

History

#1 Updated by Andreas Müller 5 months ago

  • Description updated (diff)

#2 Updated by Andreas Müller 4 months ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 50

#3 Updated by Andreas Müller 4 months ago

  • Target version changed from CDM UML 5.28 to Release 5.25

#4 Updated by Andreas Müller 4 months ago

  • Status changed from Resolved to Closed
  • % Done changed from 50 to 100

I did run the "find open issue" statement on edit-test and edit-integration and could not find any open issues except for those which have not been updated yet via schema update (cdm_pesi_erms, cdm_pesi_euromed, cdm_rl_plantae).

So I think we can close the ticket as the update script works.

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)