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, 8.7.2.6_2 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}