Changeset: a00159335de3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a00159335de3
Modified Files:
sql/test/DropCascade/Tests/drop_columns_cascade.sql
sql/test/DropCascade/Tests/drop_pkey_cascade.sql
Branch: comment-on
Log Message:
sql/test/DropCascade: take key comments_id_pkey into account
diffs (24 lines):
diff --git a/sql/test/DropCascade/Tests/drop_columns_cascade.sql
b/sql/test/DropCascade/Tests/drop_columns_cascade.sql
--- a/sql/test/DropCascade/Tests/drop_columns_cascade.sql
+++ b/sql/test/DropCascade/Tests/drop_columns_cascade.sql
@@ -49,7 +49,7 @@ select name from functions where name =
select name from triggers where name = 'test1';
select name from idxs where name = 'id_index';
select name from columns where name = 'id' and table_id in (select id from
tables where name = 't1' or name = 't2');
-select name from keys where name not in ('files_pkey_file_id',
'sq_pkey_sn_file_id', 'sq_fkey_file_id', 'rg_pkey_id_file_id',
'rg_fkey_file_id', 'pg_pkey_id_file_id', 'pg_fkey_file_id',
'spatial_ref_sys_srid_pkey');
+select name from keys where name not in ('files_pkey_file_id',
'sq_pkey_sn_file_id', 'sq_fkey_file_id', 'rg_pkey_id_file_id',
'rg_fkey_file_id', 'pg_pkey_id_file_id', 'pg_fkey_file_id',
'spatial_ref_sys_srid_pkey', 'comments_id_pkey');
--Just for debug
diff --git a/sql/test/DropCascade/Tests/drop_pkey_cascade.sql
b/sql/test/DropCascade/Tests/drop_pkey_cascade.sql
--- a/sql/test/DropCascade/Tests/drop_pkey_cascade.sql
+++ b/sql/test/DropCascade/Tests/drop_pkey_cascade.sql
@@ -7,7 +7,7 @@ ALTER TABLE t1 DROP CONSTRAINT t1_id_pke
select name from tables where name = 't1';
select name from tables where name = 't2';
-select name from keys where name not in ('files_pkey_file_id',
'sq_pkey_sn_file_id', 'sq_fkey_file_id', 'rg_pkey_id_file_id',
'rg_fkey_file_id', 'pg_pkey_id_file_id', 'pg_fkey_file_id',
'spatial_ref_sys_srid_pkey');
+select name from keys where name not in ('files_pkey_file_id',
'sq_pkey_sn_file_id', 'sq_fkey_file_id', 'rg_pkey_id_file_id',
'rg_fkey_file_id', 'pg_pkey_id_file_id', 'pg_fkey_file_id',
'spatial_ref_sys_srid_pkey', 'comments_id_pkey');
--just for debug
--select * from dependencies;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
