Changeset: c8ec6e6ec98f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c8ec6e6ec98f
Modified Files:
sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql
sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
Branch: Apr2019
Log Message:
Remove duplicate check.
diffs (26 lines):
diff --git
a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql
b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql
--- a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql
+++ b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql
@@ -34,7 +34,6 @@ SELECT * FROM sys.types WHERE schema_id
SELECT * FROM sys.types WHERE schema_id NOT IN (SELECT id FROM sys.schemas)
AND schema_id <> 0;
SELECT * FROM sys.objects WHERE id NOT IN (SELECT id FROM sys.ids);
-SELECT * FROM sys.objects WHERE id NOT IN (SELECT id FROM sys.ids);
SELECT * FROM sys.ids WHERE obj_type IN ('key', 'index') AND id NOT IN (SELECT
id FROM sys.objects);
SELECT * FROM sys.keys WHERE id NOT IN (SELECT id FROM sys.objects);
diff --git
a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
---
a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
+++
b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
@@ -139,11 +139,6 @@ Ready.
% id, name, nr # name
% int, varchar, int # type
% 1, 0, 1 # length
-#SELECT * FROM sys.objects WHERE id NOT IN (SELECT id FROM sys.ids);
-% sys.objects, sys.objects, sys.objects # table_name
-% id, name, nr # name
-% int, varchar, int # type
-% 1, 0, 1 # length
#SELECT * FROM sys.ids WHERE obj_type IN ('key', 'index') AND id NOT IN
(SELECT id FROM sys.objects);
% .ids, .ids, .ids, .ids, .ids, .ids, .ids # table_name
% id, name, schema_id, table_id, table_name, obj_type,
sys_table # name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
