Teiid Designer uses 0 as a default length value ----------------------------------------------- Key: TEIID-5111 URL: https://issues.jboss.org/browse/TEIID-5111 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 8.12 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 10.0 If you create a view in teiid designer, but define it with an expression: select case when rand() < .5 then 'heads' else 'tails' end as x A string column length will be set to 0. On the server this may cause issues such as with the odata layer that will check facets against the length of 0.