Robert Krueger wrote: > > 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).
Thank you for reporting. Will be fixed as PTS 1123322 in 7.4.3 (>= 29). The problem is the combination of superfluous bracket + NOT + more than one qualification behind the bracket. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
