-- TEST CASE: dead loop
--
CREATE TABLE cmpr_toast_dead_loop_raw
(
    id int delta,
    f1 varchar(10000)
);
INSERT INTO cmpr_toast_dead_loop_raw select generate_series(1,5), repeat('^_^ Kenyon is not God,Remark here!!',3);
INSERT INTO cmpr_toast_dead_loop_raw select generate_series(1,5), repeat('^_^ Kenyon is not God,Remark here!!',200);
INSERT INTO cmpr_toast_dead_loop_raw SELECT * FROM cmpr_toast_dead_loop_raw;
INSERT INTO cmpr_toast_dead_loop_raw SELECT * FROM cmpr_toast_dead_loop_raw;
INSERT INTO cmpr_toast_dead_loop_raw SELECT * FROM cmpr_toast_dead_loop_raw;
INSERT INTO cmpr_toast_dead_loop_raw SELECT * FROM cmpr_toast_dead_loop_raw;
INSERT INTO cmpr_toast_dead_loop_raw SELECT * FROM cmpr_toast_dead_loop_raw;
COPY cmpr_toast_dead_loop_raw TO '@abs_srcdir@/data/cmpr_toast_dead_loop.data';

CREATE TABLE cmpr_toast_dead_loop
(
    id int delta,
    f1 varchar(10000)
) ;
COPY cmpr_toast_dead_loop FROM '@abs_srcdir@/data/cmpr_toast_dead_loop.data';

SELECT (SELECT COUNT(*) FROM cmpr_toast_dead_loop_raw) - (SELECT COUNT(*) FROM cmpr_toast_dead_loop);
(SELECT * FROM cmpr_toast_dead_loop_raw) MINUS ALL (SELECT * FROM cmpr_toast_dead_loop);
(SELECT * FROM cmpr_toast_dead_loop) MINUS ALL (SELECT * FROM cmpr_toast_dead_loop_raw);

DROP TABLE cmpr_toast_dead_loop_raw;
DROP TABLE cmpr_toast_dead_loop;
\! rm @abs_srcdir@/data/cmpr_toast_dead_loop.data