Bug 1037932

Summary: Unhandled exception: Add language field allows more character than the database does (255)
Product: [Retired] Zanata Reporter: Damian Jansen <djansen>
Component: Component-UIAssignee: Patrick Huang <pahuang>
Status: CLOSED CURRENTRELEASE QA Contact: Damian Jansen <djansen>
Severity: high Docs Contact:
Priority: medium    
Version: developmentCC: djansen, pahuang, sflaniga, zanata-bugs
Target Milestone: ---   
Target Release: 3.3   
Hardware: Unspecified   
OS: Unspecified   
Fixed In Version: 3.3.0-SNAPSHOT (2014-02-14) Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-03-20 05:47:20 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 1037933    

Description Damian Jansen 2013-12-04 05:40:09 UTC
Description of problem:
The column type for localeid is VARCHAR(255) NOT NULL. The field that allows the admin to specify the locale is not limited, and entering more than the 255 characters results in an exception

Version-Release number of selected component (if applicable):

How reproducible:
Easy always

Steps to Reproduce:
1. Sign in as admin
2. Click Languages, then Add Language
3. In the available Language field, enter a large string
4. Press Save

Actual results:
org.h2.jdbc.JdbcSQLException: Value too long for column "LOCALEID VARCHAR(255) NOT NULL": "STRINGDECODE('\ufeffThe Project Gutenberg EBook of Moby Dick; or The Whale, by Herman Melville  This eBook is for the use of any... (1235149)";

Expected results:
A limit on the field

Additional info:

Comment 1 Patrick Huang 2013-12-23 00:38:02 UTC

Comment 2 Patrick Huang 2013-12-23 00:38:35 UTC

Comment 3 Damian Jansen 2014-02-13 01:51:52 UTC
On QA?

Comment 4 Damian Jansen 2014-02-14 04:33:44 UTC
Verified at 9c46eb0cc798a1883e066057221a503690c6c6a2

Comment 5 Sean Flanigan 2014-02-18 06:57:39 UTC
I suppose the Fixed In Version should be 3.3.0-SNAPSHOT something?  

And Target Release 3.3?

Comment 6 Sean Flanigan 2014-02-21 06:47:07 UTC
I'm making up the Fixed In Version based on the project version found in the pom.xml for that commit, plus the timestamp of the commit.

Comment 7 Sean Flanigan 2014-03-20 05:47:20 UTC
Closing VERIFIED bugs for Zanata server 3.3.2.