Details

    • Type: Bug Bug
    • Status: Open Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Labels:
      None
    • Environment:
      MS SQL Server 2005
    • Number of attachments :
      0

      Description

      The type for the EnterStore is set to Timestamp. But the data is retrived by start and end index.

      From 1-1_3_ddl.sql:

      alter table EntryStore add UpdateTimestamp timestamp not null

      From sqlMap-entries.xml

      AND UpdateTimestamp > CAST(#startIndex# AS <include refid="timestampType"/>)
      <isNotEqual property="endIndex" compareValue="-1">
      AND UpdateTimestamp <= CAST(#endIndex# AS <include refid="timestampType"/>)
      </isNotEqual>

      We changed this to BigInt and incremented each time a row is inserted. This seemed to work and match how postgres was using the column.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Steve
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: