public static void checkSupportedInsertSubSelect(SelectQueryInfo sInfo) throws StandardException { if (sInfo.hasUnionNode() || sInfo.hasIntersectOrExceptNode()) { if (!(sInfo.getDriverTableQueryInfo() != null && sInfo .getDriverTableQueryInfo().isPartitionedRegion())) { // Mark 'Union / Intersect / Except' supported on Replicated Tables return; // Mark 'Intersect/ Except' Unsupported for Partitioned table // Mark 'Union All' Supported for Partitioned table // Mark 'Union' Supported for Partitioned table (filtered by Distinct // below) } } if (sInfo.isQuery(QueryInfo.HAS_DISTINCT, QueryInfo.HAS_DISTINCT_SCAN, QueryInfo.HAS_GROUPBY, QueryInfo.HAS_ORDERBY) || sInfo.isOuterJoinSpecialCase() || sInfo.hasIntersectOrExceptNode() || sInfo.isRemoteGfxdSubActivationNeeded()) { throw StandardException .newException(SQLState.NOT_IMPLEMENTED, "inserts as sub selects not supported for selects which needs aggregation"); } }
public static void checkSupportedInsertSubSelect(SelectQueryInfo sInfo) throws StandardException { if (sInfo.hasUnionNode() || sInfo.hasIntersectOrExceptNode()) { if (!(sInfo.getDriverTableQueryInfo() != null && sInfo .getDriverTableQueryInfo().isPartitionedRegion())) { // Mark 'Union / Intersect / Except' supported on Replicated Tables return; // Mark 'Intersect/ Except' Unsupported for Partitioned table // Mark 'Union All' Supported for Partitioned table // Mark 'Union' Supported for Partitioned table (filtered by Distinct // below) } } if (sInfo.isQuery(QueryInfo.HAS_DISTINCT, QueryInfo.HAS_DISTINCT_SCAN, QueryInfo.HAS_GROUPBY, QueryInfo.HAS_ORDERBY) || sInfo.isOuterJoinSpecialCase() || sInfo.hasIntersectOrExceptNode() || sInfo.isRemoteGfxdSubActivationNeeded()) { throw StandardException .newException(SQLState.NOT_IMPLEMENTED, "inserts as sub selects not supported for selects which needs aggregation"); } }
public static void checkSupportedInsertSubSelect(SelectQueryInfo sInfo) throws StandardException { if (sInfo.hasUnionNode() || sInfo.hasIntersectOrExceptNode()) { if (!(sInfo.getDriverTableQueryInfo() != null && sInfo .getDriverTableQueryInfo().isPartitionedRegion())) { // Mark 'Union / Intersect / Except' supported on Replicated Tables return; // Mark 'Intersect/ Except' Unsupported for Partitioned table // Mark 'Union All' Supported for Partitioned table // Mark 'Union' Supported for Partitioned table (filtered by Distinct // below) } } if (sInfo.isQuery(QueryInfo.HAS_DISTINCT, QueryInfo.HAS_DISTINCT_SCAN, QueryInfo.HAS_GROUPBY, QueryInfo.HAS_ORDERBY) || sInfo.isOuterJoinSpecialCase() || sInfo.hasIntersectOrExceptNode() || sInfo.isRemoteGfxdSubActivationNeeded()) { throw StandardException .newException(SQLState.NOT_IMPLEMENTED, "inserts as sub selects not supported for selects which needs aggregation"); } }