View Issue Details

IDProjectCategoryView StatusLast Update
0000922SymmetricDSBugpublic2022-10-04 15:15
Reporterelong Assigned Toemiller  
Status closedResolutionfixed 
Product Version3.1.10 
Target Version3.14.2Fixed in Version3.14.2 
Summary0000922: Float used on table without primary causes update to not capture
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, including one that is of type "float"
Update a row in the table
Tagsdialect: sql-server, trigger


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 038cfcc9

2022-08-30 20:09:42


Details Diff
0000922: Prevented floats, doubles, and reals from being included in where clauses and joins, also ran spotlessApply Affected Issues
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/ase/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/derby/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mysql/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/tibero/ Diff File

Issue History

Date Modified Username Field Change
2012-11-21 18:59 elong New Issue
2019-04-22 12:51 elong Tag Attached: trigger
2019-04-22 12:51 elong Tag Attached: mssql
2019-04-23 20:49 admin Tag Renamed mssql => dialect: mssql
2019-04-24 12:50 admin Tag Renamed dialect: mssql => dialect: sql-server
2022-08-02 19:19 elong Summary Update not captured on SQL-Server => Float used on table without primary causes update to not capture
2022-08-24 17:59 emiller Steps to Reproduce Updated View Revisions
2022-08-30 20:11 emiller Assigned To => emiller
2022-08-30 20:11 emiller Status new => resolved
2022-08-30 20:11 emiller Resolution open => fixed
2022-08-30 20:11 emiller Fixed in Version => 3.14.2
2022-08-30 21:00 Changeset attached => SymmetricDS 3.14 038cfcc9
2022-10-04 15:15 admin Status resolved => closed