Re: [sqlite] Re: segfaults on aggregate functions in where clause?

On Fri, Dec 02, 2005 at 11:24:10PM -0500, Igor Tandetnik wrote: > It is indeed an illegal SQL query. You probably want > > select id from test > group by id > having avg(rating) > 10; I hadn't realized that my query was actually illegal. OK. > >The workaround of putting the aggregate in a

[sqlite] Re: segfaults on aggregate functions in where clause?

Nathan Kurz <[EMAIL PROTECTED]> wrote: I was just about to file a bug about a segfault when I have an aggregate in the where clause like: select id from test where avg(rating) > 10 group by id; But when I looked in the bug reports, I found that several similar bugs had been reported and that

[sqlite] segfaults on aggregate functions in where clause?

I was just about to file a bug about a segfault when I have an aggregate in the where clause like: select id from test where avg(rating) > 10 group by id; But when I looked in the bug reports, I found that several similar bugs had been reported and that the problem had been 'fixed':

Re: [sqlite] sluggish performance in MacOS 10.4

On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > The added risk in going from synchronous=FULL to synchronous=NORMAL > is minimal. You only run into trouble [when] you select > synchronous=OFF. you've piqued my interest... Does sqlite implement MVCC (multiversion concurrency)? -cc

Re: [sqlite] sluggish performance in MacOS 10.4

Eric Scouten <[EMAIL PROTECTED]> wrote: > Doesn't that bring with it an increased risk of file corruption? > The added risk in going from synchronous=FULL to synchronous=NORMAL is minimal. You only run into trouble with you select synchronous=OFF. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] sluggish performance in MacOS 10.4

Doesn't that bring with it an increased risk of file corruption? -Eric ozemail (pcferrett) wrote: Hi Richard Yes, a call to pragma synchronous = normal has resolved this problem. Speed is back to normal. Thank you very much. regards Peter On 03/12/2005, at 12:06 AM, [EMAIL

Re: [sqlite] sluggish performance in MacOS 10.4

Hi Richard Yes, a call to pragma synchronous = normal has resolved this problem. Speed is back to normal. Thank you very much. regards Peter On 03/12/2005, at 12:06 AM, [EMAIL PROTECTED] wrote: ozemail (pcferrett) <[EMAIL PROTECTED]> wrote: oops, spoke too soon. I now have two

Re: [sqlite] Odd query optimization

> Anyone have any thoughts ... ? You've already figured it out. For more info, see . Regards

Re: [sqlite] problem with blobs (perl code)

On 2 Dec 2005, at 08:07, [EMAIL PROTECTED] wrote: Would sqlite3_column_bytes() return the right length there rather than me doing strlen() on the resulting data? yes it will. Doh! In that case then 1.11 will head to CPAN with blobs working transparently.

[sqlite] Odd query optimization

OK, little puzzled by this one, wondering if my expectations of behavior are off. (Apologies for the longish post..) This is with 3.2.7. I have a reasonably simple 'users' table, with a single compound index (at first) on user last/first name: create table users ( id integer primary key,

Re: [sqlite]cross compiling with powerpc

Hi: I know that it is a silly question but...do you have the cross compiler installed? bye... - Original Message - From: "Julien LEFORT" <[EMAIL PROTECTED]> To: Sent: Friday, December 02, 2005 4:17 PM Subject: [sqlite]cross compiling with powerpc > Hi, >

Re: [sqlite]cross compiling with powerpc

Julien LEFORT wrote: Hi, I've been struggling for few hours trying to run the configure script the right way so I can cross compile sqlite3 for a powerpc target. I guess it is only a problem of options I pass into the configure script. here is the command I pass: CC=powerpc-linux-gcc

Re: [sqlite]cross compiling with powerpc

Julien LEFORT <[EMAIL PROTECTED]> wrote: > Hi, > I've been struggling for few hours trying to run the configure script the > right way so I can cross compile sqlite3 for a powerpc target. > > Anyone has any idea? Yes. Do not use the configure script to cross-compile. Instead make a copy of

[sqlite]cross compiling with powerpc

Hi, I've been struggling for few hours trying to run the configure script the right way so I can cross compile sqlite3 for a powerpc target. I guess it is only a problem of options I pass into the configure script. here is the command I pass: CC=powerpc-linux-gcc CXX=powerpc-linux-g++

[sqlite] testsuite errors

Hello, I have some trouble with the testsuite. Not all tests seem to pass, and 64-bit machines have a harder time than 32-bit. Also, it does not seem well supported to have the database in a network filesystem. Are my findings correct? Especially the conflict tests seems to fail on all

Re: [sqlite] problem with blobs (perl code)

Matt Sergeant <[EMAIL PROTECTED]> wrote: > On 1 Dec 2005, at 21:52, [EMAIL PROTECTED] wrote: > > > SQLite does has a separate BLOB type. But for TEXT types, SQLite > > still works like Perl and carries around a length so that the string > > can have embedded '\000' characters. I just added a

Re: [sqlite] sluggish performance in MacOS 10.4

ozemail (pcferrett) <[EMAIL PROTECTED]> wrote: > oops, spoke too soon. I now have two builds - one built using 10.2 > (PB) and the other built using 10.4 (Xcode). I reboot into system > 10.2, both builds work as expected. However, when booting into > system 10.4, both builds are sluggish

Re: [sqlite] problem with blobs (perl code)

On 1 Dec 2005, at 21:52, [EMAIL PROTECTED] wrote: SQLite does has a separate BLOB type. But for TEXT types, SQLite still works like Perl and carries around a length so that the string can have embedded '\000' characters. I just added a test to the test suite to verify that this works.

Re: [sqlite] problem with blobs (perl code)

Nathan Kurz <[EMAIL PROTECTED]> wrote: > > > So as far as I can tell, both SQLite and Perl are doing exactly what > > they ought to be. > > That certainly could be argued, although it does seem to trap the > unwary (like me) with fair regularity. One option for 'improving' it > might be to make

Re: [sqlite] sluggish performance in MacOS 10.4

Hi Dan I believe the same filesystem is used by both versions of the OS, although 10.4 has added "metadata" information that is used by the spotlight (search) tool. After some searching around I finally figured out how to login using the console (no other processes running). The

Re: [sqlite] sluggish performance in MacOS 10.4

Same filesystem used by both operating system versions? Output of 'top' or whatever the MacOS analogue is doesn't show any extra processes working as well as the sqlite program? Any supervisory frameworks like SE Linux or a win32 virus checker turned on in 10.4 that are not on in 10.2? ---