Hi Darren Duncan,
you said "insert contents of your_table into your_table"
No,
insert into table01 select * from table02
the structure of table01 and table02 are same,
Table01 and table02 are different table within same structure,
No such bug within MSSQL or mySQL or PostgreSQL !
Only in Sqlite (Ihave test sqlite 3.X) ...
This bug is easy to find out ...
Shum
----- Original Message -----
From: "Darren Duncan" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Sunday, January 29, 2006 4:13 PM
Subject: Re: [sqlite] Bug in insert into ... select * ....
At 3:32 PM +0800 1/29/06, shum [Ming Yik] wrote:
Hi Sqlite Team,
insert into disk.your_table select * from your_table;
There is an bugwithin insert into table01 select * from table02
Always double the inserted rows in table01 ...
where the structure of table01 and table02 are the same ....
I use Sqlite 3.3.2b
Your example code did not indicate that you were using 2 different
tables; you said "insert contents of your_table into your_table",
which would of course result in a doubling up. You need to use
different table names. Or if you have 2 database files having the
same named table, you need to say foo.your_table and bar.your_table;
leaving the prefix off one is ambiguous, so it could choose the one
in 'disk'. Try fixing your SQL and see if it works then. -- Darren
Duncan