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 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"*] "test1 " [*"=" operator*] I can get a result SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id ='TEST1'; [*"IN" operator*] I can not get a result SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id IN ('TEST1', 'TEST2');