[sqlite] Some benchmarks

I was quite curious how SQLite stacked up against Firebird and Microsoft's brand-new Sql Mobile for Windows CE, so I ran some simple insert/iterate/update tests in C# using VS2005 beta 2 and the ADO.NET 2.0 data provider for SQLite. SQLite pretty much smoked them, and by smoked I mean "utter devas

[sqlite] DETACHing database after sqlite3_step, but before sqlite3_finalize causes crash in btree.c

Hi, Don't know yet if this is fixed in the latest version, but I thought I would bring it up anyway. We are using 3.2.2 library on windows. Open a database If you then attach another database - sqlite3_exec() Then step a select query, combining some info from tables from both database - sqlite

Re: [sqlite] Where are temporary tables/indices stored?

Of course!! Thanks Dennis :-) -- Tito On 01/09/2005, at 23:05, Dennis Cote wrote: Tito Ciuro wrote: If I execute a statement such as 'CREATE TEMP TABLE...' without specifying the database name, where is the SQL statement stored? I've tried using 'temp' as the database name, but it d

Re: [sqlite] Where are temporary tables/indices stored?

Tito Ciuro wrote: If I execute a statement such as 'CREATE TEMP TABLE...' without specifying the database name, where is the SQL statement stored? I've tried using 'temp' as the database name, but it doesn't return anything. Tito, The temp table information is stored in a second master

RE: [sqlite] Survey: NULLs and GROUP BY

D. Richard Hipp wrote: > I'm rewriting the aggregate function processing in SQLite > (so that it runs faster and uses less memory) and I want to > make sure I get it right. In particular, I want to make sure > that SQLite handles NULLs in GROUP BY values the same as > other database engines. > >

RE: [sqlite] How to retrieve sqlite version

SQLite version 3.2.5 Enter ".help" for instructions sqlite> select sqlite_version(*); sqlite_version(*) - 3.2.5 --Ned. http://nedbatchelder.com -Original Message- From: Dinsmore, Jeff [mailto:[EMAIL PROTECTED] Sent: Thursday, 01 September, 2005 1:56 PM To: sqlite-users@

Re: [sqlite] Survey: NULLs and GROUP BY

postgresql 8.0.1 on WinXP: a | b | sum ---+---+- 1 | 2 | 2 | 2 | 4 1 | | 8 | | 16 (4 rows) Martin I'm rewriting the aggregate function processing in SQLite (so that it runs faster and uses less memory) and I want to make sure I get it right. In particular, I want to make su

Re: [sqlite] Survey: NULLs and GROUP BY

On Thu, 2005-09-01 at 14:51 -0400, D. Richard Hipp wrote: > I'm rewriting the aggregate function processing in SQLite > (so that it runs faster and uses less memory) and I want to > make sure I get it right. In particular, I want to make > sure that SQLite handles NULLs in GROUP BY values the same

Re: [sqlite] Survey: NULLs and GROUP BY

Thanks everybody! All the results so far seem to be in agreement with each other and with the current behavior of SQLite. So I think everything is good. Thx for the help. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Survey: NULLs and GROUP BY

On Thu, 2005-09-01 at 14:51 -0400, D. Richard Hipp wrote: > I'm rewriting the aggregate function processing in SQLite > (so that it runs faster and uses less memory) and I want to > make sure I get it right. In particular, I want to make > sure that SQLite handles NULLs in GROUP BY values the same

Re: [sqlite] Survey: NULLs and GROUP BY

On 9/1/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: >CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER); >INSERT INTO t1 VALUES(1,2,1); >INSERT INTO t1 VALUES(NULL,2,2); >INSERT INTO t1 VALUES(1,NULL,4); >INSERT INTO t1 VALUES(NULL,NULL,8); >INSERT INTO t1 SELECT * FROM t1;

RE: [sqlite] Survey: NULLs and GROUP BY

Postgres 7.4: a | b | sum ---+---+- 1 | 2 | 2 | 2 | 4 1 | | 8 | | 16 DB2 8.2 A B 3 --- --- --- 1 2 2 - 2 4 1 - 8 -

Re: [sqlite] Survey: NULLs and GROUP BY

Postgresql 7.4.7 stats=>SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY 3; a | b | sum ---+---+- 1 | 2 | 2 | 2 | 4 1 | | 8 | | 16 (4 rows) Rgds, Mark. On Thu, 1 Sep 2005, D. Richard Hipp wrote: > I'm rewriting the aggregate function processing in SQLite > (so th

Re: [sqlite] Survey: NULLs and GROUP BY

SQL Server 2000: a b --- --- --- 1 2 2 NULL2 4 1 NULL8 NULLNULL16 - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Thursday, S

Re: [sqlite] Survey: NULLs and GROUP BY

>CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER); >INSERT INTO t1 VALUES(1,2,1); >INSERT INTO t1 VALUES(NULL,2,2); >INSERT INTO t1 VALUES(1,NULL,4); >INSERT INTO t1 VALUES(NULL,NULL,8); >INSERT INTO t1 SELECT * FROM t1; >SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER

Re: [sqlite] Survey: NULLs and GROUP BY

Oracle 9i: A B SUM(C) 1 2 2 [NULL] 2 4 1 [NULL] 8 [NULL] [NULL] 16 --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > I'm rewriting the aggregate function processing in > SQLite > (so that it runs faster and uses less memory) and I > want to > make sure I

Re: [sqlite] Survey: NULLs and GROUP BY

D. Richard Hipp wrote: I'm rewriting the aggregate function processing in SQLite (so that it runs faster and uses less memory) and I want to make sure I get it right. In particular, I want to make sure that SQLite handles NULLs in GROUP BY values the same as other database engines. Can I get so

Re: [sqlite] Survey: NULLs and GROUP BY

SQL Server 2005: a b --- --- --- 1 2 2 NULL 2 4 1NULL 8 NULLNULL 16 On 9/1/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > I'm rewriting the aggregate fu

RE: [sqlite] Survey: NULLs and GROUP BY

MySQL 4.1.1-NT +--+--++ | a| b| sum(c) | +--+--++ |1 |2 | 2 | | NULL |2 | 4 | |1 | NULL | 8 | | NULL | NULL | 16 | +--+--++ Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680

Re: [sqlite] Survey: NULLs and GROUP BY

MS Jet: a bExpr1002 1 22 NULL 24 1 NULL 8 NULL NULL 16 - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Thursday, September 01, 2005 11:51 AM Subject: [sqlite] Survey: NULLs and GROUP BY I'm rewriting the aggregate function

Re: [sqlite] Survey: NULLs and GROUP BY

On Thu, Sep 01, 2005 at 02:51:21PM -0400, D. Richard Hipp wrote: Oracle9i Enterprise Edition Release 9.2.0.4.0: SQL> SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY 3; A B SUM(C) -- -- -- 1 2 2 2 4 1 8 16 > Can I get some volunteers to run the

Re: [sqlite] Survey: NULLs and GROUP BY

D. Richard Hipp wrote: I'm rewriting the aggregate function processing in SQLite (so that it runs faster and uses less memory) and I want to make sure I get it right. In particular, I want to make sure that SQLite handles NULLs in GROUP BY values the same as other database engines. Can I get so

[sqlite] Survey: NULLs and GROUP BY

I'm rewriting the aggregate function processing in SQLite (so that it runs faster and uses less memory) and I want to make sure I get it right. In particular, I want to make sure that SQLite handles NULLs in GROUP BY values the same as other database engines. Can I get some volunteers to run the

Re: [sqlite] How to retrieve sqlite version

Hi Jeff, Just call sqlite3_libversion() Regards, -- Tito On 01/09/2005, at 19:55, Dinsmore, Jeff wrote: I can't seem to come up with how to get the version from sqlite. The frustrating thing is that I've done it before... As I recall, it's a select, but for the life of me, I can't rememb

[sqlite] How to retrieve sqlite version

I can't seem to come up with how to get the version from sqlite. The frustrating thing is that I've done it before... As I recall, it's a select, but for the life of me, I can't remember the right syntax. Anyone have that info handy? Thanks, Jeff Dinsmore MIS - Interfaces Ridgeview Medical Cen

Re: [sqlite] BUG? "order by" does not sort correctly

On Thu, 2005-09-01 at 13:04 -0400, Igor Tandetnik wrote: > SQLite 3.2.5, freshly downloaded Windows binaries. The bug appears to have been introduced in version 3.1.0. > -- now for the bug > select a.id, b.id, b.text from a join b on (a.id = b.aId) order by a.id, > b.text; > 1|1|zzz > 1|2

[sqlite] Where are temporary tables/indices stored?

Hello, Regarding the TEMP keyword, the documentation states: If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and "TABLE" then the table that is created is only visible within that same database connection and is automatically deleted when the database connection is closed.

[sqlite] BUG? "order by" does not sort correctly

SQLite 3.2.5, freshly downloaded Windows binaries. I start with an empty DB and execute the following commands in sqlite3 console: create table a (id integer primary key); create table b (id integer primary key, aId integer, text); insert into a values (1); insert into b values (1, 1, 'zzz');