Re: [sqlite] Bug in insert into ... select * ....

"shum [Ming Yik]" <[EMAIL PROTECTED]> wrote: > > create table test01( FLD01 char(3) default ''); > create table test02( FLD01 char(3) default ''); > > insert into test01(FLD01) values('001'); > insert into test01(FLD01) values('002'); > > insert into test02 select * from test01 ; > > > >

Re: [sqlite] Bug in insert into ... select * ....

or PostgreSQL ! the rows test02 in MSSQL, mySQL, PostgreSQL are: 001 002 - Shum www.mingyik.com - Original Message - From: <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, January 30, 2006 2:53 AM Subject: Re: [sqlite] Bug in insert int

Re: [sqlite] Bug in insert into ... select * ....

QL ! 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

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

[sqlite] Bug in insert into ... select * ....

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 Shum www.mingyik.com