Re: [HACKERS] Bug

It appears this bug still exists.

>
> ---------- Forwarded message ----------
> Date: Fri, 17 Sep 1999 17:52:44 +0400 (MSD)
> From: Artem Chuprina <ran(at)pirit(dot)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(at)pirit(dot)com
> Network Administrator FIDO: 2:5020/371.32
> PIRIT Corp. Phone: +7(095) 115-7101
>
>
>
> ************
>
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026