@@ -19,7 +19,6 @@ setup { SET synchronous_commit=on; }
19
19
step "s1_init" {SELECT 'init' FROM pg_create_logical_replication_slot ('isolation_slot' ,'test_decoding' ); }
20
20
step "s1_begin" {BEGIN ; }
21
21
step "s1_insert_tbl1" {INSERT INTO tbl1 (val1 ,val2 )VALUES (1 ,1 ); }
22
- step "s1_insert_tbl1_3col" {INSERT INTO tbl1 (val1 ,val2 ,val3 )VALUES (1 ,1 ,1 ); }
23
22
step "s1_insert_tbl2" {INSERT INTO tbl2 (val1 ,val2 )VALUES (1 ,1 ); }
24
23
step "s1_insert_tbl2_3col" {INSERT INTO tbl2 (val1 ,val2 ,val3 )VALUES (1 ,1 ,1 ); }
25
24
step "s1_commit" {COMMIT ; }
@@ -29,15 +28,8 @@ setup { SET synchronous_commit=on; }
29
28
30
29
step "s2_alter_tbl1_float" {ALTER TABLE tbl1 ALTER COLUMN val2 TYPE float ; }
31
30
step "s2_alter_tbl1_char" {ALTER TABLE tbl1 ALTER COLUMN val2 TYPE character varying ; }
32
- step "s2_alter_tbl1_text" {ALTER TABLE tbl1 ALTER COLUMN val2 TYPE text ; }
33
31
step "s2_alter_tbl1_boolean" {ALTER TABLE tbl1 ALTER COLUMN val2 TYPE boolean ; }
34
32
35
- step "s2_alter_tbl1_add_int" {ALTER TABLE tbl1 ADD COLUMN val3 INTEGER ; }
36
- step "s2_alter_tbl1_add_float" {ALTER TABLE tbl1 ADD COLUMN val3 FLOAT ; }
37
- step "s2_alter_tbl1_add_char" {ALTER TABLE tbl1 ADD COLUMN val3 character varying ; }
38
- step "s2_alter_tbl1_add_boolean" {ALTER TABLE tbl1 ADD COLUMN val3 BOOLEAN ; }
39
- step "s2_alter_tbl1_add_text" {ALTER TABLE tbl1 ADD COLUMN val3 TEXT ; }
40
-
41
33
step "s2_alter_tbl2_float" {ALTER TABLE tbl2 ALTER COLUMN val2 TYPE float ; }
42
34
step "s2_alter_tbl2_char" {ALTER TABLE tbl2 ALTER COLUMN val2 TYPE character varying ; }
43
35
step "s2_alter_tbl2_text" {ALTER TABLE tbl2 ALTER COLUMN val2 TYPE text ; }
@@ -46,7 +38,6 @@ step "s2_alter_tbl2_boolean" { ALTER TABLE tbl2 ALTER COLUMN val2 TYPE boolean;
46
38
step "s2_alter_tbl2_add_int" {ALTER TABLE tbl2 ADD COLUMN val3 INTEGER ; }
47
39
step "s2_alter_tbl2_add_float" {ALTER TABLE tbl2 ADD COLUMN val3 FLOAT ; }
48
40
step "s2_alter_tbl2_add_char" {ALTER TABLE tbl2 ADD COLUMN val3 character varying ; }
49
- step "s2_alter_tbl2_add_boolean" {ALTER TABLE tbl2 ADD COLUMN val3 BOOLEAN ; }
50
41
step "s2_alter_tbl2_add_text" {ALTER TABLE tbl2 ADD COLUMN val3 TEXT ; }
51
42
step "s2_alter_tbl2_drop_3rd_col" {ALTER TABLE tbl2 DROP COLUMN val3 ; }
52
43
step "s2_alter_tbl2_3rd_char" {ALTER TABLE tbl2 ALTER COLUMN val3 TYPE character varying ; }