[sqlite] Does single thread SQLite have bugs?

Hi When I ran "make test", some errors were shown. Is it meaning that SQLite has bugs? $ uname -a Linux localhost.localdomain 2.6.27-43vl5 #1 SMP Sat Aug 15 22:17:55 JST 2009 i686 i686 i386 GNU/Linux $ wget http://www.sqlite.org/sqlite-3.6.19.tar.gz $ tar zxf sqlite-3.6.19.tar.gz $ cd

Re: [sqlite] Infinity

Sorry, I think I gave you slightly buggy instructions. I just realized that max() should be the max true value capable of being stored, which should be less than the infinity value. std::numeric_limits provides another function named infinity() for getting positive infinity. I believe this value

Re: [sqlite] Using SQLite from Java

I wanted to find the right .jar files to get access. I'm working on an application that will read a bunch of csv files, using a special package that will allow them to be accessed as a database, then generate a SQLite database to be used elsewhere. I found a pointer to a driver for Java on Google

Re: [sqlite] Infinity

Thanks John. After incorporate a few changes, the code can compile and run. The result seems reasonable, the input infinity std::numeric_limits::max() is sent to and retrieved from a sqlite3 database correctly. --terminal output sqlite3 tempdb sqlite> select * from tl; 1.1 1.79769313486232e+308

Re: [sqlite] Using SQLite from Java

What information are you looking for? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of J. R. Westmoreland Sent: Monday, October 19, 2009 9:59 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Using SQLite

Re: [sqlite] Using SQLite from Java

Great, Thanks. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns Sent: Monday, October 19, 2009 7:42 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Using SQLite from Java -BEGIN PGP SIGNED

Re: [sqlite] Using SQLite from Java

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 J. R. Westmoreland wrote: > I looked on the site and didn't find anything. http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers :-) Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla -

Re: [sqlite] Using SQLite from Java

I looked on the site and didn't find anything. I didn't try Google. My bad. J. R. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns Sent: Monday, October 19, 2009 6:43 PM To: General Discussion of SQLite Database

Re: [sqlite] Using SQLite from Java

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 J. R. Westmoreland wrote: > Can someone point me to the information on using Java with SQLite? What was not useful in the Google search results you got? Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with

[sqlite] Using SQLite from Java

Can someone point me to the information on using Java with SQLite? Thanks, J. R. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Creating a spatial index for a large number of points-sorry for the text formating

8GB is workable. Make sure you use prepared statements to avoid recompiling you insert 500 million times. Also with this much data, it would probably be a very good idea to compile SQLite with a much larger memory cache. Don't expect a miracle either. 500 million is a very large number, any way

[sqlite] index for a group by

hello, I have a table T (a,b,c,d,t) where c is a value a,b,c some dimensions and t the time I need to make a subset with a "group by" like select a,b,c,sum(d) from T where t>x1 and thttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Infinity

You need #include . Other than that, I don't know. I code on Windows, not Mac, but the code looks right. WARNING: min() != -infinity. For doubles, min is the smallest number greater than 0. -infinity == -max() John -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Infinity

//Dear there, it seems that I cannot insert std::numeric_limits::max(). I am on Mac Osx 10.5 //anybody can take a look at the code? I am new to sqlite3. comments on coding also welcome. #include #include #include #include using namespace std; int main(){ double infinity =

Re: [sqlite] Ticket 3810: SQLITE_ERROR on concurrent CREATE TEMP TRIGGER and sqlite3_close()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave Toll wrote: > The race condition described in http://www.sqlite.org/cvstrac/tktview?tn=3810 > is > still present in SQLite 3.6.19 (amalgamation version running on Linux) My biggest problem with the ticket is the huge list of omits and other

[sqlite] Ticket 3810: SQLITE_ERROR on concurrent CREATE TEMP TRIGGER and sqlite3_close()

Hello list I'm posting here as my ticket was recently closed. The race condition described in http://www.sqlite.org/cvstrac/tktview?tn=3810 is still present in SQLite 3.6.19 (amalgamation version running on Linux) - the source code used to reproduce this issue has not changed and is still

Re: [sqlite] "x NATURAL JOIN x" BUG

On Mon, Oct 19, 2009 at 09:28:35PM +0200, Kristoffer Danielsson scratched on the wall: > > I'll investigate this bug later. I'm quite sure it's no more than a > couple of months old, Just tested in 3.4.0 (June 2007) and it does the exact same thing. -j -- Jay A. Kreibich < J A Y @ K

Re: [sqlite] "x NATURAL JOIN x" BUG

It makes sense. I'll investigate this bug later. I'm quite sure it's no more than a couple of months old, since I only got these crazy performance hits just after the summer (I upgrade regularly, but haven't tested my software thoroughly - until now :P). Thanks for your info. > Date:

Re: [sqlite] "x NATURAL JOIN x" BUG

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kristoffer Danielsson wrote: > When can we expect a bug fix? Days, weeks, months? Go to http://www.sqlite.org/src/reportlist and you can see all open tickets. (Currently there is no report in priority order). SQLite consortium members and paying

Re: [sqlite] Why FTS3 has the limitations it does

> Doing an fts index which can handle subset scans efficiently is going to be hard. I noticed. After some thought, here's what I've come up with: We'll call nT the number of terms and nD the number of docids in a given term. nTD is the number of rows in a natural join of terms and docids. The

Re: [sqlite] suggestions for avoiding "database locked" on ajax

Conclusion: onblur() is an error prone strategy. I am going to look into changing my approach that doesn't involve onblur(). I will research into busy_timeout() settings that might contribute to more reliability from the point of view of sqlite. Thanks you all who helped out. On Mon, Oct 19,

Re: [sqlite] suggestions for avoiding "database locked" on ajax

>But, if I enter something in the field, and, instead of tabbing out of >it, if I click on the submit button, two events fire simultaneously. >There is the onblur() from the field (this is a SELECT query), and the >submit from the form (this is an UPDATE/INSERT query). The events >reach sqlite

Re: [sqlite] suggestions for avoiding "database locked" on ajax

On Mon, Oct 19, 2009 at 12:13 PM, Keith Roberts wrote: > On Mon, 19 Oct 2009, P Kishor wrote: > >> To: General Discussion of SQLite Database >> From: P Kishor >> Subject: Re: [sqlite] suggestions for avoiding "database locked" on

Re: [sqlite] suggestions for avoiding "database locked" on ajax

On Mon, 19 Oct 2009, P Kishor wrote: To: General Discussion of SQLite Database From: P Kishor Subject: Re: [sqlite] suggestions for avoiding "database locked" on ajax Let me shed a bit more light on this (as I have understood). Top posting

Re: [sqlite] Why FTS3 has the limitations it does

On Sat, Oct 17, 2009 at 1:25 PM, John Crenshaw wrote: > Agreed, HUGE thanks for FTS. Hopefully my original post didn't > come off ungrateful. I was just confused by limitations that > looked like they could have been removed during the initial > design (at least more

Re: [sqlite] suggestions for avoiding "database locked" on ajax

Let me shed a bit more light on this (as I have understood). Top posting follows -- What is happening is that I have an onblur() action on a field which sends off a request to check the validity of the entered text. Then, of course, I have the submit button which also sends off the entire form to

Re: [sqlite] suggestions for avoiding "database locked" on ajax

While the idea of uniquely identifying a user is interesting, the assumption that there is only one user for each IP address is questionable at best - Consider assigning a 'session id' of some kind instead. In *theory* (and yes, I've seen it happen in reality) the source address can change

Re: [sqlite] Why FTS3 has the limitations it does

Here's a long-ago thread on this: http://www.mail-archive.com/sqlite-users@sqlite.org/msg30540.html Looks like it hasn't been addressed, and I've yet to come up for air on it. There's a ticket out there which looks like the same thing: http://www.sqlite.org/cvstrac/tktview?tn=3338 which is

Re: [sqlite] Why FTS3 has the limitations it does

Am 18.10.2009 um 18:55 schrieb Roger Binns: > Wanadoo Hartwig wrote: >> Slightly different question but related to FTS3. Does anybody know >> why >> this fails using FTS3? > > It isn't failing. Behind the scenes FTS3 is implemented using 3 other > tables (try .dump to see). You are indeed

[sqlite] BUG: The difference between working tclsqlite in tclsh shell and from tcl script - in 3.6.19 is reproduced too

Hello! See the test: $ cat /tmp/test package require sqlite3 sqlite3 db :memory: db eval {create table test(a int);insert into test values (1);} proc test {label sql result} { global i j puts -nonewline $label\t set _result [db eval $sql] if { $_result

Re: [sqlite] "x NATURAL JOIN x" BUG

On Sun, Oct 18, 2009 at 03:54:11PM -0700, Darren Duncan scratched on the wall: > Jay A. Kreibich wrote: > > On Sun, Oct 18, 2009 at 02:17:42PM +0200, Kristoffer Danielsson scratched > > on the wall: > >> Clearly, SQLite executes a cartesian product! > > > > Look at the output. It does not

Re: [sqlite] SQLite encription

I didn't think it did, I will search for this. Thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Rollback over pending queries

Hello, I wonder if an automatic rollback, as described in //www.sqlite.org/c3ref/busy_handler.html, is more powerful than a rollback programmed in SQL. Particularly if it is able to rollback pending queries from other cursors in the same connection. The programmed rollback fails here with

Re: [sqlite] SQLite encription

On Oct 19, 2009, at 9:49 AM, Francisc Romano wrote: > Hmm, well the thing is I am building an app that runs on Adobe AIR > which has > native support for SQLite. > > I am looking for an internal solution. Like setting a user > auth for > the SQLite database file to allow/deny acces? I

[sqlite] Rollback over pending queries

Hello, I wonder if an automatic rollback, as described in //www.sqlite.org/c3ref/busy_handler.html, is more powerful than a rollback programmed in SQL. Particularly if it is able to rollback pending queries from other cursors in the same connection. The programmed rollback fails here with

Re: [sqlite] SQLite encription

Hmm, well the thing is I am building an app that runs on Adobe AIR which has native support for SQLite. Involving third-party software would probably involve having to install it on the computers of various users of the application which would complicate things a bit too much. I am looking for an

Re: [sqlite] SQLite encription

One can use a 3rd party tool such as a Alladdin HASP key. This encrypts the application, and optionally the database file too. The drivers for the program won't execute a program if it detects a debugger. This solution is of course limited to operating systems with the available drivers. Once

Re: [sqlite] sqlite in-memory database far too slow in my use case

> Currently this means adding > the new columns to my C-structures, writing access functions, and > recompiling. I don't want to do that, because this means my appl *must* > be replaced on every database change, and I'd like to be able to > run different versions of it in the wild. I was hoping to

Re: [sqlite] Hi, new member here (and also my first question)

> Any idea to trace this bug? Anything would be appreciated because I don't > have a clue whatsoever. Thanks. To have any idea on our side we should see your code and better a stacktrace of the crash too. Pavel On Sun, Oct 18, 2009 at 11:34 PM, wrote: > Sorry for the long

Re: [sqlite] "x NATURAL JOIN x" BUG

Hi, Great to hear. I was starting to think my code was damaged. Anyway, please beware of cases such as this: SELECT * FROM X NATURAL JOIN (X NATURAL JOIN Y); This yields the same error. Probably the same bug, but you never know. When can we expect a bug fix? Days, weeks, months?

Re: [sqlite] searching sqlite tickets?

Jens Miltner wrote: > it's still a bit annoying, since I > can't search for existing reports efficiently You are preaching to the choir :-) You can create a bug report about this at http://www.fossil-scm.org (Fossil is being used by SQLite). You can also run fossil yourself and clone the

Re: [sqlite] searching sqlite tickets?

Am 19.10.2009 um 09:47 schrieb Dan Kennedy: > > On Oct 19, 2009, at 2:36 PM, Jens Miltner wrote: > >> Before the timeline was migrated to fossil, I was able to search for >> tickets. >> In the current sqlite.org website, I can no longer search for tickets >> - I can only show all tickets, all

Re: [sqlite] searching sqlite tickets?

Am 19.10.2009 um 09:47 schrieb Dan Kennedy: > > On Oct 19, 2009, at 2:36 PM, Jens Miltner wrote: > >> Before the timeline was migrated to fossil, I was able to search for >> tickets. >> In the current sqlite.org website, I can no longer search for tickets >> - I can only show all tickets, all

Re: [sqlite] searching sqlite tickets?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jens Miltner wrote: > In the current sqlite.org website, I can no longer search for tickets > - I can only show all tickets, all closed tickets or all open tickets, > but I can't search for keywords any more... Yes I whined to DRH about that too.

Re: [sqlite] searching sqlite tickets?

On Oct 19, 2009, at 2:36 PM, Jens Miltner wrote: > Before the timeline was migrated to fossil, I was able to search for > tickets. > In the current sqlite.org website, I can no longer search for tickets > - I can only show all tickets, all closed tickets or all open tickets, > but I can't search

Re: [sqlite] "x NATURAL JOIN x" BUG

On Oct 19, 2009, at 2:05 PM, Kristoffer Danielsson wrote: > > I did provide a sample with test data in my original post. However, > I posted it here too: > > http://www.sqlite.org/cvstrac/tktview?tn=4043 > > > > The tracker is obviously closed, but still, there it is :P. Don't > know where

[sqlite] searching sqlite tickets?

Before the timeline was migrated to fossil, I was able to search for tickets. In the current sqlite.org website, I can no longer search for tickets - I can only show all tickets, all closed tickets or all open tickets, but I can't search for keywords any more... Is there still a way to

Re: [sqlite] "x NATURAL JOIN x" BUG

I did provide a sample with test data in my original post. However, I posted it here too: http://www.sqlite.org/cvstrac/tktview?tn=4043 The tracker is obviously closed, but still, there it is :P. Don't know where else to post it. /Chris > Date: Sun, 18 Oct 2009 16:25:48 -0700 > From: