Union all failure: select * from (select * from t1 union all select * from t2) as x;

GridSQL -> create table t1 (c varchar(10));
OK
Response time: 0m 0s 78ms Total time: 0m 0s 78ms

GridSQL -> create table t2 (c varchar(10));
OK
Response time: 0m 0s 81ms Total time: 0m 0s 81ms

GridSQL -> select * from (select * from t1 union all select * from t2) as x;
SQLException: ERROR: Failed To Get Results For ( SQL , NodeURL) : ( SELECT "TMPTT39_1"."c" as "c" FROM "t2" ) eQS Node 10 has aborted execution, cause is: java.sql.SQLException : ERROR: missing FROM-clause entry for table "TMPTT39_1"

We recently fixed another UNION ALL subquery issue, it appears that not all cases have been fixed.

We will investigate.

Thanks,

Mason

We checked in a fix for this a number of days ago.

Thanks,

Mason