View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006945 | SymmetricDS | Bug | public | 2025-06-16 16:08 | 2025-06-19 18:00 |
| Reporter | cquamme | Assigned To | cquamme | ||
| Priority | normal | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.16.4 | Fixed in Version | 3.16.4 | ||
| Summary | 0006945: Add overrides for isBlob and isClob for AseDatabasePlatform | ||||
| Description | Currently AseDatabasePlatform is using AbstractDatabasePlatforms isBlob and isClob method, which uses column.getMappedType() to determine if it is a blob or clob. We should add an override, because this causes issues for univarchar types. It should use column.getJdbcTypeCode(), as it did previously. Column [name=colName; jdbcType=univarchar; mappedType=LONGVARBINARY] We should also add a unit test class for AseDatabasePlatform, specifically around the canColumnBeUsedInWhereClause() method where this error occurred. | ||||
| Steps To Reproduce | 1. Setup Postgres -> Sybase ASE 2. Have a table with a primary key that is a UNIVARCHAR on the Sybase side 3. Do an update on Postgres side with "All SQL Statement" logging on, and notice that the update will not the UNIVARCHAR PK on the update for Sybase. | ||||
| Additional Information | Introduced in issue 0006674 | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.16 676f3235 2025-06-19 17:48:06 catherinequamme Committer: GitHub Details Diff |
0006945: Add overrides for isBlob and isClob for AseDatabasePlatform and tests (#300) * 0006945: Add overrides for isBlob and isClob for AseDatabasePlatform + tests |
Affected Issues 0006945 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/ase/AseDatabasePlatform.java | Diff File | ||
| add - symmetric-jdbc/src/test/java/org/jumpmind/db/platform/ase/AseDatabasePlatformTest.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-06-16 16:08 | cquamme | New Issue | |
| 2025-06-16 16:08 | cquamme | Status | new => assigned |
| 2025-06-16 16:08 | cquamme | Assigned To | => cquamme |
| 2025-06-16 16:09 | cquamme | Additional Information Updated | View Revisions |
| 2025-06-16 16:09 | cquamme | Relationship added | related to 0006674 |
| 2025-06-16 16:16 | cquamme | Description Updated | View Revisions |
| 2025-06-16 16:16 | cquamme | Description Updated | View Revisions |
| 2025-06-16 16:51 | cquamme | Steps to Reproduce Updated | View Revisions |
| 2025-06-16 16:52 | cquamme | Steps to Reproduce Updated | View Revisions |
| 2025-06-17 13:05 | cquamme | Status | assigned => confirmed |
| 2025-06-18 12:30 | cquamme | Description Updated | View Revisions |
| 2025-06-18 12:31 | cquamme | Description Updated | View Revisions |
| 2025-06-19 17:48 | pbelov | Status | confirmed => resolved |
| 2025-06-19 17:48 | pbelov | Resolution | open => fixed |
| 2025-06-19 17:48 | pbelov | Fixed in Version | => 3.16.4 |
| 2025-06-19 18:00 | Changeset attached | => SymmetricDS 3.16 676f3235 |