Bug 780820 (SOA-3269)

Summary:	Support different length records in files for modeling
Product:	[JBoss] JBoss Enterprise SOA Platform 5	Reporter:	Joel Tosi <jtosi>
Component:	EDS	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	medium	Docs Contact:
Priority:	medium
Version:	5.2.0 ER1	CC:	dasimmon, rploski, shawkins
Target Milestone:	---
Target Release:	5.2.0 GA, 5.2.0.ER4
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-3269
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:	Fedora 14, OpenJDK 1.6, JBDS 4 GA
Last Closed:	2011-10-10 20:32:07 UTC	Type:	Enhancement
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Joel Tosi 2011-08-15 16:53:05 UTC

project_key: SOA

If I try and model a file where there are differing length records, I get an error, i.e.

No value found for column "EMPTY_VALUE" in the row ending on text line 1 in file...

Instead I would expect to see null values.

For example, if this is my file (CSV)

HEADER,KEEP,THESE,VALUES,NOT,COLUMN,NAMES
Data, more data, other data, 2, 3, 4, 5, more data, what else, more data, and, so, on

I can read the file in but trying to model it gives me the error mentioned above.

Comment 1 Van Halbert 2011-08-15 17:53:35 UTC

Link: Added: This issue Cloned to SOA-3270

Comment 2 Steven Hawkins 2011-08-15 20:40:55 UTC

This can simply be an under the covers changes, which could be viewed as a bug fix to allow missing columns if they occur at the end of values.  Or an enhancement that would add a switch to texttable to allow missing columns.  I'm leaning toward the former.  It's unlikely that anyone is relying on Teiid to formally validate the number of column entries in delimited mode.

Comment 4 David Le Sage 2011-08-25 23:21:53 UTC

Release Notes Docs Status: Added: Not Required
Writer: Added: dlesage

Comment 5 Paul Nittel 2011-10-10 20:32:07 UTC

Tested and closed!