View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004530SymmetricDSBugpublic2020-09-09 14:472020-09-23 20:34
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.12 
Target Version3.11.12Fixed in Version3.11.12 
Summary0004530: 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 0004529 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.

Issue History

Date Modified Username Field Change
2020-09-09 14:47 pmarzullo New Issue
2020-09-09 14:47 pmarzullo Status new => assigned
2020-09-09 14:47 pmarzullo Assigned To => pmarzullo
2020-09-09 14:47 pmarzullo Tag Attached: dialect: postgresql
2020-09-09 14:48 pmarzullo Relationship added related to 0004529
2020-09-09 14:49 pmarzullo Relationship added related to 0004531
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.11.12
2020-09-23 20:34 admin Status resolved => closed