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

[shum [Ming Yik]]

Hi D. Richard Hipp,

I'm not sure what it is you are doing wrong.  Are you
typing this in at the command-line shell?  Or are you
using some kind of language binding?

I am using Sqlitecc
http://bobmanc.home.comcast.net/sqlitecc.html

And Klint Gore, Show me it is Slqitecc 's bug

Now Sqlite works fine for me ...

Thanks for your attention !

Shum




----- Original Message ----- 
From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, January 30, 2006 8:28 PM
Subject: 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 ;



then you will find that in test01:
001
002

then you will find that in test02:
001
002
001
002


That's not what I get:

 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 ; 
 select 111, * from test01;
 111|001
 111|002
 select 222, * from test02;
 222|001
 222|002

I'm not sure what it is you are doing wrong.  Are you
typing this in at the command-line shell?  Or are you
using some kind of language binding?
--
D. Richard Hipp   <[EMAIL PROTECTED]>