org.teiid.padSpace does not affect to the "IN" operator
-------------------------------------------------------
Key: TEIID-3685
URL:
https://issues.jboss.org/browse/TEIID-3685
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.7.1
Environment: JBoss DV 6.1.2
Reporter: hisao furuichi
Assignee: Steven Hawkins
Fix For: 8.12, 8.11.4
Attachments: datasert.csv, INTERNAL_TEST.zip
org.teiid.padSpace does affect to "=" operator. But does not affect to
"IN" operator.
[data for a column named "id"]
{noformat}
"test1 "
{noformat}
["=" operator] I can get a result
{noformat}
SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id
='TEST1';
{noformat}
["IN" operator] I can not get a result
{noformat}
SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id IN
('TEST1', 'TEST2');
{noformat}