[sqlite] terrible behavior

[emilia12]

hi guys
i need help :-)

what is the problem :
(SQLite version 3.3.4, win XP)

i have a table:

CREATE TABLE plan(personid INTEGER, curseid INTEGER, statid
INTEGER);
INSERT INTO plan VALUES(1,1,0);
INSERT INTO plan VALUES(2,1,0);
INSERT INTO plan VALUES(3,1,0);
INSERT INTO plan VALUES(4,1,NULL);
INSERT INTO plan VALUES(5,1,NULL);
INSERT INTO plan VALUES(6,1,NULL);
INSERT INTO plan VALUES(7,1,NULL);
INSERT INTO plan VALUES(8,1,NULL);
-- ...

and i need to select all rows with "statid" = 0
so the query is :
SELECT statid
FROM plan P1
WHERE P1.curseid = 0;

BUT what a surprise, i got an empty result (i expect to get
rows No 1 to 3) !

any suggestions?

regards
Emily




-----------------------------

“БЯЛА КНИГА на българските телекомуникации, услуги и технологии”
Регистрирай се и я изтегли БЕЗПЛАТНО!
www.jnn-marketing.com/WPTelecom.htm