Changeset 5513


Ignore:
Timestamp:
Nov 19, 2010, 1:39:00 PM (13 years ago)
Author:
Nicklas Nordborg
Message:

Fixes #1555: Exception: Could not execute native bulk manipulation query when editing a unit

Location:
branches/2.16-stable/src/core
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • branches/2.16-stable/src/core/common-queries.xml

    r5456 r5513  
    34193419  <query id="RECALCULATE_ANNOTATIONS_WITH_ANNOTATIONTYPE" type="SQL">
    34203420    <sql>
    3421       UPDATE {1}
    3422       SET value = value * :factor + :offset
    3423       WHERE id IN
     3421      UPDATE [{1}]
     3422      SET [value] = [value] * :factor + :offset
     3423      WHERE [id] IN
    34243424      (
    34253425        SELECT [value_id]
    … …  
    34483448  <query id="RECALCULATE_ANNOTATIONS_FOR_UNIT" type="SQL">
    34493449    <sql>
    3450       UPDATE {1} SET value = value * :factor + :offset
    3451       WHERE id IN
     3450      UPDATE [{1}] SET [value] = [value] * :factor + :offset
     3451      WHERE [id] IN
    34523452      (
    34533453        SELECT [a].[value_id]

  • branches/2.16-stable/src/core/net/sf/basedb/core/AnnotationType.java

    r5121 r5513  
    408408              "RECALCULATE_ANNOTATIONS_WITH_ANNOTATIONTYPE", tableName);
    409409            /*
    410               UPDATE {1} SET value = value * :factor + :offset
     410              UPDATE [{1}] SET [value] = [value] * :factor + :offset
    411411              WHERE id IN
    412412              (

  • branches/2.16-stable/src/core/net/sf/basedb/core/Unit.java

    r5512 r5513  
    513513            "RECALCULATE_ANNOTATIONS_FOR_UNIT", tableName);
    514514          /*
    515             UPDATE {1} SET value = value * :factor + :offset
    516             WHERE id IN
     515            UPDATE [{1}] SET [value] = [value] * :factor + :offset
     516            WHERE [id] IN
    517517            (
    518518              SELECT [a].[value_id]
Note: See TracChangeset for help on using the changeset viewer.