Re: [sqlite] Truncation of floating point numbers in SQLite?

On 2015/01/29 05:05, James K. Lowden wrote: There's no reason to think, if the data are provided in binary form, that they won't be returned in the identical form absent an explicit conversion. If that's not so, I'd sure like to know why. I'm faintly surprised NaNs can't be stored, too. Why

Re: [sqlite] Truncation of floating point numbers in SQLite?

>I wonder what happens if you put SQLite on a computer with no native IEEE >maths library. Same as compiling with SQLITE_OMIT_FLOATING_POINT on a computer/compiler that *does* have floating point I should imagine -- you end up with a version of SQLite with all floating point omitted. ---

[sqlite] Questions about SQLITE_CONFIG_SCRATCH and SQLITE_CONFIG_PAGECACHE

Hi 1) Question about SQLITE_CONFIG_SCRATCH In SQLite documentation about SQLITE_CONFIG_SCRATCH, I read: === BEGIN QUOTE https://sqlite.org/c3ref/c_config_getmalloc.html === SQLite will never require a scratch buffer that is more than 6 times the database page size. If SQLite needs needs

Re: [sqlite] "database disk image is malformed" error occurs more

My application does not phone home :-/ but I can add output of these functions to the log file my application maintains. My users know how to collect these log files and send them to me. I will also add the error logging callback to my wrapper class and route it to the log file. This

Re: [sqlite] "database disk image is malformed" error occurs more

The diagnosis log of my application reports the output of integrity_check() already. I retrieved the log from the most recent error report. This is my application has logged: '*** IN DATABASE MAIN *** ON TREE PAGE 385120 CELL 24: INVALID PAGE NUMBER 151192068 CORRUPTION DETECTED IN

[sqlite] Best Practice for read-only access

Howdy! I've got an object that encapsulates access to an SQLite database, i.e., all writes to the database are done in terms of method calls to the object. However, I want to give the application read-only access to the database for queries. There are two obvious ways to do this: 1. I can

Re: [sqlite] "database disk image is malformed" error occurs more

The core code is in place since about 2008. I took advantage of changes in SQLite over time, from using the shared cache to switching to WAL mode for databases which are not opened in read-only mode. These changes were made between 12 and six months ago, and tested during beta tests and

[sqlite] Partial indexes not working for me

Hello, I tried really hard to get partial indexes working, but SQLite refuses to use them: > create table "t" ("id" INTEGER NOT NULL PRIMARY KEY, "flags" INTEGER, "uniqueId", "syncFolder" INTEGER); > create index "i1" on "t" ("id") where "uniqueId" IS NULL; > explain query plan select * from "t"

Re: [sqlite] Partial indexes not working for me

On 1/29/15, Filip Navara wrote: > Hello, > > I tried really hard to get partial indexes working, but SQLite refuses to > use them: > >> create table "t" ("id" INTEGER NOT NULL PRIMARY KEY, "flags" INTEGER, > "uniqueId", "syncFolder" INTEGER); >> create index "i1" on "t"

Re: [sqlite] Partial indexes not working for me

Actually running ANALYZE didn't seem to help. There are other partial indexes I tried and none of them were used: sqlite> create index "i2" on "t" ("id") where "flags" & 1; sqlite> explain query plan select * from "t" where "flags" & 1; 0|0|0|SCAN TABLE t sqlite> create index "i3" on "t" ("id")

Re: [sqlite] "database disk image is malformed" error occurs more

On Thu, Jan 29, 2015 at 2:07 PM, Mario M. Westphal wrote: > Most database damaged errors encountered over time could be pinned to > power failures, disk or *network problems*. > > Network problems? I might have missed a good chunk of this thread, but, this begs to be

Re: [sqlite] "database disk image is malformed" error occurs more

On 29 Jan 2015, at 7:04pm, Mario M. Westphal wrote: > The diagnosis log of my application reports the output of integrity_check() > already. > > I retrieved the log from the most recent error report. This is my application > has logged: > > '*** IN DATABASE MAIN *** > ON

Re: [sqlite] Best Practice for read-only access

On 1/29/15, Duquette, William H (393K) wrote: > Howdy! > > I've got an object that encapsulates access to an SQLite database, i.e., all > writes to the database are done in terms of method calls to the object. > However, I want to give the application read-only

Re: [sqlite] Truncation of floating point numbers in SQLite?

I'm still not convinced whether it's the behaviour causing my problem, but it does look like negative zero is another special case: SQLite version 3.8.7.2 2014-11-18 20:57:56 Enter ".help" for usage hints. sqlite> create table datatable2 (doublevalue real); sqlite> insert into datatable2

Re: [sqlite] Truncation of floating point numbers in SQLite?

On 1/29/15, Donald Shepherd wrote: > I'm still not convinced whether it's the behaviour causing my problem, but > it does look like negative zero is another special case: > > SQLite version 3.8.7.2 2014-11-18 20:57:56 > Enter ".help" for usage hints. > sqlite> create

Re: [sqlite] Truncation of floating point numbers in SQLite?

Trying to retrieve a stored qNaN or sNaN returns a column type of NULL and a value of 0. On Thu Jan 29 2015 at 8:56:35 PM RSmith wrote: > > On 2015/01/29 05:05, James K. Lowden wrote: > > There's no reason to think, if the data are provided in binary form, > that they won't

[sqlite] Partial indexes not working for me

Filip, I don't suppose it would fit your needs to index on the column you're comparing rather than on "id" would it? That would cause the query planner to use your indexes, I believe. create index "i1" on "t" (uniqueID) where UniqueId ==55; Alternatively, you can create an