Correlated Subquery, particularly inside and OUTER JOIN ON clause, is currently not supported

Query: select * from vw_triggerevent_assoc_bcap_cases LIMIT 0, 1000

Error Code: 1815

Internal error: IDB-1015: Subquery on OUTER JOIN ON clause is currently not supported.

CREATE TABLE cas_triggerevent( ASSOCIATED_BCAP_CASEID VARCHAR(10), SOURCE_DB VARCHAR(10)) ENGINE=columnstore;

CREATE TABLE cas_case( CASEID INT, ASSOCIATED_BCAP_CASEID INT, SOURCE_DB INT, REQUESTTYPECODE VARCHAR(100), GCIN INT) ENGINE=columnstore;

CREATE TABLE cas_bcapkyc(CASEID INT, SOURCE_DB INT, gcin1 INT) ENGINE=columnstore;

CREATE TABLE cas_caseflow(CASEID INT, SOURCE_DB INT, STATUSCODE INT, INDATE DATE) ENGINE=columnstore;

CREATE VIEW `vw_triggerevent_assoc_bcap_cases`

AS

	SELECT `cc`.`CASEID` AS `CASEID`

	FROM (((`cas_triggerevent` `ct`

		JOIN `cas_case` `cc`

			ON(`ct`.`ASSOCIATED_BCAP_CASEID` = `cc`.`CASEID`	AND `ct`.`SOURCE_DB` = `cc`.`SOURCE_DB`))

		JOIN `cas_bcapkyc` `cb`

			ON(`cb`.`CASEID` = `cc`.`CASEID`	AND `cb`.`SOURCE_DB` = `cc`.`SOURCE_DB`	AND `cb`.`gcin1` = `cc`.`GCIN`))

		LEFT JOIN `cas_caseflow` `cf`

			ON(`cc`.`CASEID` = `cf`.`CASEID`	AND `cc`.`SOURCE_DB` = `cf`.`SOURCE_DB`	AND `cf`.`STATUSCODE` = 'CompletedScreening'

					AND `cf`.`INDATE` = ( SELECT MAX(`e`.`INDATE`) FROM `cas_caseflow` `e` WHERE `e`.`CASEID` = `cf`.`CASEID`	AND `e`.`SOURCE_DB` = `cf`.`SOURCE_DB` AND `e`.`STATUSCODE` = `cf`.`STATUSCODE`)))

	WHERE `cc`.`REQUESTTYPECODE` IN ('CBGBranchesRequest','BCAPApplication')