Uploaded image for project: 'Policy Framework'
  1. Policy Framework
  2. POLICY-731

PAP: sql script optimizationmodels table - dataOrder column mismatch

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Highest Highest
    • Beijing Release
    • Beijing Release
    • None

      There's a mismatch in packages/base/src/files/install/mysql/data/180601_upgrade_script.sql:

      The CREATE TABLE creates the "dataOrder" column but the INSERT using "dataOrderInfo" as the column name, therefore failing the insert statement.

      The issue affect both PE and CSIT tests, see below:

      create table `onap_sdk`.`optimizationmodels` ( `id` int(11) not null auto_increment, `modelname` varchar(767) not null, `description` varchar(1024) default null, `dependency` varchar(1024) default null, `imported_by` varchar(45) not null, `attributes` longtext, `ref_attributes` longtext, `sub_attributes` longtext, `version` varchar(45) default null, `annotation` longtext, `enumValues` longtext, `dataOrder` varchar(2000) DEFAULT NULL, primary key (`id`), unique key `optimizationmodels_uniq` (`modelname`,`version`) );

      and

      INSERT INTO `onap_sdk`.`optimizationmodels` (`modelname`, `description`, `dependency`, `imported_by`, `attributes`, `ref_attributes`, `sub_attributes`, `version`, `annotation`, `enumValues`, `dataOrderInfo`) VALUES ('hpaPolicy', 'CSIT Tests Model', '[]', 'demo', 'identity=string:defaultValue-null:required-true:MANY-false,resources=string:defaultValue-null:required-true:MANY-false', 'policyScope=MANY-true,policyType=POLICYTYPE:MANY-false,flavorFeatures=flavorFeatures-properties:MANY-true', '{\"flavorProperties-properties\":{\"score\":\"string:defaultValue-null:required-true:MANY-false\",\"featureAttributes\":\"featureAttributes-properties:required-false:MANY-true\",\"mandatory\":\"string:defaultValue-null:required-true:MANY-false\",\"hpaFeature\":\"string:defaultValue-null:required-true:MANY-false\",\"architecture\":\"string:defaultValue-null:required-true:MANY-false\"},\"flavorFeatures-properties\":{\"flavorProperties\":\"flavorProperties-properties:required-false:MANY-true\",\"flavorLabel\":\"string:defaultValue-null:required-true:MANY-false\"},\"featureAttributes-properties\":{\"unit\":\"string:defaultValue-null:required-true:MANY-false\",\"attribute\":\"string:defaultValue-null:required-true:MANY-false\",\"value\":\"string:defaultValue-null:required-true:MANY-false\",\"operator\":\"OPERATOR:required-true:MANY-false\"}}\n', 'CSIT', 'policyScope=matching-true', 'OPERATOR=[<,<equal-sign,>,>equal-sign,equal-sign,!equal-sign,any,all,subset,], POLICYTYPE=[hpaPolicy,]', '\"[resources,identity,policyScope,policyType,flavorFeatures,flavorLabel,flavorProperties,architecture,hpaFeature,mandatory,score,featureAttributes,attribute,operator,unit,value]\"');

            jhh jhh
            jhh jhh
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: