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