[teiid-issues] [JBoss JIRA] Closed: (TEIID-947) UNION query with different datatypes on each side of UNION is producing inconsistent results

UNION query with different datatypes on each side of UNION is producing inconsistent results --------------------------------------------------------------------------------------------- Key: TEIID-947 URL: https://jira.jboss.org/browse/TEIID-947 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Warren Gibson Assignee: Steven Hawkins Fix For: 7.0 The following query is producing unexpected results in CTC. It is not consistent and sometimes produces unexpected results and sometimes passes. However, it can be reproduced. SELECT IntKey, IntNum FROM BQT1.SmallA UNION SELECT StringKey, StringNum FROM BQT2.MediumB ORDER BY IntKey The datatypes of each side of the union are not the same and sometimes rmdata.getColumnTypeName(++col) indicates its a string and sometimes it says its an integer. It is my understanding that the column should be implicitly converted to a consistent type (in this case a string).