Thread
-
Bug
Oleg Broytmann <phd@sun.med.ru> — 1999-09-17T10:38:45Z
---------- Forwarded message ---------- Date: Fri, 17 Sep 1999 17:52:44 +0400 (MSD) From: Artem Chuprina <ran@pirit.com> ran=> create table test_source (src text); CREATE ran=> insert into test_source values('First distinct'); INSERT 235913 1 ran=> insert into test_source values('First distinct'); INSERT 235914 1 ran=> insert into test_source values('Second distinct'); INSERT 235915 1 ran=> insert into test_source values('Second distinct'); INSERT 235916 1 ran=> select src from test_source; src --------------- First distinct First distinct Second distinct Second distinct (4 rows) ran=> select distinct src from test_source; src --------------- First distinct Second distinct (2 rows) ran=> create sequence seq_test; CREATE ran=> create table test1 (n int default nextval('seq_test'), t text); CREATE ran=> create table test2 (n int, t text); CREATE ran=> insert into test2 ("t") select distinct src from test_source; INSERT 0 2 ran=> insert into test1 ("t") select distinct src from test_source; INSERT 0 4 Look here^ ran=> select * from test2; n|t -+--------------- |First distinct |Second distinct (2 rows) ran=> select * from test1; n|t -+--------------- 1|First distinct 2|First distinct 3|Second distinct 4|Second distinct (4 rows) PostgreSQL 6.4.2, PostgreSQL 6.5.1. -- Artem Chuprina E-mail: ran@pirit.com Network Administrator FIDO: 2:5020/371.32 PIRIT Corp. Phone: +7(095) 115-7101 -
Re: [HACKERS] Bug
Bruce Momjian <pgman@candle.pha.pa.us> — 1999-11-29T23:12:36Z
It appears this bug still exists. > > ---------- Forwarded message ---------- > Date: Fri, 17 Sep 1999 17:52:44 +0400 (MSD) > From: Artem Chuprina <ran@pirit.com> > > ran=> create table test_source (src text); > CREATE > ran=> insert into test_source values('First distinct'); > INSERT 235913 1 > ran=> insert into test_source values('First distinct'); > INSERT 235914 1 > ran=> insert into test_source values('Second distinct'); > INSERT 235915 1 > ran=> insert into test_source values('Second distinct'); > INSERT 235916 1 > ran=> select src from test_source; > src > --------------- > First distinct > First distinct > Second distinct > Second distinct > (4 rows) > > ran=> select distinct src from test_source; > src > --------------- > First distinct > Second distinct > (2 rows) > > ran=> create sequence seq_test; > CREATE > ran=> create table test1 (n int default nextval('seq_test'), t text); > CREATE > ran=> create table test2 (n int, t text); > CREATE > ran=> insert into test2 ("t") select distinct src from test_source; > INSERT 0 2 > ran=> insert into test1 ("t") select distinct src from test_source; > INSERT 0 4 > > Look here^ > > ran=> select * from test2; > n|t > -+--------------- > |First distinct > |Second distinct > (2 rows) > > ran=> select * from test1; > n|t > -+--------------- > 1|First distinct > 2|First distinct > 3|Second distinct > 4|Second distinct > (4 rows) > > PostgreSQL 6.4.2, PostgreSQL 6.5.1. > > -- > Artem Chuprina E-mail: ran@pirit.com > Network Administrator FIDO: 2:5020/371.32 > PIRIT Corp. Phone: +7(095) 115-7101 > > > > ************ > > -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026