tracker issue : CF-3698408

select a category, or use search below
(searches all categories and all time range)
Title:

PostgreSQL: ormtypes "char" and "character" set incorrect length

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/NotABug

Reporter/Name(from Bugbase): Jonathan Clausen / Jonathan Clausen (Jonathan Clausen)

Created: 01/23/2014

Components: ORM Support

Versions: 10.0

Failure Type: Data Corruption

Found In Build/Fixed In Build: Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Mac 10 All

Vote Count: 0

Problem Description:When using the ormtype of "char" and "character" in a persistent property, all columns are set with a length of "1" with the "length" attribute of the property being ignored.  String lengths are set properly for the sqltype "character varying" (which is also the default)

Steps to Reproduce:
property name="zip" column="zip" ormtype="char" length=10;

or

property name="zip" column="zip" ormtype="character" length=10;

Actual Result:
column created/updated is "character 1"

Expected Result:
column created should be "character 10"

Any Workarounds:
Use "string" ormtype.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3698408

External Customer Info:
External Company:  
External Customer Name: JJClausen
External Customer Email:  
External Test Config: My Hardware and Environment details:

OSX:

OSX v 10.9.1

Proc: 2.9 GHz Intel Core i7

Memory: 8GB 



PostgreSQL:

9.2.4 on x86_64-apple-darwin-12.5.0



CF Server:

Server Details

Server Product	 ColdFusion

Version	 ColdFusion 10,287689

Edition	 Developer  

Operating System	 Mac OS X  

OS Version	 10.9.1  

Update Level	 /Applications/ColdFusion10/cfusion/lib/updates/chf10000013.jar  

Adobe Driver Version	 4.1 (Build 0001)  





JVM Details

Java Version	 1.7.0_45  

Java Vendor	 Oracle Corporation  

Java Vendor URL	http://java.oracle.com/  

Java Home	 /Library/Java/JavaVirtualMachines/jdk1.7.0_45.jdk/Contents/Home/jre  

Java File Encoding	 UTF8  

Java Default Locale	 en_US  

File Separator	 /  

Path Separator	 :  

Line Separator	 Chr(10)  

User Name	 jonclausen  

User Home	 /Users/username  

User Dir	 /Applications/ColdFusion10/cfusion/bin  

Java VM Specification Version	 1.7  

Java VM Specification Vendor	 Oracle Corporation  

Java VM Specification Name	 Java Virtual Machine Specification  

Java VM Version	 24.45-b08  

Java VM Vendor	 Oracle Corporation  

Java VM Name	 Java HotSpot(TM) 64-Bit Server VM  

Java Specification Version	 1.7  

Java Specification Vendor	 Oracle Corporation  

Java Specification Name	 Java Platform API Specification  

Java Class Version	 51.0

Attachments:

Comments:

Please use sqlType instead of ormType property name="zip" column="zip" sqltype="char" length=53;
Comment by Himavanth R.
13626 | May 09, 2014 03:19:40 AM GMT