Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Labels:None
-
Environment:MS SQL Server 2005
-
Number of attachments :
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.