Okaaaayyy?
you use

>  * Using this code - no bug  
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
<pre>
but
<pre>
> * Using this code - bug  
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.01.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.01.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.01.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.01.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.02.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.02.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.02.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.02.2010})  

the upper is all one date, the lower not

if you use something like

      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-01})      
      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-01})      
      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-01})      
      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-01})      
      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-02-01})      
      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-02-01})      
      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-02-01})      
      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-02-01})      

it happens with your format too.

Problem seems to be within COUNT(DISTINCT ..) of a field grouped and datetime in the group rather then in the datetime format

Agnes
>Hi everybody,
>
>Found an interesting bug report on foxclub.ru website which I can easily reproduce. Not sure, how useful this is, but just an interesting case:
>
>

>CREATE TABLE rc (id_pp int, dat_b date)    
>SET STRICTDATE TO 0   
> && SET DATE GERMAN   
>  SET DATE AMERICAN   
>  &&USE IN query  
> && SELECT rc  
>    
>  ZAP IN rc  
>    
> * Using this code - bug  
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.01.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.01.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.01.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.01.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.02.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.02.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.02.2010})   
> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.02.2010})  
>    
>     
>  * Using this code - no bug  
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
>    
> *BROWSE  
>      SELECT id_pp,dat_b, COUNT(DISTINCT id_pp) AS countp FROM rc GROUP BY id_pp,dat_b