Re: [sqlite] ORDER BY and LIMIT regression

> On 1/19/15, Angelo Mottola converge.it<http://converge.it>> > wrote: >> Hello, >> >> I have a regression to report, that seems to have been introduced between >> SQLite 3.8.6 and the newest 3.8.8 (at least our test case worked in 3.8.6 >> and

[sqlite] ORDER BY and LIMIT regression

zipped and 110 MB unzipped file, so be warned. I’m sorry I can’t give a smaller test case; I hope it can be useful in discovering what’s going wrong anyway. Thanks -- Ing. Angelo Mottola Software architect Converge SpA a.mott...@converge.it<mailto:a.mott...@converge

Re: [sqlite] Prepare SQL for Read-Only Database with Journal File

: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Friday, February 17, 2012 2:59 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Prepare SQL for Read-Only Database with Journal File On Fri, Feb 17, 2012 at 2:45 PM, Angelo

[sqlite] Prepare SQL for Read-Only Database with Journal File

All, I am using SQLite version 3.7.8. I am receiving the SQLITE_IOERR result code from sqlite3_prepare_v2 function when attempting to compile a PRAGMA statement on a read-only database where a rollback journal file also exists. Is it possible to force SQLite to ignore rollback journal files

Re: [sqlite] undefined reference to `readline'

=> re-run configure and still problems complaining it was not able to find tgetnum, tgoto togetflags and so on => downloaded ncurses.tar.gz (vers 5.7) and installed => re-run configure and no complaint, => make and make install and now history works quite fine Happy new year t

[sqlite] undefined reference to `readline'

exit status. So it's clear, the linker does not find the readline function , but I don't understand why. Any idea ? Thanks to everybody Angelo ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

[sqlite] pragma database_list

Pavel and Jay, I did as you suggested and it works perfectly. THANK YOU VERY MUCH for the usefull help ! Bye Angelo ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Help speeding up very slow query

s I have a lot to learn still. I appreciate the quick response. Thank you. Angelo

[sqlite] Help speeding up very slow query

how can I modify the second query to do what I am looking for. Thanks, Angelo