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]>