aboutsummaryrefslogtreecommitdiff
path: root/contrib/postgres_fdw/sql/query_cancel.sql
blob: 8f11f3f9a6a2cbd5f8732db6366b2daad015db0d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
SELECT version() ~ 'cygwin' AS skip_test \gset
\if :skip_test
\quit
\endif

-- Make sure this big CROSS JOIN query is pushed down
EXPLAIN (VERBOSE, COSTS OFF) SELECT count(*) FROM ft1 CROSS JOIN ft2 CROSS JOIN ft4 CROSS JOIN ft5;
-- Make sure query cancellation works
BEGIN;
SET LOCAL statement_timeout = '10ms';
select count(*) from ft1 CROSS JOIN ft2 CROSS JOIN ft4 CROSS JOIN ft5; -- this takes very long
COMMIT;