Test alter_table_drop_column.Bug-6749.py (id 3c6cbe78e1fe) (err)
alter_table_drop_column.Bug-6749.stable.out.FILTERED 2019-09-08 12:09:15.748830235 +0200alter_table_drop_column.Bug-6749.test.out.FILTERED 2019-09-08 12:09:15.759830328 +0200
..................
# .L54 # table_name
171 % L # name 171 131 % L # name 131
172 # L54 # name 172 ! 132 # L34 # name 132
173 % bigint # type 173 133 % bigint # type 133
174 % 1 # length 174 134 % 1 # length 134
175 [ 2 ] 175 ! 135 [ 0 ] 135
176 #drop table t;start transaction;create table t (a int, b int, c int);alter table t add unique (b);select * from t;select count(*) from objects inner join dependencies on objects.id = dependencies.depend_id inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select count(*) from dependencies inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on tables.id = idxs.table_id where tables.name = 't';alter table t drop column b cascade;select count(*) from objects inner join dependencies on objects.id = dependencies.depend_id inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select count(*) from dependencies inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on tables.id = idxs.table_id where tables.name = 't';select * from t;commit;select * from t;drop table t; 176 136 #drop table t;start transaction;create table t (a int, b int, c int);alter table t add unique (b);select * from t;select count(*) from objects inner join dependencies on objects.id = dependencies.depend_id inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select count(*) from dependencies inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on tables.id = idxs.table_id where tables.name = 't';alter table t drop column b cascade;select count(*) from objects inner join dependencies on objects.id = dependencies.depend_id inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select count(*) from dependencies inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on tables.id = idxs.table_id where tables.name = 't';select * from t;commit;select * from t;drop table t; 136
..................
# .L54 # table_name
179 % L # name 179 139 % L # name 139
180 # L54 # name 180 ! 140 # L32 # name 140
181 % bigint # type 181 141 % bigint # type 141
182 % 1 # length 182 142 % 1 # length 142
183 [ 2 ] 183 ! 143 [ 0 ] 143
184 #drop table t;start transaction;create table t (a int, b int, c int);alter table t add unique (b);select * from t;select count(*) from objects inner join dependencies on objects.id = dependencies.depend_id inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select count(*) from dependencies inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on tables.id = idxs.table_id where tables.name = 't';alter table t drop column b cascade;select count(*) from objects inner join dependencies on objects.id = dependencies.depend_id inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select count(*) from dependencies inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on tables.id = idxs.table_id where tables.name = 't';select * from t;commit;select * from t;drop table t; 184 144 #drop table t;start transaction;create table t (a int, b int, c int);alter table t add unique (b);select * from t;select count(*) from objects inner join dependencies on objects.id = dependencies.depend_id inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select count(*) from dependencies inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on tables.id = idxs.table_id where tables.name = 't';alter table t drop column b cascade;select count(*) from objects inner join dependencies on objects.id = dependencies.depend_id inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select count(*) from dependencies inner join columns on dependencies.id = columns.id inner join tables on columns.table_id = tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on tables.id = idxs.table_id where tables.name = 't';select * from t;commit;select * from t;drop table t; 144