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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
ij(CONNECTION1)> --
-- 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.
--
drop table t1;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T1' because it does not exist.
ij(CONNECTION1)> create table t1 (i integer primary key, j integer, c char(200));
0 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 values (1, 1, 'a');
1 row inserted/updated/deleted
ij(CONNECTION1)> insert into t1 (select t1.i + 2, t1.j + 2, t1.c from t1);
1 row inserted/updated/deleted
ij(CONNECTION1)> insert into t1 (select t1.i + 4, t1.j + 4, t1.c from t1);
2 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 (select t1.i + 8, t1.j + 8, t1.c from t1);
4 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 (select t1.i + 16, t1.j + 16, t1.c from t1);
8 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 (select t1.i + 32, t1.j + 32, t1.c from t1);
16 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 (select t1.i + 64, t1.j + 64, t1.c from t1);
32 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 (select t1.i + 128, t1.j + 128, t1.c from t1);
64 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 (select t1.i + 256, t1.j + 256, t1.c from t1);
128 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 (select t1.i + 512, t1.j + 512, t1.c from t1);
256 rows inserted/updated/deleted
ij(CONNECTION1)> insert into t1 (select t1.i + 1024, t1.j + 1024, t1.c from t1);
512 rows inserted/updated/deleted
ij(CONNECTION1)> delete from t1 where j=1;
1 row inserted/updated/deleted
ij(CONNECTION1)> CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('APP', 'T1', 1, 1, 1);
0 rows inserted/updated/deleted
ij(CONNECTION1)> delete from t1 where j=2;
0 rows inserted/updated/deleted
WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
ij(CONNECTION1)> CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('APP', 'T1', 1, 1, 1);
0 rows inserted/updated/deleted
ij(CONNECTION1)> delete from t1 where i > 1024;
512 rows inserted/updated/deleted
ij(CONNECTION1)> CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('APP', 'T1', 1, 1, 1);
0 rows inserted/updated/deleted
ij(CONNECTION1)> delete from t1 where i < 512;
255 rows inserted/updated/deleted
ij(CONNECTION1)> -- prior to the fix the following compress would result in a deadlock
CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('APP', 'T1', 1, 1, 1);
0 rows inserted/updated/deleted
ij(CONNECTION1)>
|
