View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004529 | SymmetricDS | Bug | public | 2020-09-09 14:46 | 2020-11-09 15:14 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.12 | ||||
| Target Version | 3.10.13 | Fixed in Version | 3.10.13 | ||
| Summary | 0004529: Postgres Varchar column with no defined length getting converted to a LONGVARCHAR | ||||
| Description | When a Varchar type column (character varying) in Postgres is specified without a length, the column type gets changed into a LONGVARCHAR as the mapped type code. When this column is the primary key, then it is thrown away as the use as primary key because we don't support LONGVARCHAR or LONGVARBINARY types as primary keys, and then all columns are used as the primary key. The changing of the VARCHAR mapped type code should only be changed to LONGVARCHAR when the original column type is TEXT. | ||||
| Tags | dialect: postgresql | ||||
|
SymmetricDS: 3.10 98a8b004 2020-09-09 10:54:10 Details Diff |
0004529: Postgres Varchar column with no defined length getting converted to a LONGVARCHAR |
Affected Issues 0004529 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDdlReader.java | Diff File | ||
|
SymmetricDS: 3.11 0dbd0ed9 2020-09-09 10:54:10 Details Diff |
0004529: Postgres Varchar column with no defined length getting converted to a LONGVARCHAR |
Affected Issues 0004529 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDdlReader.java | Diff File | ||
|
SymmetricDS: 3.12 f67d8268 2020-09-09 10:54:10 Details Diff |
0004529: Postgres Varchar column with no defined length getting converted to a LONGVARCHAR |
Affected Issues 0004529 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDdlReader.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-09-09 14:46 | pmarzullo | New Issue | |
| 2020-09-09 14:46 | pmarzullo | Status | new => assigned |
| 2020-09-09 14:46 | pmarzullo | Assigned To | => pmarzullo |
| 2020-09-09 14:46 | pmarzullo | Tag Attached: dialect: postgresql | |
| 2020-09-09 14:48 | pmarzullo | Relationship added | related to 0004530 |
| 2020-09-09 14:49 | pmarzullo | Relationship added | related to 0004531 |
| 2020-09-09 15:00 | pmarzullo | Changeset attached | => SymmetricDS 3.10 98a8b004 |
| 2020-09-09 15:00 | pmarzullo | Changeset attached | => SymmetricDS 3.11 0dbd0ed9 |
| 2020-09-09 16:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 f67d8268 |
| 2020-09-09 16:22 | pmarzullo | Status | assigned => resolved |
| 2020-09-09 16:22 | pmarzullo | Resolution | open => fixed |
| 2020-09-09 16:22 | pmarzullo | Fixed in Version | => 3.10.13 |
| 2020-11-09 15:14 | admin | Status | resolved => closed |