I'm utilizing an sqlite database to keep log data.
My table provides extensive 'real' type posts. After I attempt to execute queries like:
SELECT * FROM log WHERE SomeNumber = 61; SELECT * FROM log WHERE SomeNumber='61';
It'll return nothing.
SELECT * FROM log WHERE SomeNumber < 10 SELECT * FROM log WHERE SomeNumber > 10
Will return incorrect ranges.
Can there be a problem with my syntax ?
It truly is dependent on which you place to your table. Real amounts are nearly always globally tricky. A "real" worth of 61 may be saved as 61.0000000000001. The fundamental premise is, if you want to look for equality, prefer integers.
You might like to try:
SELECT * FROM log WHERE SomeNumber = 61.0;
It could also rely on just how much precision you joined your original value with.
NB: I ought to explain that normally, an integer value like 61 is saved precisely even while a genuine. Case a simplification.