Bug 1037932 - Unhandled exception: Add language field allows more character than the database does (255)
Unhandled exception: Add language field allows more character than the databa...
Product: Zanata
Classification: Community
Component: Component-UI (Show other bugs)
Unspecified Unspecified
medium Severity high
: ---
: 3.3
Assigned To: Patrick Huang
Damian Jansen
Depends On:
Blocks: 1037933
  Show dependency treegraph
Reported: 2013-12-04 00:40 EST by Damian Jansen
Modified: 2014-03-20 01:47 EDT (History)
4 users (show)

See Also:
Fixed In Version: 3.3.0-SNAPSHOT (2014-02-14)
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2014-03-20 01:47:20 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Damian Jansen 2013-12-04 00:40:09 EST
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-22 19:38:02 EST
Comment 2 Patrick Huang 2013-12-22 19:38:35 EST
Comment 3 Damian Jansen 2014-02-12 20:51:52 EST
On QA?
Comment 4 Damian Jansen 2014-02-13 23:33:44 EST
Verified at 9c46eb0cc798a1883e066057221a503690c6c6a2
Comment 5 Sean Flanigan 2014-02-18 01:57:39 EST
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 01:47:07 EST
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 01:47:20 EDT
Closing VERIFIED bugs for Zanata server 3.3.2.

Note You need to log in before you can comment on or make changes to this bug.