1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
--
-- Licensed to the Apache Software Foundation (ASF) under one or more
-- contributor license agreements. See the NOTICE file distributed with
-- this work for additional information regarding copyright ownership.
-- The ASF licenses this file to You under the Apache License, Version 2.0
-- (the "License"); you may not use this file except in compliance with
-- the License. You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
-- DERBY-939
-- Test union and intersect/except with runtime statistics enabled.
CREATE TABLE t1 (i int);
CREATE TABLE t2 (j int);
CREATE TABLE t3 (k int);
INSERT INTO t1 VALUES 3,2,1;
INSERT INTO t2 VALUES 1,2,3,4;
INSERT INTO t3 VALUES 5,2,3,4,1;
CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
MaximumDisplayWidth 7000;
SELECT i FROM t1 UNION SELECT j FROM t2 INTERSECT SELECT k FROM t3;
VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
SELECT i FROM t1 UNION SELECT j FROM t2 EXCEPT SELECT k FROM t3;
VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
SELECT i FROM t1 INTERSECT SELECT j FROM t2 EXCEPT SELECT k FROM t3;
VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0);
|
