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

Reply via email to