outer joins with OR, might be a bug.

[Venkatarangaiah, Srinivas B. (Consultant)]

We are using latest version of Maxdb7.5.0.8.
In our application we are using view with following outer joins,
 
CREATE VIEW TEST_PURGE_CLAIM
AS
SELECT TEST_PLAYER.PLAYER_OID AS PLAYER_OID, 
MAX(TEST_PLAYER.MODIFIED_DATETIME) AS PLAYER_MD, 
MAX(TEST_CLAIMANT.MODIFIED_DATETIME) AS CLAIMANT_MD,
MAX(TEST_CLAIM.MODIFIED_DATETIME) AS CLAIM_MD,
MAX(TEST_CLAIM_TAX.MODIFIED_DATETIME) AS CLAIM_TAX_MD,
MAX(TEST_CLAIM_REASON.MODIFIED_DATETIME) AS CLAIM_REASON_MD,
MAX(TEST_PAYMENT.MODIFIED_DATETIME) AS PAYMENT_MD,
MAX(TEST_TICKET.MODIFIED_DATETIME) AS TICKET_MD,
MAX(TEST_TAX_ADJUSTMENT.MODIFIED_DATETIME) AS TAX_ADJ_MD,
MAX(TEST_COMMENT.MODIFIED_DATETIME) AS COMMENT_MD
FROM 
TEST_PLAYER LEFT OUTER JOIN TEST_CLAIMANT ON 
TEST_CLAIMANT.PLAYER_OID = TEST_PLAYER.PLAYER_OID
  LEFT OUTER JOIN TEST_CLAIM ON TEST_CLAIM.CLAIM_OID = 
TEST_CLAIMANT.CLAIM_OID
  LEFT OUTER JOIN TEST_CLAIM_TAX ON TEST_CLAIM_TAX.CLAIMANT_OID = 
TEST_CLAIMANT.CLAIMANT_OID
  LEFT OUTER JOIN TEST_CLAIM_REASON ON TEST_CLAIM_REASON.CLAIM_OID = 
TEST_CLAIM.CLAIM_OID
  LEFT OUTER JOIN TEST_TICKET ON TEST_TICKET.CLAIM_OID = 
TEST_CLAIM.CLAIM_OID
  LEFT OUTER JOIN TEST_TAX_ADJUSTMENT ON TEST_TAX_ADJUSTMENT.CLAIMANT_OID 
= TEST_CLAIMANT.CLAIMANT_OID
  LEFT OUTER JOIN TEST_PAYMENT ON TEST_PAYMENT.PAYMENT_OID = 
TEST_TAX_ADJUSTMENT.PAYMENT_OID
LEFT OUTER JOIN TEST_COMMENT ON TEST_COMMENT.OWNING_OID = 
TEST_CLAIMANT.CLAIM_OID  OR  TEST_COMMENT.OWNING_OID = TEST_CLAIM.CLAIM_OID
OR                                          TEST_COMMENT.OWNING_OID =
TEST_CLAIM_TAX.CLAIMANT_OID  OR TEST_COMMENT.OWNING_OID =
TEST_TICKET.CLAIM_OID OR  TEST_COMMENT.OWNING_OID =
TEST_TAX_ADJUSTMENT.CLAIMANT_OID
GROUP BY TEST_PLAYER.PLAYER_OID
 
It seems LEFT OUTER JOIN with OR is not working, instead of OR just for
testing if we replace by AND it works.
 
 
Is it a bug. Or some thing we are missing, Could any one please let us know
what is the correct syntax of it.
 
 
LEFT OUTER JOIN TEST_COMMENT ON TEST_COMMENT.OWNING_OID = 
TEST_CLAIMANT.CLAIM_OID OR TEST_COMMENT.OWNING_OID = TEST_CLAIM.CLAIM_OID OR
TEST_COMMENT.OWNING_OID = TEST_CLAIM_TAX.CLAIMANT_OID OR
TEST_COMMENT.OWNING_OID = TEST_TICKET.CLAIM_OID OR
TEST_COMMENT.OWNING_OID = TEST_TAX_ADJUSTMENT.CLAIMANT_OID
 
 
Exception what we get is General error;-7068 POS(1) Outer join not allowed
in this context.
 
 
 
Thanks
 
Srinivas