Changeset: 89d7ec68f10a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/89d7ec68f10a Added Files: sql/test/2024/Tests/All sql/test/2024/Tests/groupby_primary_key_project_unique_key.test Branch: literal_features Log Message:
Add tests diffs (74 lines): diff --git a/sql/test/2024/Tests/All b/sql/test/2024/Tests/All new file mode 100644 --- /dev/null +++ b/sql/test/2024/Tests/All @@ -0,0 +1,1 @@ +groupby_primary_key_project_unique_key diff --git a/sql/test/2024/Tests/groupby_primary_key_project_unique_key.test b/sql/test/2024/Tests/groupby_primary_key_project_unique_key.test new file mode 100644 --- /dev/null +++ b/sql/test/2024/Tests/groupby_primary_key_project_unique_key.test @@ -0,0 +1,63 @@ +statement ok +CREATE TABLE IF NOT EXISTS product ( + product_id int PRIMARY KEY, + product_name varchar, + product_code varchar UNIQUE +) +---- + +statement ok +CREATE TABLE IF NOT EXISTS product_part ( + product_id int, + part_id int, + num int, + PRIMARY KEY (product_id, part_id) +) +---- + +statement ok +insert into product values +(1, 'telephone1', 'telepone1'), +(2, 'telephone2', 'telepone2'), +(3, 'telephone3', NULL), +(4, 'telephone4', NULL) +---- + +statement ok +insert into product_part values +(1, 10, 100), +(1, 20, 200), +(2, 10, 100), +(2, 20, 200), +(2, 30, 300), +(3, 10, 100), +(4, 10, 100), +(4, 20, 200), +(4, 30, 300) +---- + +query II nosort +SELECT product.product_id, sum(product_part.num) as sum_num +FROM product JOIN product_part ON product.product_id = product_part.product_id +GROUP BY product.product_id +ORDER BY product.product_code, product.product_id +---- +3 +100 +4 +600 +1 +300 +2 +600 + +statement error +SELECT product.product_id, sum(product_part.num) as sum_num +FROM + (SELECT * FROM product UNION ALL VALUES (1, 'telephone5', 'telephone5')) AS product + JOIN + product_part + ON product.product_id = product_part.product_id +GROUP BY product.product_id +ORDER BY product.product_code, product.product_id +---- _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
