Script started on Thu Nov  9 17:19:02 2000
[kevin@glynnis OLAP]$ cat bust.sql
-- bust.sql
/* Cause a backend crash */

\qecho Running $Id: bust.sql,v 1.1 2000/11/10 01:12:49 kevin Exp kevin $

/* first, execute this: */

delete from tmprolling
;

EXPLAIN
select
	a.product_level, 
	a.customer_level,
	a.channel_level,
	199504,
	sum (a.dollarsales) / 4 As dollarsales
from
	actvars a, prodlevel, custlevel
where
	    a.time_level in ('199501','199502','199503','199504')
	and prodlevel.code_level = a.product_level
	and custlevel.store_level = a.customer_level
	and prodlevel.Class_level = 'I7BEZZM9YJND'
	and custlevel.Retailer_level = 'TBVYYQ1ONYC8'
group by
	a.product_level, 
	a.customer_level,
	a.channel_level
;

\! date

insert into tmprolling (
	product_level, 
	customer_level,
	channel_level,
	time_level,
	dollarsales
)
select
	a.product_level, 
	a.customer_level,
	a.channel_level,
	199504,
	sum (a.dollarsales) / 4 As dollarsales
from
	actvars a, prodlevel, custlevel
where
	    a.time_level in ('199501','199502','199503','199504')
	and prodlevel.code_level = a.product_level
	and custlevel.store_level = a.customer_level
	and prodlevel.Class_level = 'I7BEZZM9YJND'
	and custlevel.Retailer_level = 'TBVYYQ1ONYC8'
group by
	a.product_level, 
	a.customer_level,
	a.channel_level
;
[kevin@glynnis OLAP]$ psql
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

kevin=# \i bust.sql
Running $Id: bust.sql,v 1.1 2000/11/10 01:12:49 kevin Exp kevin $
DELETE 0
psql:bust.sql:30: NOTICE:  QUERY PLAN:

Group  (cost=1379.83..1379.84 rows=1 width=68)
  ->  Sort  (cost=1379.83..1379.83 rows=1 width=68)
        ->  Nested Loop  (cost=0.00..1379.82 rows=1 width=68)
              ->  Index Scan using ctl2 on custlevel  (cost=0.00..2.01 rows=1 width=12)
              ->  Materialize  (cost=1377.16..1377.16 rows=52 width=56)
                    ->  Nested Loop  (cost=0.00..1377.16 rows=52 width=56)
                          ->  Index Scan using plf2 on prodlevel  (cost=0.00..3.06 rows=2 width=12)
                          ->  Index Scan using custindex on actvars a  (cost=0.00..915.85 rows=17 width=44)

EXPLAIN
Thu Nov  9 17:19:58 PST 2000
psql:bust.sql:59: pqReadData() -- backend closed the channel unexpectedly.
	This probably means the backend terminated abnormally
	before or while processing the request.
psql:bust.sql:59: connection to server was lost
[kevin@glynnis OLAP]$ 
Script done on Thu Nov  9 17:20:11 2000