shum [Ming Yik] wrote:
> 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
It works properly for me, using the precompiled binary for windows under
cygwin:
$ sqlite3
SQLite version 3.3.2
Enter ".help" for instructions
sqlite> create table test01( FLD01 char(3) default '');
sqlite> create table test02( FLD01 char(3) default '');
sqlite>
sqlite> insert into test01(FLD01) values('001');
sqlite> insert into test01(FLD01) values('002');
sqlite> select * from test01;
001
002
sqlite> insert into test02 select * from test01 ;
sqlite> select * from test02;
001
002
sqlite>
