Created attachment 927805 [details]
Full server log.

Description of problem:
Unexpected exception. Returned exception indicates that query failed but there is no reason in message.

Version-Release number of selected component (if applicable):


How reproducible:
Source databse - Greenplum
VDB view model - BQT1
  tables: smalla - 
  `INTKEY` integer primary key,
  `STRINGKEY` varing(10),
  `INTNUM` integer,
  `STRINGNUM` varing(10),
  `FLOATNUM` real,
  `LONGNUM` bigint,
  `DOUBLENUM` double,
  `BYTENUM` smallint,
  `DATEVALUE` date,
  `TIMEVALUE` time,
  `TIMESTAMPVALUE` timestamp,
  `BOOLEANVALUE` boolean,
  `CHARVALUE` character(1),
  `SHORTVALUE` smallint,
  `BIGINTEGERVALUE` bigint,
  `BIGDECIMALVALUE` decimal(10,0),
  `OBJECTVALUE` bytea

SQL Query - SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY = (SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY = B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a

Steps to Reproduce:
1.
2.
3.

Actual results:
TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."timevalue", cast(g_0."bytenum" AS smallint), (SELECT g_1."floatnum" FROM "smalla" AS g_1 WHERE g_1."intkey" = g_0."intkey" AND g_1."intkey" = (SELECT g_2."intkey" FROM "smalla" AS g_2 WHERE g_2."stringnum" > '10' AND g_2."intkey" = g_1."intkey")) FROM "smalla" AS g_0]

Expected results:
Remote org.postgresql.util.PSQLException: ERROR: Interconnect Error: Unexpected Motion Node Id: 2.  This means a motion node that wasn't setup is requesting interconnect resources.

Additional info:
Log and exception stack trace in attachment.