View Issue Details

IDProjectCategoryView StatusLast Update
0004529SymmetricDSBugpublic2020-09-09 12:22
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.10.12 
Target Version3.10.13Fixed in Version3.10.13 
Summary0004529: Postgres Varchar column with no defined length getting converted to a LONGVARCHAR
DescriptionWhen 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.
Tagsdialect: postgresql

Relationships

related to 0004530 closedpmarzullo Postgres Varchar column with no defined length getting converted to a LONGVARCHAR 
related to 0004531 closedpmarzullo Postgres Varchar column with no defined length getting converted to a LONGVARCHAR 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 98a8b004

2020-09-09 10:54:10

pmarzullo

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

pmarzullo

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

pmarzullo

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

Issue History

Date Modified Username Field Change
2020-09-09 10:46 pmarzullo New Issue
2020-09-09 10:46 pmarzullo Status new => assigned
2020-09-09 10:46 pmarzullo Assigned To => pmarzullo
2020-09-09 10:46 pmarzullo Tag Attached: dialect: postgresql
2020-09-09 10:48 pmarzullo Relationship added related to 0004530
2020-09-09 10:49 pmarzullo Relationship added related to 0004531
2020-09-09 11:00 pmarzullo Changeset attached => SymmetricDS 3.10 98a8b004
2020-09-09 11:00 pmarzullo Changeset attached => SymmetricDS 3.11 0dbd0ed9
2020-09-09 12:00 pmarzullo Changeset attached => SymmetricDS 3.12 f67d8268
2020-09-09 12:22 pmarzullo Status assigned => resolved
2020-09-09 12:22 pmarzullo Resolution open => fixed
2020-09-09 12:22 pmarzullo Fixed in Version => 3.10.13