Hello,
two questions:
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?
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;
1|1
2|2
sqlite> SELECT * FROM test WHERE id < '2';
1|1
2|2
sqlite> SELECT * FROM test WHERE fld < '2';
1|1
... why fields id and fld behave different? Both are integers.
Best regards,
Witold
