[teiid-issues] [JBoss JIRA] (TEIID-3571) Infinispan-dsl-cache translator: Comparison operators don't work for char column

[Van Halbert (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13093620#comment-13093620 ] 

Van Halbert commented on TEIID-3571:
------------------------------------

Because protobuf's don't support a char data type, one should use a String type.   And then use a teiid view on top of the source table to limit the size.    

Another possible option, would be handle the transition in the protobuf marshaller.    However, the searching isn't controlled thru the marshaling, and there appears to be another issue somewhere as the searching that still doesn't work.  So more research into what's possible still needs to be done here.   

> Infinispan-dsl-cache translator: Comparison operators  don't work for char column 
> ----------------------------------------------------------------------------------
>
>                 Key: TEIID-3571
>                 URL: https://issues.jboss.org/browse/TEIID-3571
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.7.1
>            Reporter: Filip Elias
>            Assignee: Van Halbert
>         Attachments: serverLog.txt
>
>
> Comparison operators returns wrong result for column of type Character.
> Sample queries:
> {code}
> SELECT CharValue FROM SmallA WHERE SmallA.CharValue < '1'
> SELECT CharValue FROM SmallA WHERE SmallA.CharValue = '1'
> {code}
> These queries return no row even though they should have returned more than 20 rows.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)