[teiid-issues] [JBoss JIRA] Closed: (TEIID-800) Teiid char type should be consistently treated as char(1)

Thu Jun 10 21:11:39 EDT 2010

     [ https://jira.jboss.org/browse/TEIID-800?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Hawkins closed TEIID-800.
-------------------------------


> Teiid char type should be consistently treated as char(1)
> ---------------------------------------------------------
>
>                 Key: TEIID-800
>                 URL: https://jira.jboss.org/browse/TEIID-800
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>    Affects Versions: 6.0.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 6.2.0
>
>
> It looks like there was some initial design confusion with the Teiid character type in that it should map to the SQL char type (more specifically char(1)).  However we added the restriction that an empty string produces an exception.  This behavior is not supported by any database.  To make the type consistent with sources and to allow for eventually supporting lengths other than 1, we should treat our char type as char(1) - for the stringtochar conversion we convert empty string to ' ' and the ascii function should return null for empty string (that's the common behavior for Sybase/SQL Server/Oracle but MySQL returns 0).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira