[teiid-issues] [JBoss JIRA] (TEIID-3571) Infinispan-dsl-cache translator: Comparison operators don't work for char column
[
https://issues.jboss.org/browse/TEIID-3571?page=com.atlassian.jira.plugin...
]
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)