Re: [HACKERS] current- crash

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

                           Jose'