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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
|
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.
--
---test which goes through the code path that
--removes the stub files are no longer necessary
create table t1(a int ) ;
0 rows inserted/updated/deleted
ij(CONNECTION1)> autocommit off ;
ij(CONNECTION1)> drop table t1 ;
0 rows inserted/updated/deleted
ij(CONNECTION1)> commit ;
ij(CONNECTION1)> connect 'wombat;shutdown=true';
ERROR 08006: Database 'wombat' shutdown.
ij(CONNECTION1)> disconnect all;
ij> connect 'wombat';
ij> autocommit on;
ij> create table t1(a int ) ;
0 rows inserted/updated/deleted
ij> drop table t1 ;
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> create table t1(a int ) ;
0 rows inserted/updated/deleted
ij> drop table t1 ;
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> create table t1(a int ) ;
0 rows inserted/updated/deleted
ij> drop table t1 ;
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> connect 'wombat;shutdown=true';
ERROR 08006: Database 'wombat' shutdown.
ij> disconnect all;
ij> connect 'wombat';
ij> create table t2( a int ) ;
0 rows inserted/updated/deleted
ij> connect 'wombat;shutdown=true';
ERROR 08006: Database 'wombat' shutdown.
ij> disconnect all;
ij> connect 'wombat';
ij> drop table t2 ;
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> --following create will make sure that the container
--cache does not have the delete stub file entry
create table t3(a int ) ;
0 rows inserted/updated/deleted
ij> --do some inserts/delete and thene remove the stubs
create table t2(b int);
0 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> autocommit off;
ij> delete from t2;
28 rows inserted/updated/deleted
ij> commit;
ij> drop table t2;
0 rows inserted/updated/deleted
ij> commit;
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> -- do some delete and drpop of the container in the same transaction
create table t2(b int);
0 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> commit;
ij> delete from t2;
28 rows inserted/updated/deleted
ij> drop table t2;
0 rows inserted/updated/deleted
ij> commit;
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> --just do a rollback for the heck of it
-- do some delete and drpop of the container in the same transaction
create table t2(b int);
0 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> insert into t2 values (1) , (2) , (3) , (4);
4 rows inserted/updated/deleted
ij> commit;
ij> delete from t2;
28 rows inserted/updated/deleted
ij> drop table t2;
0 rows inserted/updated/deleted
ij> rollback;
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij>
|
