Re: [sqlite] Upcoming Conferences

2005-10-11 Thread Jolan Luff
On Wed, Oct 12, 2005 at 01:19:24PM +1000, Klint Gore wrote: > > How about "Sidney" then? We're offended too! :) > > It can't be any worse than what's his name anouncing the sydney > olympics. > > At $600, I don't think I'll be attending the tutorial no matter how > Sydney is spelt. > http://www.a

Re: [sqlite] Version 3.2.6

2005-09-17 Thread Jolan Luff
On Sat, Sep 17, 2005 at 03:41:21PM -0400, D. Richard Hipp wrote: > Version 3.2.6 is now available on the website 3.2.6 does not compile on FreeBSD and OpenBSD because they do not have fdatasync(). AFAICT, NetBSD's fdatasync implementation does the same thing as fsync.

Re: [sqlite] Please test prior to version 3.1.5. Was: Delete crashes with Version 3.2.4 in Windows XP

2005-08-25 Thread Jolan Luff
On Wed, Aug 24, 2005 at 10:08:21AM -1000, Glen Nakamura wrote: > On Wed, Aug 24, 2005 at 02:50:04PM -0500, Jolan Luff wrote: > > OpenBSD/amd64 with gcc 3.3.5. I noticed that with 3.2.2 it was possible > > to run "make test" without having done "make" first and

Re: [sqlite] Please test prior to version 3.1.5. Was: Delete crashes with Version 3.2.4 in Windows XP

2005-08-24 Thread Jolan Luff
On Wed, Aug 24, 2005 at 02:23:22PM -0400, D. Richard Hipp wrote: > On Wed, 2005-08-24 at 13:08 -0500, Jolan Luff wrote: > > I am trying to test this in my environment but it looks like the > > build scripts were subtly broken as I can no longer run 'make test': > >

Re: [sqlite] Please test prior to version 3.1.5. Was: Delete crashes with Version 3.2.4 in Windows XP

2005-08-24 Thread Jolan Luff
On Wed, Aug 24, 2005 at 12:58:46PM -0400, D. Richard Hipp wrote: > A bug introduced into the CVS tree on July 8 was causing > malfunctions and segfaults when you attempt to DELETE or > UPDATE more than 40960 rows in a single statement. This > bug has now been fixed and a test case has been added t

Re: [sqlite] Did OSCON tutorial get accepted for AUUG in oct?

2005-08-09 Thread Jolan Luff
On Wed, Aug 10, 2005 at 12:35:27PM +1000, Klint Gore wrote: > Anyone know if the OSCON tutorial was accepted for AUUG2005? afaik it was but dr. hipp will not be the one giving it.

Re: [sqlite] sqlite server

2005-06-15 Thread Jolan Luff
On Wed, Jun 15, 2005 at 10:47:00AM -0700, [EMAIL PROTECTED] wrote: > It would be nice to have a little server and client library which provided > access to sqlite databases. I wrote one for the purpose of serving > databases, and left the interface open so it could easily be used for > serving sql

[sqlite] Re: sqlite 3.2.1 lock-2.8 test hangs

2005-04-28 Thread Jolan Luff
On Wed, Apr 27, 2005 at 04:55:00PM -0500, Jolan Luff wrote: > hi, > > when running the sqlite 3.2.1 regression tests, the lock-2.8 test hangs > indefinitely. if i disable that test, all others pass. > > is this a bug in the regression test or is this something i should be

[sqlite] sqlite 3.2.1 lock-2.8 test hangs

2005-04-27 Thread Jolan Luff
hi, when running the sqlite 3.2.1 regression tests, the lock-2.8 test hangs indefinitely. if i disable that test, all others pass. is this a bug in the regression test or is this something i should be concerned about? thanks, - jolan

Re: [sqlite] Syntax Error For 3.0.8 --> 3.2.1 Upgrade

2005-04-21 Thread Jolan Luff
On Thu, Apr 21, 2005 at 12:07:24PM -0500, William Hachfeld wrote: > I've recently tried to upgrade from SQLite 3.0.8 to 3.2.1 and have run into a > snag. This is probably something REAL simple that I'm just not seeing. I'm > hoping someone can point out my stupid mistake... > > When I rebuild our

Re: [sqlite] time for timer...

2005-03-25 Thread Jolan Luff
On Fri, Mar 25, 2005 at 04:48:47PM -0800, Jay wrote: > SQLite version 3.1.2 > Enter ".help" for instructions > sqlite> select datetime('now'); > 2005-03-26 00:44:37 > sqlite> .quit > zenobia # date > Fri Mar 25 18:44:48 CST 2005 > zenobia # > > Is this because I don't have the timezone set? selec

Re: [sqlite] Versions 2.8.16 and 3.1.2

2005-02-17 Thread Jolan Luff
On Tue, Feb 15, 2005 at 08:23:59AM -0500, D. Richard Hipp wrote: > Version 3.1.2 is also (by coincidence) the first stable release > of the 3.1 line. SQLite 3.1 adds support for correlated subqueries, > autovacuum, autoincrement, ALTER TABLE, and other features. > > Please let me know if you find

Re: [sqlite] Versions 2.8.16 and 3.1.2

2005-02-15 Thread Jolan Luff
On Tue, Feb 15, 2005 at 08:23:59AM -0500, D. Richard Hipp wrote: > Version 3.1.2 is also (by coincidence) the first stable release > of the 3.1 line. SQLite 3.1 adds support for correlated subqueries, > autovacuum, autoincrement, ALTER TABLE, and other features. > > Please let me know if you find

[sqlite] regression test failure with 2.8.15

2005-01-13 Thread Jolan Luff
hi, i was updating sqlite 2.8.14 -> 2.8.15 and now I get this single regression failure: tcl-2.2... Error: can't read "result(*)": variable isn't array Is this an actual problem or is this a bug in the test itself?

Re: [sqlite] bug in btree code 3.0.8

2005-01-07 Thread Jolan Luff
On Fri, Jan 07, 2005 at 12:59:51AM -0800, Daniel K wrote: > > sql below (it's fairly long). We're using FreeBSD > > 4.10 with gcc version > > 2.95.4 20020320 [FreeBSD]. > > > http://www.openbsd.org/cgi-bin/cvsweb/~checkout~/src/lib/libc/stdlib/malloc.c?rev=1.70 > > > Adding the assertion that pCe

Re: [sqlite] bug in btree code 3.0.8

2005-01-06 Thread Jolan Luff
On Thu, Jan 06, 2005 at 12:25:18PM -0800, Ted Unangst wrote: > D. Richard Hipp wrote: > >> > > > >Provice specific SQL that causes a problem. The same btree code > >has been in use for ages and there are many tests that do what > >you describe above. You are the first person to ever see this > >p

Re: [sqlite] Are there any plans to support cursors?

2004-12-29 Thread Jolan Luff
On Wed, Dec 29, 2004 at 11:32:50PM -0500, D. Richard Hipp wrote: > The beginnings of support for SQL92 cursor syntax > (DECLARE CURSOR foo AS SELECT ) is currently in the > CVS tree. But it is disabled by default because it is > incomplete and does not work. > > You are welcomed to work on it

Re: [sqlite] php4/sqlite - sqlite_escape_string doesn't function

2004-12-24 Thread Jolan Luff
On Sat, Dec 25, 2004 at 12:18:50AM -0500, Peter Jay Salzman wrote: > This piece of code kept giving error messages that looked like some of my > VALUES were getting parsed by php: > > > sqlite_query( $handle, " > INSERT INTO course VALUES ( > sqli

Re: [sqlite] sqlite/php - Having trouble getting started

2004-12-24 Thread Jolan Luff
On Fri, Dec 24, 2004 at 09:37:10PM -0500, Peter Jay Salzman wrote: > I taught myself Perl DBI/sqlite yesterday. Very cool. Today I decided to > play with sqlite using PHP. Unfortuantely, I'm not having much success with > the PHP implementation. the code you pasted was for php5, not the php4 bo

Re: [sqlite] Sequences In SQLite

2004-12-08 Thread Jolan Luff
On Wed, Dec 08, 2004 at 04:40:02PM -0500, Jeff Flowers wrote: > Is there anything like serial sequences in SQLite? What I want to do is > have a primary interger key that auto-increments as records are added to > a table. does the first entry in the faq on the website not do what you want?