Hi, I encountered a strange bug.
the query (I know the conditions don't make sense but still it shouldn't behave that way): select ATH_ID, ATH_FIRSTNAME, ATH_LASTNAME from V_ATHLETE_INFO, ADDRESS, COUNTRY where ATH_ADR_ID=ADR_ID AND ADR_CTR_ISO=COUNTRY.CTR_ISO AND ATH_STATUS = 1 AND (NOT ATH_STATUS = 2 AND NOT ATH_STATUS = 3) AND ATH_PF_ONLY = false AND ATH_DSC_ID = 'sfd' results in [-8004] (at 239): Constant must be compatible with column type and length if I change the order of the conditions it works, e.g. like so: select ATH_ID, ATH_FIRSTNAME, ATH_LASTNAME from V_ATHLETE_INFO, ADDRESS, COUNTRY where ATH_ADR_ID=ADR_ID AND ADR_CTR_ISO=COUNTRY.CTR_ISO AND ATH_STATUS = 1 AND ATH_DSC_ID = 'sfd' AND (NOT ATH_STATUS = 2 AND NOT ATH_STATUS = 3) AND ATH_PF_ONLY = false That looks like a bug to me. Do you need all table and view definitions to investigate further? This happens on 7.3 and 7.4 (7.4.3 build 017-123-039-277). Regards, Robert _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
