Changeset: f91c82d2507f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f91c82d2507f
Modified Files:
sql/test/Tests/keys.test
Branch: Dec2025
Log Message:
Approve test after changeset 9c1a2f60166e.
diffs (231 lines):
diff --git a/sql/test/Tests/keys.test b/sql/test/Tests/keys.test
--- a/sql/test/Tests/keys.test
+++ b/sql/test/Tests/keys.test
@@ -21,90 +21,27 @@ FROM sys.idxs LEFT JOIN sys.keys on idxs
WHERE idxs.name NOT LIKE '%srid%' -- skip geom keys
ORDER BY idxs.name, keys.name
----
-allnewtriples_object_idx
-0
-NULL
-NULL
-allnewtriples_predicate_idx
-0
-NULL
-NULL
-allnewtriples_subject_idx
-0
-NULL
-NULL
-comments_id_pkey
-0
-comments_id_pkey
-0
-dependency_types_dependency_type_id_pkey
-0
-dependency_types_dependency_type_id_pkey
-0
-dependency_types_dependency_type_name_unique
-0
-dependency_types_dependency_type_name_unique
-1
-fkey_actions_action_id_pkey
-0
-fkey_actions_action_id_pkey
-0
-function_languages_language_id_pkey
-0
-function_languages_language_id_pkey
-0
-function_languages_language_name_unique
-0
-function_languages_language_name_unique
-1
-function_types_function_type_id_pkey
-0
-function_types_function_type_id_pkey
-0
-function_types_function_type_name_unique
-0
-function_types_function_type_name_unique
-1
-index_types_index_type_id_pkey
-0
-index_types_index_type_id_pkey
-0
-index_types_index_type_name_unique
-0
-index_types_index_type_name_unique
-1
-key_types_key_type_id_pkey
-0
-key_types_key_type_id_pkey
-0
-key_types_key_type_name_unique
-0
-key_types_key_type_name_unique
-1
-keywords_keyword_pkey
-0
-keywords_keyword_pkey
-0
-privilege_codes_privilege_code_id_pkey
-0
-privilege_codes_privilege_code_id_pkey
-0
-privilege_codes_privilege_code_name_unique
-0
-privilege_codes_privilege_code_name_unique
-1
-table_types_table_type_id_pkey
-0
-table_types_table_type_id_pkey
-0
-table_types_table_type_name_unique
-0
-table_types_table_type_name_unique
-1
-unique_key
-0
-unique_key
-1
+allnewtriples_object_idx 0 NULL NULL
+allnewtriples_predicate_idx 0 NULL NULL
+allnewtriples_subject_idx 0 NULL NULL
+comments_id_pkey 0 comments_id_pkey 0
+dependency_types_dependency_type_id_pkey 0
dependency_types_dependency_type_id_pkey 0
+dependency_types_dependency_type_name_unique 0
dependency_types_dependency_type_name_unique 1
+fkey_actions_action_id_pkey 0 fkey_actions_action_id_pkey 0
+function_languages_language_id_pkey 0
function_languages_language_id_pkey 0
+function_languages_language_name_unique 0
function_languages_language_name_unique 1
+function_types_function_type_id_pkey 0
function_types_function_type_id_pkey 0
+function_types_function_type_name_unique 0
function_types_function_type_name_unique 1
+index_types_index_type_id_pkey 0 index_types_index_type_id_pkey 0
+index_types_index_type_name_unique 0
index_types_index_type_name_unique 1
+key_types_key_type_id_pkey 0 key_types_key_type_id_pkey 0
+key_types_key_type_name_unique 0 key_types_key_type_name_unique 1
+keywords_keyword_pkey 0 keywords_keyword_pkey 0
+privilege_codes_privilege_code_id_pkey 0
privilege_codes_privilege_code_id_pkey 0
+privilege_codes_privilege_code_name_unique 0
privilege_codes_privilege_code_name_unique 1
+table_types_table_type_id_pkey 0 table_types_table_type_id_pkey 0
+table_types_table_type_name_unique 0
table_types_table_type_name_unique 1
+unique_key 0 unique_key 1
query TITI nosort
SELECT idxs.name, idxs."type", keys.name, keys."type"
@@ -112,78 +49,24 @@ FROM sys.idxs JOIN sys.keys on idxs.name
WHERE idxs.name NOT LIKE '%srid%' -- skip geom keys
ORDER BY idxs.name, keys.name
----
-comments_id_pkey
-0
-comments_id_pkey
-0
-dependency_types_dependency_type_id_pkey
-0
-dependency_types_dependency_type_id_pkey
-0
-dependency_types_dependency_type_name_unique
-0
-dependency_types_dependency_type_name_unique
-1
-fkey_actions_action_id_pkey
-0
-fkey_actions_action_id_pkey
-0
-function_languages_language_id_pkey
-0
-function_languages_language_id_pkey
-0
-function_languages_language_name_unique
-0
-function_languages_language_name_unique
-1
-function_types_function_type_id_pkey
-0
-function_types_function_type_id_pkey
-0
-function_types_function_type_name_unique
-0
-function_types_function_type_name_unique
-1
-index_types_index_type_id_pkey
-0
-index_types_index_type_id_pkey
-0
-index_types_index_type_name_unique
-0
-index_types_index_type_name_unique
-1
-key_types_key_type_id_pkey
-0
-key_types_key_type_id_pkey
-0
-key_types_key_type_name_unique
-0
-key_types_key_type_name_unique
-1
-keywords_keyword_pkey
-0
-keywords_keyword_pkey
-0
-privilege_codes_privilege_code_id_pkey
-0
-privilege_codes_privilege_code_id_pkey
-0
-privilege_codes_privilege_code_name_unique
-0
-privilege_codes_privilege_code_name_unique
-1
-table_types_table_type_id_pkey
-0
-table_types_table_type_id_pkey
-0
-table_types_table_type_name_unique
-0
-table_types_table_type_name_unique
-1
-unique_key
-0
-unique_key
-1
+comments_id_pkey 0 comments_id_pkey 0
+dependency_types_dependency_type_id_pkey 0
dependency_types_dependency_type_id_pkey 0
+dependency_types_dependency_type_name_unique 0
dependency_types_dependency_type_name_unique 1
+fkey_actions_action_id_pkey 0 fkey_actions_action_id_pkey 0
+function_languages_language_id_pkey 0
function_languages_language_id_pkey 0
+function_languages_language_name_unique 0
function_languages_language_name_unique 1
+function_types_function_type_id_pkey 0
function_types_function_type_id_pkey 0
+function_types_function_type_name_unique 0
function_types_function_type_name_unique 1
+index_types_index_type_id_pkey 0 index_types_index_type_id_pkey 0
+index_types_index_type_name_unique 0
index_types_index_type_name_unique 1
+key_types_key_type_id_pkey 0 key_types_key_type_id_pkey 0
+key_types_key_type_name_unique 0 key_types_key_type_name_unique 1
+keywords_keyword_pkey 0 keywords_keyword_pkey 0
+privilege_codes_privilege_code_id_pkey 0
privilege_codes_privilege_code_id_pkey 0
+privilege_codes_privilege_code_name_unique 0
privilege_codes_privilege_code_name_unique 1
+table_types_table_type_id_pkey 0 table_types_table_type_id_pkey 0
+table_types_table_type_name_unique 0
table_types_table_type_name_unique 1
+unique_key 0 unique_key 1
statement ok
create table dummyme (a int primary key, b int)
@@ -289,7 +172,7 @@ project (
| | project (
| | | table("sys"."dummyme") [ "dummyme"."a" NOT NULL UNIQUE HASHCOL ]
| | ) [ "sys"."abs"("dummyme"."a" NOT NULL UNIQUE HASHCOL ) NOT NULL as
"%2"."%2" ]
-| ) [ ] [ "sys"."count"() NOT NULL UNIQUE as "%1"."%1" ]
+| ) [ ] [ "sys"."count" no nil ("%2"."%2" NOT NULL) NOT NULL UNIQUE as
"%1"."%1" ]
) [ "%1"."%1" NOT NULL UNIQUE ]
query I nosort
@@ -309,8 +192,7 @@ project (
query II nosort
select count(a) as x, count(*) as y from dummyme
----
-3
-3
+3 3
statement ok
ROLLBACK
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
