Changeset 3557


Ignore:
Timestamp:
Jul 16, 2007, 9:01:56 AM (14 years ago)
Author:
Nicklas Nordborg
Message:

Fixes #648

Location:
trunk/src/core
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/src/core/common-queries.xml

    r3528 r3557  
    26672667    <sql>
    26682668      UPDATE FormulaData f
    2669       SET f.averageMethod = 1
     2669      SET f.averageMethod = 2
    26702670      WHERE f.averageMethod IS NULL
    26712671    </sql>
    26722672    <description>
    2673       A HQL query that sets the averageMethod to a for all
     2673      A HQL query that sets the averageMethod to arithmetic mean for all
    26742674      formulas with a null value.
    26752675    </description>
     
    26792679    <sql>
    26802680      UPDATE ExtraValueTypeData evt
    2681       SET evt.averageMethod = 1
     2681      SET evt.averageMethod = 2
    26822682      WHERE evt.averageMethod IS NULL
    26832683    </sql>
    26842684    <description>
    2685       A HQL query that sets the averageMethod to a for all
     2685      A HQL query that sets the averageMethod to arithmetic mean for all
    26862686      extra value types with a null value.
    26872687    </description>
  • trunk/src/core/net/sf/basedb/core/Update.java

    r3544 r3557  
    16651665        if (schemaVersion < 36)
    16661666        {
    1667           // Set averageMethod to 1 for all formulas with a null value
     1667          // Set averageMethod to arithmetic mean (=2) for all formulas with a null value
    16681668          org.hibernate.Query query = HibernateUtil.getPredefinedQuery(session,
    16691669            "SET_AVERAGE_METHOD_ON_FORMULAS");
    16701670          /*
    16711671            UPDATE FormulaData f
    1672             SET f.averageMethod = 1
     1672            SET f.averageMethod = 2
    16731673            WHERE f.averageMethod IS NULL
    16741674          */
    16751675          HibernateUtil.executeUpdate(query);
    16761676         
    1677           // Set averageMethod to 1 for all extravaluetypes with a null value
     1677          // Set averageMethod to arithmetic mean (=2) for all extravaluetypes with a null value
    16781678          query = HibernateUtil.getPredefinedQuery(session,
    16791679            "SET_AVERAGE_METHOD_ON_EXTRAVALUETYPES");
    16801680          /*
    16811681            UPDATE ExtraValueTypeData evt
    1682             SET evt.averageMethod = 1
     1682            SET evt.averageMethod = 2
    16831683            WHERE evt.averageMethod IS NULL
    16841684          */
Note: See TracChangeset for help on using the changeset viewer.