Changeset: 74edeefee3af for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/74edeefee3af Branch: pushcands Log Message:
merged diffs (truncated from 434 to 300 lines): diff --git a/sql/test/miscellaneous/Tests/groupby_expressions.test b/sql/test/miscellaneous/Tests/groupby_expressions.test --- a/sql/test/miscellaneous/Tests/groupby_expressions.test +++ b/sql/test/miscellaneous/Tests/groupby_expressions.test @@ -383,3 +383,430 @@ select 1 from "groupings" group by "aa" statement ok drop table "groupings" +statement ok +START TRANSACTION + +statement ok +CREATE TABLE "mygroup" ("id" INTEGER, "depend_id" INTEGER,"depend_type" SMALLINT) + +statement ok rowcount 405 +COPY 405 RECORDS INTO "mygroup" FROM stdin USING DELIMITERS E'\t',E'\n','"' +<COPY_INTO_DATA> +2065 5547 5 +2066 5547 5 +5173 5558 5 +5174 5558 5 +5175 5558 5 +5179 5558 5 +2063 5558 5 +2064 5558 5 +2065 5558 5 +2066 5558 5 +5163 5558 5 +5164 5558 5 +5165 5558 5 +5166 5558 5 +5168 5558 5 +2016 5567 5 +2017 5567 5 +2018 5567 5 +2026 5567 5 +2063 5567 5 +2064 5567 5 +2065 5567 5 +2066 5567 5 +5163 5567 5 +5164 5567 5 +5165 5567 5 +5166 5567 5 +5168 5567 5 +5204 5573 5 +5205 5573 5 +5207 5573 5 +2001 5573 5 +2002 5573 5 +2003 5573 5 +2016 5581 5 +2017 5581 5 +2018 5581 5 +2022 5581 5 +2063 5581 5 +2064 5581 5 +2065 5581 5 +2066 5581 5 +5163 5581 5 +5164 5581 5 +5165 5581 5 +5166 5581 5 +5168 5581 5 +2016 5589 5 +2017 5589 5 +2018 5589 5 +2022 5589 5 +2063 5589 5 +2064 5589 5 +2065 5589 5 +2066 5589 5 +5163 5589 5 +5164 5589 5 +5165 5589 5 +5166 5589 5 +5168 5589 5 +2016 5598 5 +2017 5598 5 +2018 5598 5 +2022 5598 5 +2063 5598 5 +2064 5598 5 +2065 5598 5 +2066 5598 5 +5173 5598 5 +5174 5598 5 +5175 5598 5 +5179 5598 5 +2016 5609 5 +2017 5609 5 +2018 5609 5 +2022 5609 5 +2026 5609 5 +2063 5609 5 +2064 5609 5 +2065 5609 5 +2066 5609 5 +2099 5617 5 +2100 5617 5 +2101 5617 5 +2102 5617 5 +5163 5617 5 +5164 5617 5 +5165 5617 5 +5166 5617 5 +2063 5617 5 +2064 5617 5 +2065 5617 5 +2066 5617 5 +2063 5627 5 +2064 5627 5 +2065 5627 5 +2066 5627 5 +5173 5627 5 +5174 5627 5 +5175 5627 5 +5179 5627 5 +2099 5627 5 +2100 5627 5 +2101 5627 5 +5163 5627 5 +5164 5627 5 +5165 5627 5 +5166 5627 5 +2063 5637 5 +2064 5637 5 +2065 5637 5 +2066 5637 5 +2016 5637 5 +2017 5637 5 +2018 5637 5 +2022 5637 5 +2026 5637 5 +2099 5637 5 +2100 5637 5 +2101 5637 5 +2102 5637 5 +2094 5646 5 +2095 5646 5 +2096 5646 5 +2097 5646 5 +2098 5646 5 +5163 5646 5 +5164 5646 5 +5165 5646 5 +5166 5646 5 +2087 5646 5 +2089 5646 5 +2091 5646 5 +2110 5658 5 +2111 5658 5 +2112 5658 5 +2113 5658 5 +2094 5658 5 +2095 5658 5 +2096 5658 5 +2097 5658 5 +2098 5658 5 +5173 5658 5 +5174 5658 5 +5175 5658 5 +5179 5658 5 +5163 5658 5 +5164 5658 5 +5165 5658 5 +5166 5658 5 +2087 5658 5 +2089 5658 5 +2091 5658 5 +2087 5666 5 +2091 5666 5 +2092 5666 5 +2088 5666 5 +2089 5666 5 +2090 5666 5 +5163 5666 5 +5164 5666 5 +5165 5666 5 +5166 5666 5 +2087 5676 5 +2088 5676 5 +2089 5676 5 +2090 5676 5 +2091 5676 5 +2092 5676 5 +2016 5685 5 +2017 5685 5 +2018 5685 5 +2022 5685 5 +2063 5685 5 +2064 5685 5 +2065 5685 5 +2066 5685 5 +5163 5685 5 +5164 5685 5 +5165 5685 5 +5166 5685 5 +5168 5685 5 +2016 5694 5 +2017 5694 5 +2018 5694 5 +2022 5694 5 +2063 5694 5 +2064 5694 5 +2065 5694 5 +2066 5694 5 +5163 5694 5 +5164 5694 5 +5165 5694 5 +5166 5694 5 +5168 5694 5 +2016 5703 5 +2017 5703 5 +2018 5703 5 +2022 5703 5 +2063 5703 5 +2064 5703 5 +2065 5703 5 +2066 5703 5 +5173 5703 5 +5174 5703 5 +5175 5703 5 +5179 5703 5 +2016 5714 5 +2017 5714 5 +2018 5714 5 +2022 5714 5 +2026 5714 5 +2063 5714 5 +2064 5714 5 +2065 5714 5 +2066 5714 5 +2063 5724 5 +2064 5724 5 +2065 5724 5 +2066 5724 5 +2007 5724 5 +2008 5724 5 +2010 5724 5 +5173 5724 5 +5174 5724 5 +5175 5724 5 +5179 5724 5 +5163 5724 5 +5164 5724 5 +5165 5724 5 +5166 5724 5 +2063 5732 5 +2064 5732 5 +2065 5732 5 +2066 5732 5 +2007 5732 5 +2008 5732 5 +2010 5732 5 +2016 5732 5 +2017 5732 5 +2018 5732 5 +2022 5732 5 +2063 5742 5 +2064 5742 5 +2065 5742 5 +2066 5742 5 +2007 5742 5 +2008 5742 5 +2010 5742 5 +2028 5742 5 +2029 5742 5 +2030 5742 5 +2031 5742 5 +2036 5742 5 +2016 5742 5 +2017 5742 5 +2018 5742 5 +5754 5774 5 +5834 5846 5 +5848 5868 5 +5877 5882 7 +5911 5919 5 +5184 5923 5 +5998 6018 5 +6038 6048 5 +6697 6699 10 +6697 6698 4 +5173 6713 5 +5175 6713 5 +5176 6713 5 +5177 6713 5 +5178 6713 5 +5179 6713 5 +2007 6713 5 +2009 6713 5 +2010 6713 5 +5163 6713 5 +5164 6713 5 +5165 6713 5 +5166 6713 5 +2001 6713 5 +2002 6713 5 +2003 6713 5 +6684 6713 5 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list