Re: [sqlite] sqlite on freertos/fatfs : SQLITE_NOTADB during create table

2018-07-28 Thread Dan Kennedy
On 07/28/2018 10:51 PM, Bram Peeters wrote: Ah maybe that is also interesting to know: i put a breakpoint on the write convenience wrapper in sqlite, it is never called. So it is not that there is a problem with the write function . It is that there is never an attempt to write anything to the

Re: [sqlite] sqlite on freertos/fatfs : SQLITE_NOTADB during create table

2018-07-28 Thread Bram Peeters
Ah maybe that is also interesting to know: i put a breakpoint on the write convenience wrapper in sqlite, it is never called. So it is not that there is a problem with the write function . It is that there is never an attempt to write anything to the file before it is being read... Which is why

Re: [sqlite] sqlite on freertos/fatfs : SQLITE_NOTADB during create table

2018-07-28 Thread Bram Peeters
>An empty file and a file filled with zeros are two different things The file is empty/has size 0 in the file system. So the filesystem interface indeed returns SQLITE_IOERR_SHORT_READ. But the page1 pointer (this is not in the file, but in the structures managed by sqlite) points to a buffer

Re: [sqlite] sqlite on freertos/fatfs : SQLITE_NOTADB during create table

2018-07-28 Thread Clemens Ladisch
Bram Peeters wrote: > He reads a page from the file in sqlite3PagerSharedLock, but the file is > still 0 so the page is all zeros. An empty file and a file filled with zeros are two different things. Does the file system return SQLITE_IOERR_SHORT_READ? Regards, Clemens

Re: [sqlite] Backup and integrity check questions

2018-07-28 Thread Rune Torgersen
> Rowan Worth Thu, 26 Jul 2018 22:02:50 -0700 > > On 26 July 2018 at 05:56, Rune Torgersen wrote: > > > The databases have been opened with two connections (one for reads, one > > for writes), and use the following options: > > sqlite3_busy_timeout(mDbConn, 500); > > sqlite3_exec(mDbConn,

Re: [sqlite] Create VIEW passing despite invalid column name specified

2018-07-28 Thread Will Parsons
On Thursday, 26 Jul 2018 7:58 PM -0400, Richard Hipp wrote: > On 7/26/18, Tomasz Kot wrote: >> Hello, >> >> Beneath sql shall throw an error on CREATE VIEW statement (as invalid >> column is specified), but it passes (SQLite 3.23.1). > > The error is deferred until you try to use the view. The

[sqlite] sqlite on freertos/fatfs : SQLITE_NOTADB during create table

2018-07-28 Thread Bram Peeters
Hi, I am trying to get sqlite working on a freertos/fatfs based STM32 embedded system. I started from the 3.24.0 amalgamation an did the steps in https://www.sqlite.org/custombuild.html. The VFS is based on the https://www.sqlite.org/src/doc/trunk/src/test_demovfs.c code (though I did