From: Robert Krueger (kruegersignal7.de)
Date: Thu Jul 24 2003 - 08:43:49 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]