Hi,
I sometimes use repeated digits as test data, for example 123456789 repeated
multiply times and recently some of my complex queries where I occasionally
wrongly chose a field gave 'unknown error' in the middle of the process.
Tracking it led to sqlite3AtoF function that appears to be raising Floating
overflow exception (at least on windows) for some extremely large numbers
The test showing the effect (tested with v3.7.5)
CREATE TABLE [Temp] ([Value] TEXT)
INSERT INTO Temp (Value) VALUES ('1234567890...') //Totally 310 digits
SELECT Cast(Value As Float) FROM Temp
the result of this query in my case is 'unknown error' and no data shown.
Can it be considered a bug? The worst part of this error is that one needs
very deep investigation especially for long queries to understand what is
going on.
Thanks,
Max
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
