Hi D. Richard Hipp
I use the Sqlitecc to show it out
http://bobmanc.home.comcast.net/sqlitecc.html
If the bug is so easy to find out, perhaps you could give
us an example. I am unable to reproduce it.
Here is the example:
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 ;
then you will find that in test01:
001
002
then you will find that in test02:
001
002
001
002
No such bug within MSSQL or mySQL 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 into ... select * ....
"shum [Ming Yik]" <[EMAIL PROTECTED]> wrote:
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 ...
If the bug is so easy to find out, perhaps you could give
us an example. I am unable to reproduce it.
--
D. Richard Hipp <[EMAIL PROTECTED]>
