IN clause doesn't work for DATE datatype

[Edson Carlos Ericksson Richter]

I don't know if this is a known bug, so I'm reporting to you. I'm using 
MaxDB 7.6.0.12 on WinXP.
The following query doesn't work (don't return any results):
select distinct EC.CO_CONDICAO_PGTO, EC.VL_CONDICAO, CP.DS_CONDICAO_PGTO
 from TB_EVENTO_CONDICAO EC
 join TB_CONDICAO_PGTO CP
   on EC.CO_CONDICAO_PGTO = CP.CO_CONDICAO_PGTO
where EC.CO_EVENTO = ?
  and EC.ST_RESTRITO = 'F'
  and date(EC.DT_LIMITE) in (select date(min(DT_LIMITE))
                              from TB_EVENTO_CONDICAO
                             where CO_EVENTO = EC.CO_EVENTO
                               and CO_CONDICAO_PGTO =EC.CO_CONDICAO_PGTO
                               and date(DT_LIMITE) >= date)
order by CO_CONDICAO_PGTO, VL_CONDICAO

the following one works fine (returns 2 results):

select distinct EC.CO_CONDICAO_PGTO, EC.VL_CONDICAO, CP.DS_CONDICAO_PGTO
 from TB_EVENTO_CONDICAO EC
 join TB_CONDICAO_PGTO CP
   on EC.CO_CONDICAO_PGTO = CP.CO_CONDICAO_PGTO
where EC.CO_EVENTO = ?
  and EC.ST_RESTRITO = 'F'
  and date(EC.DT_LIMITE) = (select date(min(DT_LIMITE))
                              from TB_EVENTO_CONDICAO
                             where CO_EVENTO = EC.CO_EVENTO
                               and CO_CONDICAO_PGTO =EC.CO_CONDICAO_PGTO
                               and date(DT_LIMITE) >= date)
order by CO_CONDICAO_PGTO, VL_CONDICAO


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]