Re: [sqlite] Compiling on Xcode

Simon, Sorry for the long delay. I was trying to catch up on some other stuff. On Thu, Jul 14, 2016 at 10:01 AM, Igor Korot wrote: > On Thu, Jul 14, 2016 at 9:38 AM, Simon Slavin wrote: >> >> On 14 Jul 2016, at 12:44pm, Igor Korot

[sqlite] REFERENCES from TEMPORARY table to main database table?

Hi. I'm creating a specialized index table to a persistent table that I need to speed up a one-time operation. This seems like a great application for a TEMPORARY table in SQLite, so the index will always be reliably cleaned up. However, I can't find a way to have REFERENCES to the main table

Re: [sqlite] Typographical error in sqlite.org/howtocorrupt.html

Also fixed now. Thanks. On 7/22/16, Dominique Pellé wrote: > Hi > > I see another typo in the same page: > https://www.sqlite.org/howtocorrupt.html > > === BEGIN QUOTE === > 6.2 Failures of mmap() on QNX > > There exists some subtle problem with mmap() on QNX such

Re: [sqlite] Typographical error in sqlite.org/howtocorrupt.html

Hi I see another typo in the same page: https://www.sqlite.org/howtocorrupt.html === BEGIN QUOTE === 6.2 Failures of mmap() on QNX There exists some subtle problem with mmap() on QNX such that making a second mmap() call against *the a* single file descriptor can cause the memory [...] === END

Re: [sqlite] Typographical error in sqlite.org/howtocorrupt.html

Fix checked in by Joe. Thanks for reporting. On 7/20/16, Eubank, Tom wrote: > I believe that there is a typographical error on the following page: > > https://www.sqlite.org/howtocorrupt.html > > *7.4 Database pages leak from the free page list* > > When content

Re: [sqlite] [System.Data.SQLite.DLL] Retrieving table names with column names

On 2016/07/21 11:20 PM, Chris Locke wrote: I've a table I'm calling recursively. ... I know I can change my SQL statement to be explicit, and select each required field and use AS, but is that the only solution? It's not so much the "Only" way as it is the "Correct" way. Query planners