Ingres as source - Query with LOCATE causing stackoverflow error ---------------------------------------------------------------- Key: TEIID-1773 URL: https://issues.jboss.org/browse/TEIID-1773 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 7.4.1 Reporter: Warren Gibson Assignee: Steven Hawkins Fix For: 7.4.1, 7.6 EDS Query Testing is getting unexpected results on 16 queries involving LOCATE. A couple examples queries are given below: SELECT INTKEY, LOCATE(1, STRINGNUM) FROM BQT1.SmallA ORDER BY intkey (Expected 50 records but received only 0) Remote org.teiid.core.TeiidProcessingException: Source: null see stackoverflow.log attached SELECT INTKEY FROM BQT1.SmallA WHERE LOCATE(1, INTKEY) = 1 ORDER BY INTKEY Remote org.teiid.core.TeiidProcessingException: Source: null Is also a stackoverflow error.