Re: [HACKERS] current- crash - Mailing list pgsql-hackers

> Michael Reifenberger wrote:
> >
> > Hi,
> > I can easily crash the backend of current- postgres on current- FreeBSD with
> > loading a database with test.sql and test.dmp an executing the script x.sql.
> > Anyone else?
> >
> > Bye!
> > ----
> > Michael Reifenberger
> > Plaut Software GmbH, R/3 Basis
> >
> >   ------------------------------------------------------------------------
> > CREATE TABLE b (begt datetime, kid int4);
> > CREATE TABLE a (kid int4);
> > CREATE TABLE c (a int4, b varchar(30), c int4);
> > CREATE  INDEX b_0 on b using btree ( begt datetime_ops );
> > CREATE  INDEX b_1 on b using btree ( kid int4_ops );
> > CREATE  INDEX a_0 on a using btree ( kid int4_ops );
> >
> >   ------------------------------------------------------------------------
> > COPY b FROM stdin;
> > \.
> > COPY a FROM stdin;
> > \.
> > COPY c FROM stdin;
> > 1       foo     1
> > 2       foo bar 2
> > 3       \N      3
> > 4       \\serverla     4
> > \.
> >
> >   ------------------------------------------------------------------------
> >   explain SELECT a.kid as foo
> >         FROM a, b WHERE
> >         a.kid = b.kid AND
> >         ( b.kid = 23 OR
> >           b.kid = 36 );
>
>
> I tried your script but I can't see nothing wrong. :)
>
> CREATE TABLE b (begt datetime, kid int4);
> CREATE
> CREATE TABLE a (kid int4);
> CREATE
> CREATE TABLE c (a int4, b varchar(30), c int4);
> CREATE
> CREATE  INDEX b_0 on b using btree ( begt datetime_ops );
> CREATE
> CREATE  INDEX b_1 on b using btree ( kid int4_ops );
> CREATE
> CREATE  INDEX a_0 on a using btree ( kid int4_ops );
> CREATE
>
> COPY b FROM stdin;
> COPY a FROM stdin;
>
> COPY c FROM stdin;
>
> select *  from c;
> a|b        |c
> -+---------+-
> 1|foo      |1
> 2|foo bar  |2
> 3|         |3
> 4|\\servela|4
> (4 rows)
>
> explain SELECT a.kid as foo
>         FROM a, b WHERE
>         a.kid = b.kid AND
>         ( b.kid = 23 OR
>           b.kid = 36 );
> NOTICE:  QUERY PLAN:
>
> Merge Join  (cost=0.00 size=1 width=8)
>   ->  Seq Scan  (cost=0.00 size=0 width=0)
>         ->  Sort  (cost=0.00 size=0 width=0)
>               ->  Seq Scan on a  (cost=0.00 size=0 width=4)
>   ->  Seq Scan  (cost=0.00 size=0 width=0)
>         ->  Sort  (cost=0.00 size=0 width=0)
>               ->  Seq Scan on b  (cost=0.00 size=0 width=4)
>
> EXPLAIN

Perhaps because I fixed it two days ago.

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