[sqlite] Bug in SQLite FLOAT values

Hi there! I hope you are well! Recently I was working on project based on Android Sensors and encountered a bug in sqlite db, situation was this: I was setting there three values x,y,z as FLOAT, android inbuilt sensors were receiving values as float upto 8 decimal places, but I wanted to store

[sqlite] Bug in SQLite FLOAT values

Hi there! I hope you are well! Recently I was working on project based on Android Sensors and encountered a bug in sqlite db, situation was this: I was setting there three values x,y,z as FLOAT, android inbuilt sensors were receiving values as float upto 8 decimal places, but I wanted to store

Re: [sqlite] Bug in SQLite FLOAT values

On 07 Feb 2015 at 05:57, Abdul Aziz wrote: > *I think this is a bug, this means float values in sqlite will always be > filled upto 11-12 decimal places, in any case, you will have to fill it, or > sqlite will fill it itself with junk values, **this may create lot of >

Re: [sqlite] Bug in SQLite FLOAT values

Thanks for replybut I am now using VARCHARS, then how this is working? not generating any errors? Please elaborate, my query to create DB is: mSQLiteDatabase.execSQL("CREATE TABLE " + tableName + " ( " + EVENT_TIME + " INTEGER, " + SYSTEM_TIME + " INTEGER PRIMARY KEY, " + ACCURACY + "

Re: [sqlite] Bug in SQLite FLOAT values

On 2/7/2015 8:47 AM, Abdul Aziz wrote: Thanks for replybut I am now using VARCHARS, then how this is working? not generating any errors? When Tim said "Read this", he meant it. http://www.sqlite.org/datatype3.html answers your questions (but only if you read it). -- Igor Tandetnik

[sqlite] sqlite give "database or disk full"

Hello sqlite Users, I am using sqlite on arm-board and getting a "database or disk full" error (SQLITE_FULL) while using the update command. 1. DB file location is set to some /opt/dbspace/*.db. ( 32 Gb space and 4 GB RAM) 2. Not used compile time option SQLITE_TEMP_STORE so, deafult value

Re: [sqlite] Bug in SQLite FLOAT values

On 2015/02/07 15:47, Abdul Aziz wrote: Thanks for replybut I am now using VARCHARS, then how this is working? not generating any errors? Please elaborate, my query to create DB is: mSQLiteDatabase.execSQL("CREATE TABLE " + tableName + " ( " + EVENT_TIME + " INTEGER, " + SYSTEM_TIME + "

[sqlite] ordinary CTE containing sum()

In response to this SO question: http://stackoverflow.com/questions/28377210/how-to-retrieve-rank-based-on-total-mark-in-sqlite-table I tried to formulate a query without temp tables using an ordinary CTE, but received an error "misuse of aggregate: sum()". This works: sqlite> with tt (S_id,

Re: [sqlite] Bug in SQLite FLOAT values

On 7 Feb 2015, at 5:57am, Abdul Aziz wrote: > *again I converted back to float this string formatted value, and printed > into Log, I was clearly seeing values upto 6 decimal places , but after > insertion into sqlite db, when after generation of sqlite db file, was >

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

> Thanks. I've run the schema and query here with the desktop version of > SpatiaLite and it does not crash. I suspect the underlying issue may be > an alignment fault (or stack overflow) due to bad interaction between the > ARM processor architecture and the SpatiaLite extension. I'm not

Re: [sqlite] ordinary CTE containing sum()

On Sat, 7 Feb 2015 12:31:37 -0500 Doug Currie wrote: > In response to this SO question: > > http://stackoverflow.com/questions/28377210/how-to-retrieve-rank-based-on-total-mark-in-sqlite-table > > I tried to formulate a query without temp tables using an ordinary > CTE,

Re: [sqlite] sqlite give "database or disk full"

jitendar kumar wrote: > where is the temporary files location ?? 1. temp_directory, if set 2. SQLITE_TMPDR, if set 3. TMPDIR, if set 4. /var/tmp 5. /usr/tmp 6. /tmp Regards, Clemens ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Bug in SQLite FLOAT values

On Sat, 7 Feb 2015 11:27:59 +0530, Abdul Aziz wrote: > Hi there! > I hope you are well! > > Recently I was working on project based on Android Sensors and encountered > a bug in sqlite db, situation was this: > I was setting there three values x,y,z as FLOAT, android

Re: [sqlite] Bug in SQLite FLOAT values

Why would an application need to use the SQLite printf function to convert doubles to formatted text? The application ought to store and retrieve the raw doubles completely unadulterated (with no diddling, using the value_double and bind_double interfaces), and "format the value for display"

[sqlite] Interrupting custom collation processing

Hi, After setting a custom collator function with `sqlite3_create_collation`, is it possible to set or return an error value to indicate that the collating should stop immediately from within the callback function? Basically I'm looking at a bug in PHP using the SQLite extension when: * A user

Re: [sqlite] Interrupting custom collation processing

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/07/2015 05:55 PM, Dan Ackroyd wrote: > Due to the nature of PHP, it would be expected that the processing > of the collation should stop immediately. However I can't see how > to indicate to SQLite that an error has occurred, and so the >