[sqlite] order by not working in combination with random()

2015-09-01 Thread Scott Robison
On Sat, Aug 29, 2015 at 4:16 AM, Yahoo! Mail wrote: > On 08/28/2015 09:36 PM, Scott Robison wrote: > >> On Fri, Aug 28, 2015 at 3:47 AM, Yahoo! Mail < >> stefanossofroniou542 at yahoo.com >> >>> wrote: >>> >>> On 08/26/2015 09:03 PM, Richard Hipp wrote: >>> >>> Time stands still for multiple rows

[sqlite] AVL tree implementation in closure module

2015-09-01 Thread Sairam Gaddam
Deep inside SQLite source files, there is a module called closure.c for computing transitive closure and it is provided as an extension. Inside, it uses an AVL tree implementation, so why to use that kind of implementation(or importance) for computing transitive closure in this case? And when is

[sqlite] Sqlite3.exe CLP features through sqlite3.dll

2015-09-01 Thread jose.campos.rom...@andaluciajunta.es
"Sqlite3.exe CLP features: .dump, .schema, .read, .output, etc." Hi. One more question, please. Perhaps there sqlite3.dll functions to produce the same result of the characteristics of sqlite3.exe?. Thanks in advance.

[sqlite] Sqlite3.exe CLP features through sqlite3.dll

2015-09-01 Thread Simon Slavin
On 1 Sep 2015, at 1:05pm, jose.campos.romero at andaluciajunta.es wrote: > Perhaps there sqlite3.dll functions to produce the same result of the > characteristics of sqlite3.exe?. No. These facilities are not part of SQLite. There are no facilities in SQLite which can make them happen. You m

[sqlite] ESC_BAD_ACCESS when using a background thread

2015-09-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/31/2015 11:28 PM, Jeff M wrote: > All my bad -- I'm fessing up. Can you tell us how you found the root causes of the problems? It would be nice to know what tools and techniques worked. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v2 i

[sqlite] journal files not always removed

2015-09-01 Thread J Decker
On Sat, Aug 15, 2015 at 1:59 PM, Richard Hipp wrote: > On 8/15/15, Ashwin Hirschi wrote: >> >>> But I also see that behavior dates back to 3.7.6 and maybe earlier. It >>> isn't something new. >>> (Testing on Ubuntu). >> >> Also, are you sure you testing things right? I thought URI support was >>

[sqlite] ESC_BAD_ACCESS when using a background thread

2015-09-01 Thread Jeff M
I'm the OP, just closing the loop on this thread. I solved the crashing and the memory allocation issues. The crashing was due to NSMutableDictionary not being thread safe (can't do setObject:forKey on a background thread). The memory allocation issue (memory kept increasing) was due to a pro