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
|
--
-- 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.
--
-- Track 4257
-- Track 4258
-- Track 4259
--
-- test case to make sure that conglomerate metadata is stored/retrieved
-- correctly across database boots. track 4257-9 all were caused by not
-- storing the metadata correctly after an addColumn call.
-- baseline case for add column test
create table foo (a int);
insert into foo values (1);
insert into foo values (1, 2);
select * from foo;
-- baseline case of simple create/index test
create table foo2 (a int, b int, c int);
create index foo2_idx on foo2 (c);
insert into foo2 values (3, 30, 300);
insert into foo2 values (2, 20, 200);
insert into foo2 values (1, 10, 100);
disconnect;
connect 'wombat;shutdown=true';
connect 'wombat' as conn1;
alter table foo add column b int;
select * from foo;
insert into foo values (2, 1);
select * from foo;
-- just make sure normal case works too.
select * from foo2;
select c from foo2;
select c from foo2;
disconnect;
connect 'wombat;shutdown=true';
connect 'wombat' as conn2;
-- does insert correctly pick up previous alter?
insert into foo values (2, 2);
-- does alter correctly pick up previous alter?
alter table foo add column c int;
-- does select correctly pick up previous alter?
select * from foo;
insert into foo values (3, 1, 1);
select * from foo;
disconnect;
connect 'wombat;shutdown=true';
|
