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 Priority: Critical Fix For: 9.0, 8.12.5, 8.7.7.6_2, 8.13.6, 9.0.1 Attachments: datasert.csv, INTERNAL_TEST.zip, test.vdb 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}