> 1.
> SELECT TYPEOF(ROUND(1));
> ... returns 'text'. Is it OK? Sorry, I asked this question 2 days ago but I
> still don't know - is it a bug or not?
I don't think this is a bug, round() returns objects of type text. As well
as rounding to integers, round() can also round to a fixed number of decimal
places. Neither integer or float would work in this case, so text it is.
But I could be wrong. Somebody else on this list says there is a fix checked
in. I don't know anything about that.
> 2.
> sqlite> CREATE TABLE test(id INTEGER NOT NULL PRIMARY KEY UNIQUE, fld
> INTEGER);
> sqlite> INSERT INTO test(fld) VALUES(1);
> sqlite> INSERT INTO test(fld) VALUES(2);
> sqlite> SELECT * FROM test WHERE id < '2';
> 1|1
> 2|2
On the other hand, this one is a bug. Thanks for reporting it. It's fixed
in cvs now.
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail
