View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000922 | SymmetricDS | Bug | public | 2012-11-21 18:59 | 2022-10-04 15:15 |
| Reporter | elong | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.1.10 | ||||
| Target Version | 3.14.2 | Fixed in Version | 3.14.2 | ||
| Summary | 0000922: Float used on table without primary causes update to not capture | ||||
| Description | For 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 Reproduce | Use 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 | ||||
| Tags | dialect: sql-server, trigger | ||||
|
SymmetricDS: 3.14 038cfcc9 2022-08-30 20:09:42 evan-miller-jumpmind Details Diff |
0000922: Prevented floats, doubles, and reals from being included in where clauses and joins, also ran spotlessApply |
Affected Issues 0000922 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/JdbcDatabasePlatformFactory.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/ase/AseDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/Db2DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/derby/DerbyDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2000DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2016DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mysql/MySqlDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/tibero/TiberoDatabasePlatform.java | Diff File | ||
| 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 |