> * 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
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.
>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