Hi, sqlite works like any other database I know, and afaik conforms to sql standard.
Martin nick huang schrieb: > Hi Igor, > > > > You are absolutely right that its type is NULL and min(id) returns 0 as I use > sqlite_column_int64 to retrieve data. However, isn't it confusing that the > "sqlite3_step" returns SQLITE_ROW which usually means some dataset is > returned? I mean, if it returns one NULL row, why doesn't sqlite simply > return "SQLITE_DONE" or something instead of "SQLITE_ROW"? You see, as user I > have to double-check its return type even after I get "SQLITE_ROW". In this > sense, I think it is a bug. > > > > thank you, > > > > >> To: sqlite-users@sqlite.org >> From: itandet...@mvps.org >> Date: Wed, 16 Dec 2009 21:00:43 -0500 >> Subject: Re: [sqlite] a possible bug of select min(id) from... >> >> nick huang <nickhuan...@hotmail.com> wrote: >> >>> Say a table named "url" is created with "id" as primary key. Then a >>> query like this "select min(id) from url". >>> >>> Quite unexpectedly, the result of query returns "SQLITE_ROW" and the >>> min(id) is 0. However, my table is still empty which confuses me for >>> a while. >>> >> This statement should in fact return one row, with the value of NULL. How do >> you retrieve the value? If you use sqlite3_column_int, it'll convert NULL to >> 0 for you. Check with sqlite3_column_type. >> >> Igor Tandetnik >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > _________________________________________________________________ > Windows Live: Make it easier for your friends to see what you’re up to on > Facebook. > http://go.microsoft.com/?linkid=9691816 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
