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? >
It would make things easier and would help in our situation being some people on holiday and the working stack of the remaining increasing. Thank you Elke SAP Labs Berlin > 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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
