View Issue Details

IDProjectCategoryView StatusLast Update
0000922SymmetricDSBugpublic2012-11-21 13:59
ReporterelongAssigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
Product Version3.1.10 
Target VersionFixed in Version 
Summary0000922: Update not captured on SQL-Server
DescriptionFor a table without a primary key that has a column of type "float", updates are not captured to sym_data. The text of the trigger joins the "inserted" table with "deleted" table using all the columns of the table, including the float columns. The join will return no results. Maybe we should cast the float to a long before joining, or maybe floats should be excluded from a default primary key.
Steps To ReproduceUse SQL-Server
Create a table without a primary key
Put columns on the table of type "float"
Update a row in the table
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2012-11-21 13:59 elong New Issue