MonetDB: Nov2019 - merged

[Niels Nes]

Changeset: e4d0b0ab7456 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e4d0b0ab7456
Modified Files:
        sql/test/BugTracker-2019/Tests/All
        sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
        
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
        sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
        sql/test/emptydb-upgrade/Tests/upgrade.stable.out
        sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
        sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
        sql/test/mergetables/Tests/All
        sql/test/subquery/Tests/All
        sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
        sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
        sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
        sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
        sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
        sql/test/testdb-upgrade/Tests/upgrade.stable.out
        sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
        sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: Nov2019
Log Message:

merged


diffs (truncated from 1118 to 300 lines):

diff --git a/sql/test/BugTracker-2019/Tests/All 
b/sql/test/BugTracker-2019/Tests/All
--- a/sql/test/BugTracker-2019/Tests/All
+++ b/sql/test/BugTracker-2019/Tests/All
@@ -18,8 +18,8 @@ merge-statement-aliases.Bug-6715
 insert-into-select.Bug-6718
 copy-into-unicode-quote.Bug-6716
 select_window_function_and_asterisk.Bug-6722
-disallow_duplicate_column_aliases.Bug-6723
-prepare-types.Bug-6724
+KNOWNFAIL?disallow_duplicate_column_aliases.Bug-6723
+KNOWNFAIL?prepare-types.Bug-6724
 prepare-non-existing-function.Bug-6725
 select-distinct.Bug-6728
 table-duplicate-column.Bug-6729
@@ -30,13 +30,13 @@ sequence-first-next-value.Bug-6743
 sequences-defaults.Bug-6744
 sequences-types.Bug-6745
 alter_table_drop_column.Bug-6749
-HAVE_PYMONETDB?remote-table-non-existent-column.Bug-6750
+KNOWNFAIL&HAVE_PYMONETDB?remote-table-non-existent-column.Bug-6750
 cte-union.Bug-6755
 merge-table-limit.Bug-6756
 double-free.Bug-6757
 HAVE_LIBPY3?python-loader-string.Bug-6759
 select-char.Bug-6761
-grant-select-column.Bug-6765
+KNOWNFAIL?grant-select-column.Bug-6765
 next-get-value-bulk.Bug-6766
 filter_json_null.Bug-6773
 prod-decimals.Bug-6774
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -5881,7 +5881,7 @@ drop procedure sys.times();
 set schema "sys";
 
 Running database upgrade commands:
-insert into sys.dependencies select c1, c2, c3 from 
(values(11839,11848,7),(11843,11852,7),(11597,12088,7),(11590,12088,7),(11593,12088,7),(11594,12088,7),(11595,12088,7),(11596,12088,7),(11656,12100,7),(12088,12100,7),(12092,12100,7),(25153,25155,13),(25141,25155,13),(25142,25155,13),(25143,25155,13),(25144,25155,13),(25145,25155,13),(25146,25155,13),(25147,25155,13),(25148,25155,13),(25149,25155,13),(25150,25155,13),(25151,25155,13),(25152,25155,13),(25056,25155,13),(25039,25155,13),(25040,25155,13),(25041,25155,13),(25042,25155,13),(25043,25155,13),(25044,25155,13),(25045,25155,13),(25046,25155,13),(25047,25155,13),(25048,25155,13),(25049,25155,13),(25050,25155,13),(25051,25155,13),(25052,25155,13),(25053,25155,13),(25054,25155,13),(25055,25155,13),(2079,25155,13),(2080,25155,13),(2081,25155,13),(2082,25155,13),(2083,25155,13),(2084,25155,13),(2085,25155,13),(2102,25155,13),(2103,25155,13),(2104,25155,13),(2105,25155,13),(20651,25155,13),(20652,25155,13),(20653,25155,13),(20654,2
 
5155,13),(20655,25155,13),(20656,25155,13),(20657,25155,13),(20658,25155,13),(20659,25155,13),(20660,25155,13),(2001,25155,13),(2002,25155,13),(2003,25155,13),(2004,25155,13),(2005,25155,13),(2006,25155,13),(20661,25155,13),(20662,25155,13),(20663,25155,13),(20664,25155,13),(20665,25155,13),(20666,25155,13),(20667,25155,13),(20668,25155,13),(20669,25155,13),(20670,25155,13),(20671,25155,13),(5693,5695,5),(5689,5695,5),(5690,5695,5),(5691,5695,5),(5692,5695,5),(5899,5928,5),(5968,5996,5),(6122,6136,5),(6208,6216,5),(6244,6262,5),(6282,6292,5),(12330,12350,5),(5899,12368,5),(12330,12368,5),(20651,16319,5),(20652,16319,5),(20653,16319,5),(20654,16319,5),(2001,16319,5),(2002,16319,5),(2003,16319,5),(20661,16319,5),(20663,16319,5),(20664,16319,5),(20665,16319,5),(20666,16319,5),(20667,16319,5),(2007,16319,5),(2009,16319,5),(2010,16319,5),(11577,16319,5),(11581,16319,5),(11585,16319,5),(2001,20227,5),(2002,20227,5),(2003,20227,5),(2005,20227,5),(5702,20227,5),(5703,20227,5),(5704,20227,5)
 
,(2102,20239,5),(2103,20239,5),(2104,20239,5),(2105,20239,5),(2079,20239,5),(2080,20239,5),(2081,20239,5),(2082,20239,5),(2083,20239,5),(20661,20239,5),(20662,20239,5),(20663,20239,5),(20667,20239,5),(20651,20239,5),(20652,20239,5),(20653,20239,5),(20654,20239,5),(20651,20248,5),(20652,20248,5),(20653,20248,5),(20654,20248,5),(20656,20248,5),(2046,20248,5),(2047,20248,5),(2048,20248,5),(2049,20248,5),(20651,20257,5),(20652,20257,5),(20653,20257,5),(20654,20257,5),(20656,20257,5),(2046,20257,5),(2047,20257,5),(2048,20257,5),(2049,20257,5),(20651,20268,5),(20652,20268,5),(20653,20268,5),(20654,20268,5),(20656,20268,5),(2046,20268,5),(2047,20268,5),(2048,20268,5),(2049,20268,5),(20661,20268,5),(20662,20268,5),(20663,20268,5),(20667,20268,5),(20651,20277,5),(20652,20277,5),(20653,20277,5),(20654,20277,5),(20656,20277,5),(2046,20277,5),(2047,20277,5),(2048,20277,5),(2049,20277,5),(2016,20277,5),(2017,20277,5),(2018,20277,5),(2026,20277,5),(5695,20283,5),(5696,20283,5),(5698,20283,5),(200
 
1,20283,5),(2002,20283,5),(2003,20283,5),(2016,20291,5),(2017,20291,5),(2018,20291,5),(2022,20291,5),(2046,20291,5),(2047,20291,5),(2048,20291,5),(2049,20291,5),(20651,20291,5),(20652,20291,5),(20653,20291,5),(20654,20291,5),(20656,20291,5),(2016,20299,5),(2017,20299,5),(2018,20299,5),(2022,20299,5),(2046,20299,5),(2047,20299,5),(2048,20299,5),(2049,20299,5),(20651,20299,5),(20652,20299,5),(20653,20299,5),(20654,20299,5),(20656,20299,5),(2016,20308,5),(2017,20308,5),(2018,20308,5),(2022,20308,5),(2046,20308,5),(2047,20308,5),(2048,20308,5),(2049,20308,5),(20661,20308,5),(20662,20308,5),(20663,20308,5),(20667,20308,5),(2016,20319,5),(2017,20319,5),(2018,20319,5),(2022,20319,5),(2026,20319,5),(2046,20319,5),(2047,20319,5),(2048,20319,5),(2049,20319,5),(2091,20327,5),(2092,20327,5),(2093,20327,5),(2094,20327,5),(20651,20327,5),(20652,20327,5),(20653,20327,5),(20654,20327,5),(2046,20327,5),(2047,20327,5),(2048,20327,5),(2049,20327,5),(2046,20337,5),(2047,20337,5),(2048,20337,5),(2049,20
 
337,5),(20661,20337,5),(20662,20337,5),(20663,20337,5),(20667,20337,5),(2091,20337,5),(2092,20337,5),(2093,20337,5),(20651,20337,5),(20652,20337,5),(20653,20337,5),(20654,20337,5),(2046,20347,5),(2047,20347,5),(2048,20347,5),(2049,20347,5),(2016,20347,5),(2017,20347,5),(2018,20347,5),(2022,20347,5),(2026,20347,5),(2091,20347,5),(2092,20347,5),(2093,20347,5),(2094,20347,5),(2086,20356,5),(2087,20356,5),(2088,20356,5),(2089,20356,5),(2090,20356,5),(20651,20356,5),(20652,20356,5),(20653,20356,5),(20654,20356,5),(2079,20356,5),(2081,20356,5),(2083,20356,5),(2102,20368,5),(2103,20368,5),(2104,20368,5),(2105,20368,5),(2086,20368,5),(2087,20368,5),(2088,20368,5),(2089,20368,5),(2090,20368,5),(20661,20368,5),(20662,20368,5),(20663,20368,5),(20667,20368,5),(20651,20368,5),(20652,20368,5),(20653,20368,5),(20654,20368,5),(2079,20368,5),(2081,20368,5),(2083,20368,5),(2079,20376,5),(2083,20376,5),(2084,20376,5),(2080,20376,5),(2081,20376,5),(2082,20376,5),(20651,20376,5),(20652,20376,5),(20653,2
 
0376,5),(20654,20376,5),(2079,20386,5),(2080,20386,5),(2081,20386,5),(2082,20386,5),(2083,20386,5),(2084,20386,5),(2016,20395,5),(2017,20395,5),(2018,20395,5),(2022,20395,5),(2046,20395,5),(2047,20395,5),(2048,20395,5),(2049,20395,5),(20651,20395,5),(20652,20395,5),(20653,20395,5),(20654,20395,5),(20656,20395,5),(2016,20404,5),(2017,20404,5),(2018,20404,5),(2022,20404,5),(2046,20404,5),(2047,20404,5),(2048,20404,5),(2049,20404,5),(20651,20404,5),(20652,20404,5),(20653,20404,5),(20654,20404,5),(20656,20404,5),(2016,20413,5),(2017,20413,5),(2018,20413,5),(2022,20413,5),(2046,20413,5),(2047,20413,5),(2048,20413,5),(2049,20413,5),(20661,20413,5),(20662,20413,5),(20663,20413,5),(20667,20413,5),(2016,20424,5),(2017,20424,5),(2018,20424,5),(2022,20424,5),(2026,20424,5),(2046,20424,5),(2047,20424,5),(2048,20424,5),(2049,20424,5),(2046,20434,5),(2047,20434,5),(2048,20434,5),(2049,20434,5),(2007,20434,5),(2008,20434,5),(2010,20434,5),(20661,20434,5),(20662,20434,5),(20663,20434,5),(20667,2043
 
4,5),(20651,20434,5),(20652,20434,5),(20653,20434,5),(20654,20434,5),(2046,20442,5),(2047,20442,5),(2048,20442,5),(2049,20442,5),(2007,20442,5),(2008,20442,5),(2010,20442,5),(2016,20442,5),(2017,20442,5),(2018,20442,5),(2022,20442,5),(2046,20452,5),(2047,20452,5),(2048,20452,5),(2049,20452,5),(2007,20452,5),(2008,20452,5),(2010,20452,5),(2027,20452,5),(2028,20452,5),(2029,20452,5),(2030,20452,5),(2035,20452,5),(2016,20452,5),(2017,20452,5),(2018,20452,5),(5684,20456,5),(5702,20491,5),(5703,20491,5),(5704,20491,5),(5705,20491,5),(5693,20491,5),(5702,20587,5),(5703,20587,5),(5704,20587,5),(2001,20587,5),(2002,20587,5),(2003,20587,5),(2059,20587,5),(2060,20587,5),(2061,20587,5),(2062,20587,5),(2064,20587,5),(2107,20587,5),(2108,20587,5),(2109,20587,5),(2110,20587,5),(2112,20587,5),(2068,20587,5),(2069,20587,5),(2070,20587,5),(2074,20587,5),(2116,20587,5),(2117,20587,5),(2118,20587,5),(2122,20587,5),(2079,20587,5),(2080,20587,5),(2081,20587,5),(2083,20587,5),(2127,20587,5),(2128,20587,5
 
),(2129,20587,5),(2131,20587,5),(2086,20587,5),(2087,20587,5),(2088,20587,5),(2090,20587,5),(2134,20587,5),(2135,20587,5),(2136,20587,5),(2138,20587,5),(2091,20587,5),(2092,20587,5),(2093,20587,5),(2094,20587,5),(2139,20587,5),(2140,20587,5),(2141,20587,5),(2142,20587,5),(2016,20587,5),(2017,20587,5),(2018,20587,5),(2022,20587,5),(2026,20587,5),(2027,20587,5),(2028,20587,5),(2029,20587,5),(2030,20587,5),(2036,20587,5),(2037,20587,5),(2038,20587,5),(2039,20587,5),(2007,20587,5),(2008,20587,5),(2010,20587,5),(2015,20587,5),(2046,20597,5),(2047,20597,5),(2048,20597,5),(2049,20597,5),(6966,20597,5),(6960,20597,5),(6963,20597,5),(20587,20597,5),(20580,20597,5),(20581,20597,5),(20585,20597,5),(2059,20651,5),(2060,20651,5),(2061,20651,5),(2062,20651,5),(2063,20651,5),(2064,20651,5),(2065,20651,5),(2066,20651,5),(2067,20651,5),(2107,20651,5),(2108,20651,5),(2109,20651,5),(2110,20651,5),(2111,20651,5),(2112,20651,5),(2113,20651,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dep
 endencies where depend_id = t1.c2);
+insert into sys.dependencies select c1, c2, c3 from 
(values(11839,11848,7),(11843,11852,7),(11597,12088,7),(11590,12088,7),(11593,12088,7),(11594,12088,7),(11595,12088,7),(11596,12088,7),(11656,12100,7),(12088,12100,7),(12092,12100,7),(25153,25155,13),(25141,25155,13),(25142,25155,13),(25143,25155,13),(25144,25155,13),(25145,25155,13),(25146,25155,13),(25147,25155,13),(25148,25155,13),(25149,25155,13),(25150,25155,13),(25151,25155,13),(25152,25155,13),(25056,25155,13),(25039,25155,13),(25040,25155,13),(25041,25155,13),(25042,25155,13),(25043,25155,13),(25044,25155,13),(25045,25155,13),(25046,25155,13),(25047,25155,13),(25048,25155,13),(25049,25155,13),(25050,25155,13),(25051,25155,13),(25052,25155,13),(25053,25155,13),(25054,25155,13),(25055,25155,13),(2079,25155,13),(2080,25155,13),(2081,25155,13),(2082,25155,13),(2083,25155,13),(2084,25155,13),(2085,25155,13),(2102,25155,13),(2103,25155,13),(2104,25155,13),(2105,25155,13),(20651,25155,13),(20652,25155,13),(20653,25155,13),(20654,2
 
5155,13),(20655,25155,13),(20656,25155,13),(20657,25155,13),(20658,25155,13),(20659,25155,13),(20660,25155,13),(2001,25155,13),(2002,25155,13),(2003,25155,13),(2004,25155,13),(2005,25155,13),(2006,25155,13),(20661,25155,13),(20662,25155,13),(20663,25155,13),(20664,25155,13),(20665,25155,13),(20666,25155,13),(20667,25155,13),(20668,25155,13),(20669,25155,13),(20670,25155,13),(20671,25155,13),(5693,5695,5),(5689,5695,5),(5690,5695,5),(5691,5695,5),(5692,5695,5),(5899,5928,5),(5968,5996,5),(6122,6136,5),(6208,6216,5),(6244,6262,5),(6282,6292,5),(12330,12350,5),(5899,12368,5),(12330,12368,5),(20651,16319,5),(20652,16319,5),(20653,16319,5),(20654,16319,5),(2001,16319,5),(2002,16319,5),(2003,16319,5),(20661,16319,5),(20663,16319,5),(20664,16319,5),(20665,16319,5),(20666,16319,5),(20667,16319,5),(2007,16319,5),(2009,16319,5),(2010,16319,5),(11577,16319,5),(11581,16319,5),(11585,16319,5),(2001,20227,5),(2002,20227,5),(2003,20227,5),(2005,20227,5),(5702,20227,5),(5703,20227,5),(5704,20227,5)
 
,(2102,20239,5),(2103,20239,5),(2104,20239,5),(2105,20239,5),(2079,20239,5),(2080,20239,5),(2081,20239,5),(2082,20239,5),(2083,20239,5),(20661,20239,5),(20662,20239,5),(20663,20239,5),(20667,20239,5),(20651,20239,5),(20652,20239,5),(20653,20239,5),(20654,20239,5),(20651,20248,5),(20652,20248,5),(20653,20248,5),(20654,20248,5),(20656,20248,5),(2046,20248,5),(2047,20248,5),(2048,20248,5),(2049,20248,5),(20651,20257,5),(20652,20257,5),(20653,20257,5),(20654,20257,5),(20656,20257,5),(2046,20257,5),(2047,20257,5),(2048,20257,5),(2049,20257,5),(20651,20268,5),(20652,20268,5),(20653,20268,5),(20654,20268,5),(20656,20268,5),(2046,20268,5),(2047,20268,5),(2048,20268,5),(2049,20268,5),(20661,20268,5),(20662,20268,5),(20663,20268,5),(20667,20268,5),(20651,20277,5),(20652,20277,5),(20653,20277,5),(20654,20277,5),(20656,20277,5),(2046,20277,5),(2047,20277,5),(2048,20277,5),(2049,20277,5),(2016,20277,5),(2017,20277,5),(2018,20277,5),(2026,20277,5),(5695,20283,5),(5696,20283,5),(5698,20283,5),(200
 
1,20283,5),(2002,20283,5),(2003,20283,5),(20651,20291,5),(20652,20291,5),(20653,20291,5),(20654,20291,5),(20656,20291,5),(2046,20291,5),(2047,20291,5),(2048,20291,5),(2049,20291,5),(2016,20291,5),(2017,20291,5),(2018,20291,5),(2022,20291,5),(20651,20299,5),(20652,20299,5),(20653,20299,5),(20654,20299,5),(20656,20299,5),(2046,20299,5),(2047,20299,5),(2048,20299,5),(2049,20299,5),(2016,20299,5),(2017,20299,5),(2018,20299,5),(2022,20299,5),(2016,20308,5),(2017,20308,5),(2018,20308,5),(2022,20308,5),(2046,20308,5),(2047,20308,5),(2048,20308,5),(2049,20308,5),(20661,20308,5),(20662,20308,5),(20663,20308,5),(20667,20308,5),(2016,20319,5),(2017,20319,5),(2018,20319,5),(2022,20319,5),(2026,20319,5),(2046,20319,5),(2047,20319,5),(2048,20319,5),(2049,20319,5),(2091,20327,5),(2092,20327,5),(2093,20327,5),(2094,20327,5),(20651,20327,5),(20652,20327,5),(20653,20327,5),(20654,20327,5),(2046,20327,5),(2047,20327,5),(2048,20327,5),(2049,20327,5),(2046,20337,5),(2047,20337,5),(2048,20337,5),(2049,20
 
337,5),(20661,20337,5),(20662,20337,5),(20663,20337,5),(20667,20337,5),(2091,20337,5),(2092,20337,5),(2093,20337,5),(20651,20337,5),(20652,20337,5),(20653,20337,5),(20654,20337,5),(2046,20347,5),(2047,20347,5),(2048,20347,5),(2049,20347,5),(2016,20347,5),(2017,20347,5),(2018,20347,5),(2022,20347,5),(2026,20347,5),(2091,20347,5),(2092,20347,5),(2093,20347,5),(2094,20347,5),(2086,20356,5),(2087,20356,5),(2088,20356,5),(2089,20356,5),(2090,20356,5),(20651,20356,5),(20652,20356,5),(20653,20356,5),(20654,20356,5),(2079,20356,5),(2081,20356,5),(2083,20356,5),(2102,20368,5),(2103,20368,5),(2104,20368,5),(2105,20368,5),(2086,20368,5),(2087,20368,5),(2088,20368,5),(2089,20368,5),(2090,20368,5),(20661,20368,5),(20662,20368,5),(20663,20368,5),(20667,20368,5),(20651,20368,5),(20652,20368,5),(20653,20368,5),(20654,20368,5),(2079,20368,5),(2081,20368,5),(2083,20368,5),(2079,20376,5),(2083,20376,5),(2084,20376,5),(2080,20376,5),(2081,20376,5),(2082,20376,5),(20651,20376,5),(20652,20376,5),(20653,2
 
0376,5),(20654,20376,5),(2079,20386,5),(2080,20386,5),(2081,20386,5),(2082,20386,5),(2083,20386,5),(2084,20386,5),(20651,20395,5),(20652,20395,5),(20653,20395,5),(20654,20395,5),(20656,20395,5),(2046,20395,5),(2047,20395,5),(2048,20395,5),(2049,20395,5),(2016,20395,5),(2017,20395,5),(2018,20395,5),(2022,20395,5),(20651,20404,5),(20652,20404,5),(20653,20404,5),(20654,20404,5),(20656,20404,5),(2046,20404,5),(2047,20404,5),(2048,20404,5),(2049,20404,5),(2016,20404,5),(2017,20404,5),(2018,20404,5),(2022,20404,5),(2016,20413,5),(2017,20413,5),(2018,20413,5),(2022,20413,5),(2046,20413,5),(2047,20413,5),(2048,20413,5),(2049,20413,5),(20661,20413,5),(20662,20413,5),(20663,20413,5),(20667,20413,5),(2016,20424,5),(2017,20424,5),(2018,20424,5),(2022,20424,5),(2026,20424,5),(2046,20424,5),(2047,20424,5),(2048,20424,5),(2049,20424,5),(2046,20434,5),(2047,20434,5),(2048,20434,5),(2049,20434,5),(2007,20434,5),(2008,20434,5),(2010,20434,5),(20661,20434,5),(20662,20434,5),(20663,20434,5),(20667,2043
 
4,5),(20651,20434,5),(20652,20434,5),(20653,20434,5),(20654,20434,5),(2046,20442,5),(2047,20442,5),(2048,20442,5),(2049,20442,5),(2007,20442,5),(2008,20442,5),(2010,20442,5),(2016,20442,5),(2017,20442,5),(2018,20442,5),(2022,20442,5),(2046,20452,5),(2047,20452,5),(2048,20452,5),(2049,20452,5),(2007,20452,5),(2008,20452,5),(2010,20452,5),(2027,20452,5),(2028,20452,5),(2029,20452,5),(2030,20452,5),(2035,20452,5),(2016,20452,5),(2017,20452,5),(2018,20452,5),(5684,20456,5),(5702,20491,5),(5703,20491,5),(5704,20491,5),(5705,20491,5),(5693,20491,5),(5702,20587,5),(5703,20587,5),(5704,20587,5),(2001,20587,5),(2002,20587,5),(2003,20587,5),(2059,20587,5),(2060,20587,5),(2061,20587,5),(2062,20587,5),(2064,20587,5),(2107,20587,5),(2108,20587,5),(2109,20587,5),(2110,20587,5),(2112,20587,5),(2068,20587,5),(2069,20587,5),(2070,20587,5),(2074,20587,5),(2116,20587,5),(2117,20587,5),(2118,20587,5),(2122,20587,5),(2079,20587,5),(2080,20587,5),(2081,20587,5),(2083,20587,5),(2127,20587,5),(2128,20587,5
 
),(2129,20587,5),(2131,20587,5),(2086,20587,5),(2087,20587,5),(2088,20587,5),(2090,20587,5),(2134,20587,5),(2135,20587,5),(2136,20587,5),(2138,20587,5),(2091,20587,5),(2092,20587,5),(2093,20587,5),(2094,20587,5),(2139,20587,5),(2140,20587,5),(2141,20587,5),(2142,20587,5),(2016,20587,5),(2017,20587,5),(2018,20587,5),(2022,20587,5),(2026,20587,5),(2027,20587,5),(2028,20587,5),(2029,20587,5),(2030,20587,5),(2036,20587,5),(2037,20587,5),(2038,20587,5),(2039,20587,5),(2007,20587,5),(2008,20587,5),(2010,20587,5),(2015,20587,5),(2046,20597,5),(2047,20597,5),(2048,20597,5),(2049,20597,5),(6966,20597,5),(6960,20597,5),(6963,20597,5),(20587,20597,5),(20580,20597,5),(20581,20597,5),(20585,20597,5),(2059,20651,5),(2060,20651,5),(2061,20651,5),(2062,20651,5),(2063,20651,5),(2064,20651,5),(2065,20651,5),(2066,20651,5),(2067,20651,5),(2107,20651,5),(2108,20651,5),(2109,20651,5),(2110,20651,5),(2111,20651,5),(2112,20651,5),(2113,20651,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dep
 endencies where depend_id = t1.c2);
 
 Running database upgrade commands:
 insert into sys.dependencies select c1, c2, c3 from 
(values(2114,20651,5),(2115,20651,5),(2068,20661,5),(2069,20661,5),(2070,20661,5),(2071,20661,5),(2072,20661,5),(2073,20661,5),(2074,20661,5),(2075,20661,5),(2076,20661,5),(2077,20661,5),(2078,20661,5),(2116,20661,5),(2117,20661,5),(2118,20661,5),(2119,20661,5),(2120,20661,5),(2121,20661,5),(2122,20661,5),(2123,20661,5),(2124,20661,5),(2125,20661,5),(2126,20661,5),(2016,25018,5),(2017,25018,5),(20634,25018,5),(25020,25056,5),(20651,25056,5),(20653,25056,5),(20654,25056,5),(20657,25056,5),(2001,25056,5),(2002,25056,5),(2003,25056,5),(25056,25067,5),(25039,25067,5),(25040,25067,5),(25045,25067,5),(25047,25067,5),(25048,25067,5),(25049,25067,5),(25051,25067,5),(25055,25067,5),(25056,25076,5),(25039,25076,5),(25047,25076,5),(25048,25076,5),(25049,25076,5),(25051,25076,5),(25055,25076,5),(25153,25192,5),(25141,25192,5),(25142,25192,5),(25143,25192,5),(25144,25192,5),(25146,25192,5),(25147,25192,5),(25148,25192,5),(25149,25192,5),(25150,
 
25192,5),(25151,25192,5),(25152,25192,5),(25157,25192,5),(25162,25192,5),(25169,25192,5),(25174,25192,5),(25153,25203,5),(25141,25203,5),(25142,25203,5),(25144,25203,5),(25146,25203,5),(25147,25203,5),(25148,25203,5),(25149,25203,5),(25150,25203,5),(25152,25203,5),(25157,25203,5),(25162,25203,5),(25169,25203,5),(25174,25203,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dependencies where 
depend_id = t1.c2);
@@ -6004,6 +6004,43 @@ update sys.functions set system = true w
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlc') and name in ('master', 'stop', 'flush', 'beat') 
and type = 2;
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlr') and name in ('clock', 'tick') and type = 1;
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlr') and name in ('master', 'stop', 'accept', 
'replicate', 'beat') and type = 2;
+create aggregate stddev_samp(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."stdev";
+GRANT EXECUTE ON AGGREGATE stddev_samp(INTERVAL SECOND) TO PUBLIC;
+create aggregate stddev_samp(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."stdev";
+GRANT EXECUTE ON AGGREGATE stddev_samp(INTERVAL MONTH) TO PUBLIC;
+create aggregate stddev_pop(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."stdevp";
+GRANT EXECUTE ON AGGREGATE stddev_pop(INTERVAL SECOND) TO PUBLIC;
+create aggregate stddev_pop(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."stdevp";
+GRANT EXECUTE ON AGGREGATE stddev_pop(INTERVAL MONTH) TO PUBLIC;
+create aggregate var_samp(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."variance";
+GRANT EXECUTE ON AGGREGATE var_samp(INTERVAL SECOND) TO PUBLIC;
+create aggregate var_samp(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."variance";
+GRANT EXECUTE ON AGGREGATE var_samp(INTERVAL MONTH) TO PUBLIC;
+create aggregate var_pop(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."variancep";
+GRANT EXECUTE ON AGGREGATE var_pop(INTERVAL SECOND) TO PUBLIC;
+create aggregate var_pop(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."variancep";
+GRANT EXECUTE ON AGGREGATE var_pop(INTERVAL MONTH) TO PUBLIC;
+create aggregate median(val INTERVAL SECOND) returns INTERVAL SECOND
+external name "aggr"."median";
+GRANT EXECUTE ON AGGREGATE median(INTERVAL SECOND) TO PUBLIC;
+create aggregate median(val INTERVAL MONTH) returns INTERVAL MONTH
+external name "aggr"."median";
+GRANT EXECUTE ON AGGREGATE median(INTERVAL MONTH) TO PUBLIC;
+create aggregate quantile(val INTERVAL SECOND, q DOUBLE) returns INTERVAL 
SECOND
+external name "aggr"."quantile";
+GRANT EXECUTE ON AGGREGATE quantile(INTERVAL SECOND, DOUBLE) TO PUBLIC;
+create aggregate quantile(val INTERVAL MONTH, q DOUBLE) returns INTERVAL MONTH
+external name "aggr"."quantile";
+GRANT EXECUTE ON AGGREGATE quantile(INTERVAL MONTH, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'sys') and name in ('stddev_samp', 'stddev_pop', 
'var_samp', 'var_pop', 'median', 'quantile') and type = 3;
 drop function json.text(string);
 drop function json.text(int);
 update "sys"."args" set "type" = 'ptr' where "func_id" = (select "id" from 
"sys"."functions" where "name" = 'copyfrom' and "func" = 'copy_from' and "mod" 
= 'sql') and "name" = 'arg_1';
diff --git 
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128 
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
--- 
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
+++ 
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
@@ -5881,7 +5881,7 @@ drop procedure sys.times();
 set schema "sys";
 
 Running database upgrade commands:
-insert into sys.dependencies select c1, c2, c3 from 
(values(11834,11843,7),(11838,11847,7),(11592,12083,7),(11585,12083,7),(11588,12083,7),(11589,12083,7),(11590,12083,7),(11591,12083,7),(11651,12095,7),(12083,12095,7),(12087,12095,7),(25148,25150,13),(25136,25150,13),(25137,25150,13),(25138,25150,13),(25139,25150,13),(25140,25150,13),(25141,25150,13),(25142,25150,13),(25143,25150,13),(25144,25150,13),(25145,25150,13),(25146,25150,13),(25147,25150,13),(25051,25150,13),(25034,25150,13),(25035,25150,13),(25036,25150,13),(25037,25150,13),(25038,25150,13),(25039,25150,13),(25040,25150,13),(25041,25150,13),(25042,25150,13),(25043,25150,13),(25044,25150,13),(25045,25150,13),(25046,25150,13),(25047,25150,13),(25048,25150,13),(25049,25150,13),(25050,25150,13),(2079,25150,13),(2080,25150,13),(2081,25150,13),(2082,25150,13),(2083,25150,13),(2084,25150,13),(2085,25150,13),(2102,25150,13),(2103,25150,13),(2104,25150,13),(2105,25150,13),(20646,25150,13),(20647,25150,13),(20648,25150,13),(20649,2
 
5150,13),(20650,25150,13),(20651,25150,13),(20652,25150,13),(20653,25150,13),(20654,25150,13),(20655,25150,13),(2001,25150,13),(2002,25150,13),(2003,25150,13),(2004,25150,13),(2005,25150,13),(2006,25150,13),(20656,25150,13),(20657,25150,13),(20658,25150,13),(20659,25150,13),(20660,25150,13),(20661,25150,13),(20662,25150,13),(20663,25150,13),(20664,25150,13),(20665,25150,13),(20666,25150,13),(5693,5695,5),(5689,5695,5),(5690,5695,5),(5691,5695,5),(5692,5695,5),(5899,5928,5),(5968,5996,5),(6122,6136,5),(6208,6216,5),(6244,6262,5),(6282,6292,5),(12325,12345,5),(5899,12363,5),(12325,12363,5),(20646,16314,5),(20647,16314,5),(20648,16314,5),(20649,16314,5),(2001,16314,5),(2002,16314,5),(2003,16314,5),(20656,16314,5),(20658,16314,5),(20659,16314,5),(20660,16314,5),(20661,16314,5),(20662,16314,5),(2007,16314,5),(2009,16314,5),(2010,16314,5),(11572,16314,5),(11576,16314,5),(11580,16314,5),(2001,20222,5),(2002,20222,5),(2003,20222,5),(2005,20222,5),(5702,20222,5),(5703,20222,5),(5704,20222,5)
 
,(2102,20234,5),(2103,20234,5),(2104,20234,5),(2105,20234,5),(2079,20234,5),(2080,20234,5),(2081,20234,5),(2082,20234,5),(2083,20234,5),(20656,20234,5),(20657,20234,5),(20658,20234,5),(20662,20234,5),(20646,20234,5),(20647,20234,5),(20648,20234,5),(20649,20234,5),(20646,20243,5),(20647,20243,5),(20648,20243,5),(20649,20243,5),(20651,20243,5),(2046,20243,5),(2047,20243,5),(2048,20243,5),(2049,20243,5),(20646,20252,5),(20647,20252,5),(20648,20252,5),(20649,20252,5),(20651,20252,5),(2046,20252,5),(2047,20252,5),(2048,20252,5),(2049,20252,5),(20646,20263,5),(20647,20263,5),(20648,20263,5),(20649,20263,5),(20651,20263,5),(2046,20263,5),(2047,20263,5),(2048,20263,5),(2049,20263,5),(20656,20263,5),(20657,20263,5),(20658,20263,5),(20662,20263,5),(20646,20272,5),(20647,20272,5),(20648,20272,5),(20649,20272,5),(20651,20272,5),(2046,20272,5),(2047,20272,5),(2048,20272,5),(2049,20272,5),(2016,20272,5),(2017,20272,5),(2018,20272,5),(2026,20272,5),(5695,20278,5),(5696,20278,5),(5698,20278,5),(200
 
1,20278,5),(2002,20278,5),(2003,20278,5),(2016,20286,5),(2017,20286,5),(2018,20286,5),(2022,20286,5),(2046,20286,5),(2047,20286,5),(2048,20286,5),(2049,20286,5),(20646,20286,5),(20647,20286,5),(20648,20286,5),(20649,20286,5),(20651,20286,5),(2016,20294,5),(2017,20294,5),(2018,20294,5),(2022,20294,5),(2046,20294,5),(2047,20294,5),(2048,20294,5),(2049,20294,5),(20646,20294,5),(20647,20294,5),(20648,20294,5),(20649,20294,5),(20651,20294,5),(2016,20303,5),(2017,20303,5),(2018,20303,5),(2022,20303,5),(2046,20303,5),(2047,20303,5),(2048,20303,5),(2049,20303,5),(20656,20303,5),(20657,20303,5),(20658,20303,5),(20662,20303,5),(2016,20314,5),(2017,20314,5),(2018,20314,5),(2022,20314,5),(2026,20314,5),(2046,20314,5),(2047,20314,5),(2048,20314,5),(2049,20314,5),(2091,20322,5),(2092,20322,5),(2093,20322,5),(2094,20322,5),(20646,20322,5),(20647,20322,5),(20648,20322,5),(20649,20322,5),(2046,20322,5),(2047,20322,5),(2048,20322,5),(2049,20322,5),(2046,20332,5),(2047,20332,5),(2048,20332,5),(2049,20
 
332,5),(20656,20332,5),(20657,20332,5),(20658,20332,5),(20662,20332,5),(2091,20332,5),(2092,20332,5),(2093,20332,5),(20646,20332,5),(20647,20332,5),(20648,20332,5),(20649,20332,5),(2046,20342,5),(2047,20342,5),(2048,20342,5),(2049,20342,5),(2016,20342,5),(2017,20342,5),(2018,20342,5),(2022,20342,5),(2026,20342,5),(2091,20342,5),(2092,20342,5),(2093,20342,5),(2094,20342,5),(2086,20351,5),(2087,20351,5),(2088,20351,5),(2089,20351,5),(2090,20351,5),(20646,20351,5),(20647,20351,5),(20648,20351,5),(20649,20351,5),(2079,20351,5),(2081,20351,5),(2083,20351,5),(2102,20363,5),(2103,20363,5),(2104,20363,5),(2105,20363,5),(2086,20363,5),(2087,20363,5),(2088,20363,5),(2089,20363,5),(2090,20363,5),(20656,20363,5),(20657,20363,5),(20658,20363,5),(20662,20363,5),(20646,20363,5),(20647,20363,5),(20648,20363,5),(20649,20363,5),(2079,20363,5),(2081,20363,5),(2083,20363,5),(2079,20371,5),(2083,20371,5),(2084,20371,5),(2080,20371,5),(2081,20371,5),(2082,20371,5),(20646,20371,5),(20647,20371,5),(20648,2
 
0371,5),(20649,20371,5),(2079,20381,5),(2080,20381,5),(2081,20381,5),(2082,20381,5),(2083,20381,5),(2084,20381,5),(2016,20390,5),(2017,20390,5),(2018,20390,5),(2022,20390,5),(2046,20390,5),(2047,20390,5),(2048,20390,5),(2049,20390,5),(20646,20390,5),(20647,20390,5),(20648,20390,5),(20649,20390,5),(20651,20390,5),(2016,20399,5),(2017,20399,5),(2018,20399,5),(2022,20399,5),(2046,20399,5),(2047,20399,5),(2048,20399,5),(2049,20399,5),(20646,20399,5),(20647,20399,5),(20648,20399,5),(20649,20399,5),(20651,20399,5),(2016,20408,5),(2017,20408,5),(2018,20408,5),(2022,20408,5),(2046,20408,5),(2047,20408,5),(2048,20408,5),(2049,20408,5),(20656,20408,5),(20657,20408,5),(20658,20408,5),(20662,20408,5),(2016,20419,5),(2017,20419,5),(2018,20419,5),(2022,20419,5),(2026,20419,5),(2046,20419,5),(2047,20419,5),(2048,20419,5),(2049,20419,5),(2046,20429,5),(2047,20429,5),(2048,20429,5),(2049,20429,5),(2007,20429,5),(2008,20429,5),(2010,20429,5),(20656,20429,5),(20657,20429,5),(20658,20429,5),(20662,2042
 
9,5),(20646,20429,5),(20647,20429,5),(20648,20429,5),(20649,20429,5),(2046,20437,5),(2047,20437,5),(2048,20437,5),(2049,20437,5),(2007,20437,5),(2008,20437,5),(2010,20437,5),(2016,20437,5),(2017,20437,5),(2018,20437,5),(2022,20437,5),(2046,20447,5),(2047,20447,5),(2048,20447,5),(2049,20447,5),(2007,20447,5),(2008,20447,5),(2010,20447,5),(2027,20447,5),(2028,20447,5),(2029,20447,5),(2030,20447,5),(2035,20447,5),(2016,20447,5),(2017,20447,5),(2018,20447,5),(5684,20451,5),(5702,20486,5),(5703,20486,5),(5704,20486,5),(5705,20486,5),(5693,20486,5),(5702,20582,5),(5703,20582,5),(5704,20582,5),(2001,20582,5),(2002,20582,5),(2003,20582,5),(2059,20582,5),(2060,20582,5),(2061,20582,5),(2062,20582,5),(2064,20582,5),(2107,20582,5),(2108,20582,5),(2109,20582,5),(2110,20582,5),(2112,20582,5),(2068,20582,5),(2069,20582,5),(2070,20582,5),(2074,20582,5),(2116,20582,5),(2117,20582,5),(2118,20582,5),(2122,20582,5),(2079,20582,5),(2080,20582,5),(2081,20582,5),(2083,20582,5),(2127,20582,5),(2128,20582,5
 
),(2129,20582,5),(2131,20582,5),(2086,20582,5),(2087,20582,5),(2088,20582,5),(2090,20582,5),(2134,20582,5),(2135,20582,5),(2136,20582,5),(2138,20582,5),(2091,20582,5),(2092,20582,5),(2093,20582,5),(2094,20582,5),(2139,20582,5),(2140,20582,5),(2141,20582,5),(2142,20582,5),(2016,20582,5),(2017,20582,5),(2018,20582,5),(2022,20582,5),(2026,20582,5),(2027,20582,5),(2028,20582,5),(2029,20582,5),(2030,20582,5),(2036,20582,5),(2037,20582,5),(2038,20582,5),(2039,20582,5),(2007,20582,5),(2008,20582,5),(2010,20582,5),(2015,20582,5),(2046,20592,5),(2047,20592,5),(2048,20592,5),(2049,20592,5),(6961,20592,5),(6955,20592,5),(6958,20592,5),(20582,20592,5),(20575,20592,5),(20576,20592,5),(20580,20592,5),(2059,20646,5),(2060,20646,5),(2061,20646,5),(2062,20646,5),(2063,20646,5),(2064,20646,5),(2065,20646,5),(2066,20646,5),(2067,20646,5),(2107,20646,5),(2108,20646,5),(2109,20646,5),(2110,20646,5),(2111,20646,5),(2112,20646,5),(2113,20646,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dep
 endencies where depend_id = t1.c2);
+insert into sys.dependencies select c1, c2, c3 from 
(values(11834,11843,7),(11838,11847,7),(11592,12083,7),(11585,12083,7),(11588,12083,7),(11589,12083,7),(11590,12083,7),(11591,12083,7),(11651,12095,7),(12083,12095,7),(12087,12095,7),(25148,25150,13),(25136,25150,13),(25137,25150,13),(25138,25150,13),(25139,25150,13),(25140,25150,13),(25141,25150,13),(25142,25150,13),(25143,25150,13),(25144,25150,13),(25145,25150,13),(25146,25150,13),(25147,25150,13),(25051,25150,13),(25034,25150,13),(25035,25150,13),(25036,25150,13),(25037,25150,13),(25038,25150,13),(25039,25150,13),(25040,25150,13),(25041,25150,13),(25042,25150,13),(25043,25150,13),(25044,25150,13),(25045,25150,13),(25046,25150,13),(25047,25150,13),(25048,25150,13),(25049,25150,13),(25050,25150,13),(2079,25150,13),(2080,25150,13),(2081,25150,13),(2082,25150,13),(2083,25150,13),(2084,25150,13),(2085,25150,13),(2102,25150,13),(2103,25150,13),(2104,25150,13),(2105,25150,13),(20646,25150,13),(20647,25150,13),(20648,25150,13),(20649,2
 
5150,13),(20650,25150,13),(20651,25150,13),(20652,25150,13),(20653,25150,13),(20654,25150,13),(20655,25150,13),(2001,25150,13),(2002,25150,13),(2003,25150,13),(2004,25150,13),(2005,25150,13),(2006,25150,13),(20656,25150,13),(20657,25150,13),(20658,25150,13),(20659,25150,13),(20660,25150,13),(20661,25150,13),(20662,25150,13),(20663,25150,13),(20664,25150,13),(20665,25150,13),(20666,25150,13),(5693,5695,5),(5689,5695,5),(5690,5695,5),(5691,5695,5),(5692,5695,5),(5899,5928,5),(5968,5996,5),(6122,6136,5),(6208,6216,5),(6244,6262,5),(6282,6292,5),(12325,12345,5),(5899,12363,5),(12325,12363,5),(20646,16314,5),(20647,16314,5),(20648,16314,5),(20649,16314,5),(2001,16314,5),(2002,16314,5),(2003,16314,5),(20656,16314,5),(20658,16314,5),(20659,16314,5),(20660,16314,5),(20661,16314,5),(20662,16314,5),(2007,16314,5),(2009,16314,5),(2010,16314,5),(11572,16314,5),(11576,16314,5),(11580,16314,5),(2001,20222,5),(2002,20222,5),(2003,20222,5),(2005,20222,5),(5702,20222,5),(5703,20222,5),(5704,20222,5)
 
,(2102,20234,5),(2103,20234,5),(2104,20234,5),(2105,20234,5),(2079,20234,5),(2080,20234,5),(2081,20234,5),(2082,20234,5),(2083,20234,5),(20656,20234,5),(20657,20234,5),(20658,20234,5),(20662,20234,5),(20646,20234,5),(20647,20234,5),(20648,20234,5),(20649,20234,5),(20646,20243,5),(20647,20243,5),(20648,20243,5),(20649,20243,5),(20651,20243,5),(2046,20243,5),(2047,20243,5),(2048,20243,5),(2049,20243,5),(20646,20252,5),(20647,20252,5),(20648,20252,5),(20649,20252,5),(20651,20252,5),(2046,20252,5),(2047,20252,5),(2048,20252,5),(2049,20252,5),(20646,20263,5),(20647,20263,5),(20648,20263,5),(20649,20263,5),(20651,20263,5),(2046,20263,5),(2047,20263,5),(2048,20263,5),(2049,20263,5),(20656,20263,5),(20657,20263,5),(20658,20263,5),(20662,20263,5),(20646,20272,5),(20647,20272,5),(20648,20272,5),(20649,20272,5),(20651,20272,5),(2046,20272,5),(2047,20272,5),(2048,20272,5),(2049,20272,5),(2016,20272,5),(2017,20272,5),(2018,20272,5),(2026,20272,5),(5695,20278,5),(5696,20278,5),(5698,20278,5),(200
 
1,20278,5),(2002,20278,5),(2003,20278,5),(20646,20286,5),(20647,20286,5),(20648,20286,5),(20649,20286,5),(20651,20286,5),(2046,20286,5),(2047,20286,5),(2048,20286,5),(2049,20286,5),(2016,20286,5),(2017,20286,5),(2018,20286,5),(2022,20286,5),(20646,20294,5),(20647,20294,5),(20648,20294,5),(20649,20294,5),(20651,20294,5),(2046,20294,5),(2047,20294,5),(2048,20294,5),(2049,20294,5),(2016,20294,5),(2017,20294,5),(2018,20294,5),(2022,20294,5),(2016,20303,5),(2017,20303,5),(2018,20303,5),(2022,20303,5),(2046,20303,5),(2047,20303,5),(2048,20303,5),(2049,20303,5),(20656,20303,5),(20657,20303,5),(20658,20303,5),(20662,20303,5),(2016,20314,5),(2017,20314,5),(2018,20314,5),(2022,20314,5),(2026,20314,5),(2046,20314,5),(2047,20314,5),(2048,20314,5),(2049,20314,5),(2091,20322,5),(2092,20322,5),(2093,20322,5),(2094,20322,5),(20646,20322,5),(20647,20322,5),(20648,20322,5),(20649,20322,5),(2046,20322,5),(2047,20322,5),(2048,20322,5),(2049,20322,5),(2046,20332,5),(2047,20332,5),(2048,20332,5),(2049,20
 
332,5),(20656,20332,5),(20657,20332,5),(20658,20332,5),(20662,20332,5),(2091,20332,5),(2092,20332,5),(2093,20332,5),(20646,20332,5),(20647,20332,5),(20648,20332,5),(20649,20332,5),(2046,20342,5),(2047,20342,5),(2048,20342,5),(2049,20342,5),(2016,20342,5),(2017,20342,5),(2018,20342,5),(2022,20342,5),(2026,20342,5),(2091,20342,5),(2092,20342,5),(2093,20342,5),(2094,20342,5),(2086,20351,5),(2087,20351,5),(2088,20351,5),(2089,20351,5),(2090,20351,5),(20646,20351,5),(20647,20351,5),(20648,20351,5),(20649,20351,5),(2079,20351,5),(2081,20351,5),(2083,20351,5),(2102,20363,5),(2103,20363,5),(2104,20363,5),(2105,20363,5),(2086,20363,5),(2087,20363,5),(2088,20363,5),(2089,20363,5),(2090,20363,5),(20656,20363,5),(20657,20363,5),(20658,20363,5),(20662,20363,5),(20646,20363,5),(20647,20363,5),(20648,20363,5),(20649,20363,5),(2079,20363,5),(2081,20363,5),(2083,20363,5),(2079,20371,5),(2083,20371,5),(2084,20371,5),(2080,20371,5),(2081,20371,5),(2082,20371,5),(20646,20371,5),(20647,20371,5),(20648,2
 
0371,5),(20649,20371,5),(2079,20381,5),(2080,20381,5),(2081,20381,5),(2082,20381,5),(2083,20381,5),(2084,20381,5),(20646,20390,5),(20647,20390,5),(20648,20390,5),(20649,20390,5),(20651,20390,5),(2046,20390,5),(2047,20390,5),(2048,20390,5),(2049,20390,5),(2016,20390,5),(2017,20390,5),(2018,20390,5),(2022,20390,5),(20646,20399,5),(20647,20399,5),(20648,20399,5),(20649,20399,5),(20651,20399,5),(2046,20399,5),(2047,20399,5),(2048,20399,5),(2049,20399,5),(2016,20399,5),(2017,20399,5),(2018,20399,5),(2022,20399,5),(2016,20408,5),(2017,20408,5),(2018,20408,5),(2022,20408,5),(2046,20408,5),(2047,20408,5),(2048,20408,5),(2049,20408,5),(20656,20408,5),(20657,20408,5),(20658,20408,5),(20662,20408,5),(2016,20419,5),(2017,20419,5),(2018,20419,5),(2022,20419,5),(2026,20419,5),(2046,20419,5),(2047,20419,5),(2048,20419,5),(2049,20419,5),(2046,20429,5),(2047,20429,5),(2048,20429,5),(2049,20429,5),(2007,20429,5),(2008,20429,5),(2010,20429,5),(20656,20429,5),(20657,20429,5),(20658,20429,5),(20662,2042
 
9,5),(20646,20429,5),(20647,20429,5),(20648,20429,5),(20649,20429,5),(2046,20437,5),(2047,20437,5),(2048,20437,5),(2049,20437,5),(2007,20437,5),(2008,20437,5),(2010,20437,5),(2016,20437,5),(2017,20437,5),(2018,20437,5),(2022,20437,5),(2046,20447,5),(2047,20447,5),(2048,20447,5),(2049,20447,5),(2007,20447,5),(2008,20447,5),(2010,20447,5),(2027,20447,5),(2028,20447,5),(2029,20447,5),(2030,20447,5),(2035,20447,5),(2016,20447,5),(2017,20447,5),(2018,20447,5),(5684,20451,5),(5702,20486,5),(5703,20486,5),(5704,20486,5),(5705,20486,5),(5693,20486,5),(5702,20582,5),(5703,20582,5),(5704,20582,5),(2001,20582,5),(2002,20582,5),(2003,20582,5),(2059,20582,5),(2060,20582,5),(2061,20582,5),(2062,20582,5),(2064,20582,5),(2107,20582,5),(2108,20582,5),(2109,20582,5),(2110,20582,5),(2112,20582,5),(2068,20582,5),(2069,20582,5),(2070,20582,5),(2074,20582,5),(2116,20582,5),(2117,20582,5),(2118,20582,5),(2122,20582,5),(2079,20582,5),(2080,20582,5),(2081,20582,5),(2083,20582,5),(2127,20582,5),(2128,20582,5
 
),(2129,20582,5),(2131,20582,5),(2086,20582,5),(2087,20582,5),(2088,20582,5),(2090,20582,5),(2134,20582,5),(2135,20582,5),(2136,20582,5),(2138,20582,5),(2091,20582,5),(2092,20582,5),(2093,20582,5),(2094,20582,5),(2139,20582,5),(2140,20582,5),(2141,20582,5),(2142,20582,5),(2016,20582,5),(2017,20582,5),(2018,20582,5),(2022,20582,5),(2026,20582,5),(2027,20582,5),(2028,20582,5),(2029,20582,5),(2030,20582,5),(2036,20582,5),(2037,20582,5),(2038,20582,5),(2039,20582,5),(2007,20582,5),(2008,20582,5),(2010,20582,5),(2015,20582,5),(2046,20592,5),(2047,20592,5),(2048,20592,5),(2049,20592,5),(6961,20592,5),(6955,20592,5),(6958,20592,5),(20582,20592,5),(20575,20592,5),(20576,20592,5),(20580,20592,5),(2059,20646,5),(2060,20646,5),(2061,20646,5),(2062,20646,5),(2063,20646,5),(2064,20646,5),(2065,20646,5),(2066,20646,5),(2067,20646,5),(2107,20646,5),(2108,20646,5),(2109,20646,5),(2110,20646,5),(2111,20646,5),(2112,20646,5),(2113,20646,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dep
 endencies where depend_id = t1.c2);
 
 Running database upgrade commands:
 insert into sys.dependencies select c1, c2, c3 from 
(values(2114,20646,5),(2115,20646,5),(2068,20656,5),(2069,20656,5),(2070,20656,5),(2071,20656,5),(2072,20656,5),(2073,20656,5),(2074,20656,5),(2075,20656,5),(2076,20656,5),(2077,20656,5),(2078,20656,5),(2116,20656,5),(2117,20656,5),(2118,20656,5),(2119,20656,5),(2120,20656,5),(2121,20656,5),(2122,20656,5),(2123,20656,5),(2124,20656,5),(2125,20656,5),(2126,20656,5),(2016,25013,5),(2017,25013,5),(20629,25013,5),(25015,25051,5),(20646,25051,5),(20648,25051,5),(20649,25051,5),(20652,25051,5),(2001,25051,5),(2002,25051,5),(2003,25051,5),(25051,25062,5),(25034,25062,5),(25035,25062,5),(25040,25062,5),(25042,25062,5),(25043,25062,5),(25044,25062,5),(25046,25062,5),(25050,25062,5),(25051,25071,5),(25034,25071,5),(25042,25071,5),(25043,25071,5),(25044,25071,5),(25046,25071,5),(25050,25071,5),(25148,25187,5),(25136,25187,5),(25137,25187,5),(25138,25187,5),(25139,25187,5),(25141,25187,5),(25142,25187,5),(25143,25187,5),(25144,25187,5),(25145,
 
25187,5),(25146,25187,5),(25147,25187,5),(25152,25187,5),(25157,25187,5),(25164,25187,5),(25169,25187,5),(25148,25198,5),(25136,25198,5),(25137,25198,5),(25139,25198,5),(25141,25198,5),(25142,25198,5),(25143,25198,5),(25144,25198,5),(25145,25198,5),(25147,25198,5),(25152,25198,5),(25157,25198,5),(25164,25198,5),(25169,25198,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dependencies where 
depend_id = t1.c2);
@@ -6004,6 +6004,43 @@ update sys.functions set system = true w
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlc') and name in ('master', 'stop', 'flush', 'beat') 
and type = 2;
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlr') and name in ('clock', 'tick') and type = 1;
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlr') and name in ('master', 'stop', 'accept', 
'replicate', 'beat') and type = 2;
+create aggregate stddev_samp(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."stdev";
+GRANT EXECUTE ON AGGREGATE stddev_samp(INTERVAL SECOND) TO PUBLIC;
+create aggregate stddev_samp(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."stdev";
+GRANT EXECUTE ON AGGREGATE stddev_samp(INTERVAL MONTH) TO PUBLIC;
+create aggregate stddev_pop(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."stdevp";
+GRANT EXECUTE ON AGGREGATE stddev_pop(INTERVAL SECOND) TO PUBLIC;
+create aggregate stddev_pop(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."stdevp";
+GRANT EXECUTE ON AGGREGATE stddev_pop(INTERVAL MONTH) TO PUBLIC;
+create aggregate var_samp(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."variance";
+GRANT EXECUTE ON AGGREGATE var_samp(INTERVAL SECOND) TO PUBLIC;
+create aggregate var_samp(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."variance";
+GRANT EXECUTE ON AGGREGATE var_samp(INTERVAL MONTH) TO PUBLIC;
+create aggregate var_pop(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."variancep";
+GRANT EXECUTE ON AGGREGATE var_pop(INTERVAL SECOND) TO PUBLIC;
+create aggregate var_pop(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."variancep";
+GRANT EXECUTE ON AGGREGATE var_pop(INTERVAL MONTH) TO PUBLIC;
+create aggregate median(val INTERVAL SECOND) returns INTERVAL SECOND
+external name "aggr"."median";
+GRANT EXECUTE ON AGGREGATE median(INTERVAL SECOND) TO PUBLIC;
+create aggregate median(val INTERVAL MONTH) returns INTERVAL MONTH
+external name "aggr"."median";
+GRANT EXECUTE ON AGGREGATE median(INTERVAL MONTH) TO PUBLIC;
+create aggregate quantile(val INTERVAL SECOND, q DOUBLE) returns INTERVAL 
SECOND
+external name "aggr"."quantile";
+GRANT EXECUTE ON AGGREGATE quantile(INTERVAL SECOND, DOUBLE) TO PUBLIC;
+create aggregate quantile(val INTERVAL MONTH, q DOUBLE) returns INTERVAL MONTH
+external name "aggr"."quantile";
+GRANT EXECUTE ON AGGREGATE quantile(INTERVAL MONTH, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'sys') and name in ('stddev_samp', 'stddev_pop', 
'var_samp', 'var_pop', 'median', 'quantile') and type = 3;
 drop function json.text(string);
 drop function json.text(int);
 update "sys"."args" set "type" = 'ptr' where "func_id" = (select "id" from 
"sys"."functions" where "name" = 'copyfrom' and "func" = 'copy_from' and "mod" 
= 'sql') and "name" = 'arg_1';
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out 
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
@@ -5097,7 +5097,7 @@ drop procedure sys.times();
 set schema "sys";
 
 Running database upgrade commands:
-insert into sys.dependencies select c1, c2, c3 from 
(values(10816,10825,7),(10820,10829,7),(10574,11065,7),(10567,11065,7),(10570,11065,7),(10571,11065,7),(10572,11065,7),(10573,11065,7),(10633,11077,7),(11065,11077,7),(11069,11077,7),(22478,22480,13),(22466,22480,13),(22467,22480,13),(22468,22480,13),(22469,22480,13),(22470,22480,13),(22471,22480,13),(22472,22480,13),(22473,22480,13),(22474,22480,13),(22475,22480,13),(22476,22480,13),(22477,22480,13),(22381,22480,13),(22364,22480,13),(22365,22480,13),(22366,22480,13),(22367,22480,13),(22368,22480,13),(22369,22480,13),(22370,22480,13),(22371,22480,13),(22372,22480,13),(22373,22480,13),(22374,22480,13),(22375,22480,13),(22376,22480,13),(22377,22480,13),(22378,22480,13),(22379,22480,13),(22380,22480,13),(2079,22480,13),(2080,22480,13),(2081,22480,13),(2082,22480,13),(2083,22480,13),(2084,22480,13),(2085,22480,13),(2102,22480,13),(2103,22480,13),(2104,22480,13),(2105,22480,13),(18569,22480,13),(18570,22480,13),(18571,22480,13),(18572,2
 
2480,13),(18573,22480,13),(18574,22480,13),(18575,22480,13),(18576,22480,13),(18577,22480,13),(18578,22480,13),(2001,22480,13),(2002,22480,13),(2003,22480,13),(2004,22480,13),(2005,22480,13),(2006,22480,13),(18579,22480,13),(18580,22480,13),(18581,22480,13),(18582,22480,13),(18583,22480,13),(18584,22480,13),(18585,22480,13),(18586,22480,13),(18587,22480,13),(18588,22480,13),(18589,22480,13),(5240,5242,5),(5236,5242,5),(5237,5242,5),(5238,5242,5),(5239,5242,5),(5446,5475,5),(5515,5543,5),(5669,5683,5),(5755,5763,5),(5791,5809,5),(5829,5839,5),(11307,11327,5),(5446,11345,5),(11307,11345,5),(18569,14769,5),(18570,14769,5),(18571,14769,5),(18572,14769,5),(2001,14769,5),(2002,14769,5),(2003,14769,5),(18579,14769,5),(18581,14769,5),(18582,14769,5),(18583,14769,5),(18584,14769,5),(18585,14769,5),(2007,14769,5),(2009,14769,5),(2010,14769,5),(10554,14769,5),(10558,14769,5),(10562,14769,5),(2001,18150,5),(2002,18150,5),(2003,18150,5),(2005,18150,5),(5249,18150,5),(5250,18150,5),(5251,18150,5)
 
,(2102,18162,5),(2103,18162,5),(2104,18162,5),(2105,18162,5),(2079,18162,5),(2080,18162,5),(2081,18162,5),(2082,18162,5),(2083,18162,5),(18579,18162,5),(18580,18162,5),(18581,18162,5),(18585,18162,5),(18569,18162,5),(18570,18162,5),(18571,18162,5),(18572,18162,5),(18569,18171,5),(18570,18171,5),(18571,18171,5),(18572,18171,5),(18574,18171,5),(2046,18171,5),(2047,18171,5),(2048,18171,5),(2049,18171,5),(18569,18180,5),(18570,18180,5),(18571,18180,5),(18572,18180,5),(18574,18180,5),(2046,18180,5),(2047,18180,5),(2048,18180,5),(2049,18180,5),(18569,18191,5),(18570,18191,5),(18571,18191,5),(18572,18191,5),(18574,18191,5),(2046,18191,5),(2047,18191,5),(2048,18191,5),(2049,18191,5),(18579,18191,5),(18580,18191,5),(18581,18191,5),(18585,18191,5),(18569,18200,5),(18570,18200,5),(18571,18200,5),(18572,18200,5),(18574,18200,5),(2046,18200,5),(2047,18200,5),(2048,18200,5),(2049,18200,5),(2016,18200,5),(2017,18200,5),(2018,18200,5),(2026,18200,5),(5242,18206,5),(5243,18206,5),(5245,18206,5),(200
 
1,18206,5),(2002,18206,5),(2003,18206,5),(2016,18214,5),(2017,18214,5),(2018,18214,5),(2022,18214,5),(2046,18214,5),(2047,18214,5),(2048,18214,5),(2049,18214,5),(18569,18214,5),(18570,18214,5),(18571,18214,5),(18572,18214,5),(18574,18214,5),(2016,18222,5),(2017,18222,5),(2018,18222,5),(2022,18222,5),(2046,18222,5),(2047,18222,5),(2048,18222,5),(2049,18222,5),(18569,18222,5),(18570,18222,5),(18571,18222,5),(18572,18222,5),(18574,18222,5),(2016,18231,5),(2017,18231,5),(2018,18231,5),(2022,18231,5),(2046,18231,5),(2047,18231,5),(2048,18231,5),(2049,18231,5),(18579,18231,5),(18580,18231,5),(18581,18231,5),(18585,18231,5),(2016,18242,5),(2017,18242,5),(2018,18242,5),(2022,18242,5),(2026,18242,5),(2046,18242,5),(2047,18242,5),(2048,18242,5),(2049,18242,5),(2091,18250,5),(2092,18250,5),(2093,18250,5),(2094,18250,5),(18569,18250,5),(18570,18250,5),(18571,18250,5),(18572,18250,5),(2046,18250,5),(2047,18250,5),(2048,18250,5),(2049,18250,5),(2046,18260,5),(2047,18260,5),(2048,18260,5),(2049,18
 
260,5),(18579,18260,5),(18580,18260,5),(18581,18260,5),(18585,18260,5),(2091,18260,5),(2092,18260,5),(2093,18260,5),(18569,18260,5),(18570,18260,5),(18571,18260,5),(18572,18260,5),(2046,18270,5),(2047,18270,5),(2048,18270,5),(2049,18270,5),(2016,18270,5),(2017,18270,5),(2018,18270,5),(2022,18270,5),(2026,18270,5),(2091,18270,5),(2092,18270,5),(2093,18270,5),(2094,18270,5),(2086,18279,5),(2087,18279,5),(2088,18279,5),(2089,18279,5),(2090,18279,5),(18569,18279,5),(18570,18279,5),(18571,18279,5),(18572,18279,5),(2079,18279,5),(2081,18279,5),(2083,18279,5),(2102,18291,5),(2103,18291,5),(2104,18291,5),(2105,18291,5),(2086,18291,5),(2087,18291,5),(2088,18291,5),(2089,18291,5),(2090,18291,5),(18579,18291,5),(18580,18291,5),(18581,18291,5),(18585,18291,5),(18569,18291,5),(18570,18291,5),(18571,18291,5),(18572,18291,5),(2079,18291,5),(2081,18291,5),(2083,18291,5),(2079,18299,5),(2083,18299,5),(2084,18299,5),(2080,18299,5),(2081,18299,5),(2082,18299,5),(18569,18299,5),(18570,18299,5),(18571,1
 
8299,5),(18572,18299,5),(2079,18309,5),(2080,18309,5),(2081,18309,5),(2082,18309,5),(2083,18309,5),(2084,18309,5),(2016,18318,5),(2017,18318,5),(2018,18318,5),(2022,18318,5),(2046,18318,5),(2047,18318,5),(2048,18318,5),(2049,18318,5),(18569,18318,5),(18570,18318,5),(18571,18318,5),(18572,18318,5),(18574,18318,5),(2016,18327,5),(2017,18327,5),(2018,18327,5),(2022,18327,5),(2046,18327,5),(2047,18327,5),(2048,18327,5),(2049,18327,5),(18569,18327,5),(18570,18327,5),(18571,18327,5),(18572,18327,5),(18574,18327,5),(2016,18336,5),(2017,18336,5),(2018,18336,5),(2022,18336,5),(2046,18336,5),(2047,18336,5),(2048,18336,5),(2049,18336,5),(18579,18336,5),(18580,18336,5),(18581,18336,5),(18585,18336,5),(2016,18347,5),(2017,18347,5),(2018,18347,5),(2022,18347,5),(2026,18347,5),(2046,18347,5),(2047,18347,5),(2048,18347,5),(2049,18347,5),(2046,18357,5),(2047,18357,5),(2048,18357,5),(2049,18357,5),(2007,18357,5),(2008,18357,5),(2010,18357,5),(18579,18357,5),(18580,18357,5),(18581,18357,5),(18585,1835
 
7,5),(18569,18357,5),(18570,18357,5),(18571,18357,5),(18572,18357,5),(2046,18365,5),(2047,18365,5),(2048,18365,5),(2049,18365,5),(2007,18365,5),(2008,18365,5),(2010,18365,5),(2016,18365,5),(2017,18365,5),(2018,18365,5),(2022,18365,5),(2046,18375,5),(2047,18375,5),(2048,18375,5),(2049,18375,5),(2007,18375,5),(2008,18375,5),(2010,18375,5),(2027,18375,5),(2028,18375,5),(2029,18375,5),(2030,18375,5),(2035,18375,5),(2016,18375,5),(2017,18375,5),(2018,18375,5),(5231,18379,5),(5249,18409,5),(5250,18409,5),(5251,18409,5),(5252,18409,5),(5240,18409,5),(5249,18505,5),(5250,18505,5),(5251,18505,5),(2001,18505,5),(2002,18505,5),(2003,18505,5),(2059,18505,5),(2060,18505,5),(2061,18505,5),(2062,18505,5),(2064,18505,5),(2107,18505,5),(2108,18505,5),(2109,18505,5),(2110,18505,5),(2112,18505,5),(2068,18505,5),(2069,18505,5),(2070,18505,5),(2074,18505,5),(2116,18505,5),(2117,18505,5),(2118,18505,5),(2122,18505,5),(2079,18505,5),(2080,18505,5),(2081,18505,5),(2083,18505,5),(2127,18505,5),(2128,18505,5
 
),(2129,18505,5),(2131,18505,5),(2086,18505,5),(2087,18505,5),(2088,18505,5),(2090,18505,5),(2134,18505,5),(2135,18505,5),(2136,18505,5),(2138,18505,5),(2091,18505,5),(2092,18505,5),(2093,18505,5),(2094,18505,5),(2139,18505,5),(2140,18505,5),(2141,18505,5),(2142,18505,5),(2016,18505,5),(2017,18505,5),(2018,18505,5),(2022,18505,5),(2026,18505,5),(2027,18505,5),(2028,18505,5),(2029,18505,5),(2030,18505,5),(2036,18505,5),(2037,18505,5),(2038,18505,5),(2039,18505,5),(2007,18505,5),(2008,18505,5),(2010,18505,5),(2015,18505,5),(2046,18515,5),(2047,18515,5),(2048,18515,5),(2049,18515,5),(6478,18515,5),(6472,18515,5),(6475,18515,5),(18505,18515,5),(18498,18515,5),(18499,18515,5),(18503,18515,5),(2059,18569,5),(2060,18569,5),(2061,18569,5),(2062,18569,5),(2063,18569,5),(2064,18569,5),(2065,18569,5),(2066,18569,5),(2067,18569,5),(2107,18569,5),(2108,18569,5),(2109,18569,5),(2110,18569,5),(2111,18569,5),(2112,18569,5),(2113,18569,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dep
 endencies where depend_id = t1.c2);
+insert into sys.dependencies select c1, c2, c3 from 
(values(10816,10825,7),(10820,10829,7),(10574,11065,7),(10567,11065,7),(10570,11065,7),(10571,11065,7),(10572,11065,7),(10573,11065,7),(10633,11077,7),(11065,11077,7),(11069,11077,7),(22478,22480,13),(22466,22480,13),(22467,22480,13),(22468,22480,13),(22469,22480,13),(22470,22480,13),(22471,22480,13),(22472,22480,13),(22473,22480,13),(22474,22480,13),(22475,22480,13),(22476,22480,13),(22477,22480,13),(22381,22480,13),(22364,22480,13),(22365,22480,13),(22366,22480,13),(22367,22480,13),(22368,22480,13),(22369,22480,13),(22370,22480,13),(22371,22480,13),(22372,22480,13),(22373,22480,13),(22374,22480,13),(22375,22480,13),(22376,22480,13),(22377,22480,13),(22378,22480,13),(22379,22480,13),(22380,22480,13),(2079,22480,13),(2080,22480,13),(2081,22480,13),(2082,22480,13),(2083,22480,13),(2084,22480,13),(2085,22480,13),(2102,22480,13),(2103,22480,13),(2104,22480,13),(2105,22480,13),(18569,22480,13),(18570,22480,13),(18571,22480,13),(18572,2
 
2480,13),(18573,22480,13),(18574,22480,13),(18575,22480,13),(18576,22480,13),(18577,22480,13),(18578,22480,13),(2001,22480,13),(2002,22480,13),(2003,22480,13),(2004,22480,13),(2005,22480,13),(2006,22480,13),(18579,22480,13),(18580,22480,13),(18581,22480,13),(18582,22480,13),(18583,22480,13),(18584,22480,13),(18585,22480,13),(18586,22480,13),(18587,22480,13),(18588,22480,13),(18589,22480,13),(5240,5242,5),(5236,5242,5),(5237,5242,5),(5238,5242,5),(5239,5242,5),(5446,5475,5),(5515,5543,5),(5669,5683,5),(5755,5763,5),(5791,5809,5),(5829,5839,5),(11307,11327,5),(5446,11345,5),(11307,11345,5),(18569,14769,5),(18570,14769,5),(18571,14769,5),(18572,14769,5),(2001,14769,5),(2002,14769,5),(2003,14769,5),(18579,14769,5),(18581,14769,5),(18582,14769,5),(18583,14769,5),(18584,14769,5),(18585,14769,5),(2007,14769,5),(2009,14769,5),(2010,14769,5),(10554,14769,5),(10558,14769,5),(10562,14769,5),(2001,18150,5),(2002,18150,5),(2003,18150,5),(2005,18150,5),(5249,18150,5),(5250,18150,5),(5251,18150,5)
 
,(2102,18162,5),(2103,18162,5),(2104,18162,5),(2105,18162,5),(2079,18162,5),(2080,18162,5),(2081,18162,5),(2082,18162,5),(2083,18162,5),(18579,18162,5),(18580,18162,5),(18581,18162,5),(18585,18162,5),(18569,18162,5),(18570,18162,5),(18571,18162,5),(18572,18162,5),(18569,18171,5),(18570,18171,5),(18571,18171,5),(18572,18171,5),(18574,18171,5),(2046,18171,5),(2047,18171,5),(2048,18171,5),(2049,18171,5),(18569,18180,5),(18570,18180,5),(18571,18180,5),(18572,18180,5),(18574,18180,5),(2046,18180,5),(2047,18180,5),(2048,18180,5),(2049,18180,5),(18569,18191,5),(18570,18191,5),(18571,18191,5),(18572,18191,5),(18574,18191,5),(2046,18191,5),(2047,18191,5),(2048,18191,5),(2049,18191,5),(18579,18191,5),(18580,18191,5),(18581,18191,5),(18585,18191,5),(18569,18200,5),(18570,18200,5),(18571,18200,5),(18572,18200,5),(18574,18200,5),(2046,18200,5),(2047,18200,5),(2048,18200,5),(2049,18200,5),(2016,18200,5),(2017,18200,5),(2018,18200,5),(2026,18200,5),(5242,18206,5),(5243,18206,5),(5245,18206,5),(200
 
1,18206,5),(2002,18206,5),(2003,18206,5),(18569,18214,5),(18570,18214,5),(18571,18214,5),(18572,18214,5),(18574,18214,5),(2046,18214,5),(2047,18214,5),(2048,18214,5),(2049,18214,5),(2016,18214,5),(2017,18214,5),(2018,18214,5),(2022,18214,5),(18569,18222,5),(18570,18222,5),(18571,18222,5),(18572,18222,5),(18574,18222,5),(2046,18222,5),(2047,18222,5),(2048,18222,5),(2049,18222,5),(2016,18222,5),(2017,18222,5),(2018,18222,5),(2022,18222,5),(2016,18231,5),(2017,18231,5),(2018,18231,5),(2022,18231,5),(2046,18231,5),(2047,18231,5),(2048,18231,5),(2049,18231,5),(18579,18231,5),(18580,18231,5),(18581,18231,5),(18585,18231,5),(2016,18242,5),(2017,18242,5),(2018,18242,5),(2022,18242,5),(2026,18242,5),(2046,18242,5),(2047,18242,5),(2048,18242,5),(2049,18242,5),(2091,18250,5),(2092,18250,5),(2093,18250,5),(2094,18250,5),(18569,18250,5),(18570,18250,5),(18571,18250,5),(18572,18250,5),(2046,18250,5),(2047,18250,5),(2048,18250,5),(2049,18250,5),(2046,18260,5),(2047,18260,5),(2048,18260,5),(2049,18
 
260,5),(18579,18260,5),(18580,18260,5),(18581,18260,5),(18585,18260,5),(2091,18260,5),(2092,18260,5),(2093,18260,5),(18569,18260,5),(18570,18260,5),(18571,18260,5),(18572,18260,5),(2046,18270,5),(2047,18270,5),(2048,18270,5),(2049,18270,5),(2016,18270,5),(2017,18270,5),(2018,18270,5),(2022,18270,5),(2026,18270,5),(2091,18270,5),(2092,18270,5),(2093,18270,5),(2094,18270,5),(2086,18279,5),(2087,18279,5),(2088,18279,5),(2089,18279,5),(2090,18279,5),(18569,18279,5),(18570,18279,5),(18571,18279,5),(18572,18279,5),(2079,18279,5),(2081,18279,5),(2083,18279,5),(2102,18291,5),(2103,18291,5),(2104,18291,5),(2105,18291,5),(2086,18291,5),(2087,18291,5),(2088,18291,5),(2089,18291,5),(2090,18291,5),(18579,18291,5),(18580,18291,5),(18581,18291,5),(18585,18291,5),(18569,18291,5),(18570,18291,5),(18571,18291,5),(18572,18291,5),(2079,18291,5),(2081,18291,5),(2083,18291,5),(2079,18299,5),(2083,18299,5),(2084,18299,5),(2080,18299,5),(2081,18299,5),(2082,18299,5),(18569,18299,5),(18570,18299,5),(18571,1
 
8299,5),(18572,18299,5),(2079,18309,5),(2080,18309,5),(2081,18309,5),(2082,18309,5),(2083,18309,5),(2084,18309,5),(18569,18318,5),(18570,18318,5),(18571,18318,5),(18572,18318,5),(18574,18318,5),(2046,18318,5),(2047,18318,5),(2048,18318,5),(2049,18318,5),(2016,18318,5),(2017,18318,5),(2018,18318,5),(2022,18318,5),(18569,18327,5),(18570,18327,5),(18571,18327,5),(18572,18327,5),(18574,18327,5),(2046,18327,5),(2047,18327,5),(2048,18327,5),(2049,18327,5),(2016,18327,5),(2017,18327,5),(2018,18327,5),(2022,18327,5),(2016,18336,5),(2017,18336,5),(2018,18336,5),(2022,18336,5),(2046,18336,5),(2047,18336,5),(2048,18336,5),(2049,18336,5),(18579,18336,5),(18580,18336,5),(18581,18336,5),(18585,18336,5),(2016,18347,5),(2017,18347,5),(2018,18347,5),(2022,18347,5),(2026,18347,5),(2046,18347,5),(2047,18347,5),(2048,18347,5),(2049,18347,5),(2046,18357,5),(2047,18357,5),(2048,18357,5),(2049,18357,5),(2007,18357,5),(2008,18357,5),(2010,18357,5),(18579,18357,5),(18580,18357,5),(18581,18357,5),(18585,1835
 
7,5),(18569,18357,5),(18570,18357,5),(18571,18357,5),(18572,18357,5),(2046,18365,5),(2047,18365,5),(2048,18365,5),(2049,18365,5),(2007,18365,5),(2008,18365,5),(2010,18365,5),(2016,18365,5),(2017,18365,5),(2018,18365,5),(2022,18365,5),(2046,18375,5),(2047,18375,5),(2048,18375,5),(2049,18375,5),(2007,18375,5),(2008,18375,5),(2010,18375,5),(2027,18375,5),(2028,18375,5),(2029,18375,5),(2030,18375,5),(2035,18375,5),(2016,18375,5),(2017,18375,5),(2018,18375,5),(5231,18379,5),(5249,18409,5),(5250,18409,5),(5251,18409,5),(5252,18409,5),(5240,18409,5),(5249,18505,5),(5250,18505,5),(5251,18505,5),(2001,18505,5),(2002,18505,5),(2003,18505,5),(2059,18505,5),(2060,18505,5),(2061,18505,5),(2062,18505,5),(2064,18505,5),(2107,18505,5),(2108,18505,5),(2109,18505,5),(2110,18505,5),(2112,18505,5),(2068,18505,5),(2069,18505,5),(2070,18505,5),(2074,18505,5),(2116,18505,5),(2117,18505,5),(2118,18505,5),(2122,18505,5),(2079,18505,5),(2080,18505,5),(2081,18505,5),(2083,18505,5),(2127,18505,5),(2128,18505,5
 
),(2129,18505,5),(2131,18505,5),(2086,18505,5),(2087,18505,5),(2088,18505,5),(2090,18505,5),(2134,18505,5),(2135,18505,5),(2136,18505,5),(2138,18505,5),(2091,18505,5),(2092,18505,5),(2093,18505,5),(2094,18505,5),(2139,18505,5),(2140,18505,5),(2141,18505,5),(2142,18505,5),(2016,18505,5),(2017,18505,5),(2018,18505,5),(2022,18505,5),(2026,18505,5),(2027,18505,5),(2028,18505,5),(2029,18505,5),(2030,18505,5),(2036,18505,5),(2037,18505,5),(2038,18505,5),(2039,18505,5),(2007,18505,5),(2008,18505,5),(2010,18505,5),(2015,18505,5),(2046,18515,5),(2047,18515,5),(2048,18515,5),(2049,18515,5),(6478,18515,5),(6472,18515,5),(6475,18515,5),(18505,18515,5),(18498,18515,5),(18499,18515,5),(18503,18515,5),(2059,18569,5),(2060,18569,5),(2061,18569,5),(2062,18569,5),(2063,18569,5),(2064,18569,5),(2065,18569,5),(2066,18569,5),(2067,18569,5),(2107,18569,5),(2108,18569,5),(2109,18569,5),(2110,18569,5),(2111,18569,5),(2112,18569,5),(2113,18569,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dep
 endencies where depend_id = t1.c2);
 
 Running database upgrade commands:
 insert into sys.dependencies select c1, c2, c3 from 
(values(2114,18569,5),(2115,18569,5),(2068,18579,5),(2069,18579,5),(2070,18579,5),(2071,18579,5),(2072,18579,5),(2073,18579,5),(2074,18579,5),(2075,18579,5),(2076,18579,5),(2077,18579,5),(2078,18579,5),(2116,18579,5),(2117,18579,5),(2118,18579,5),(2119,18579,5),(2120,18579,5),(2121,18579,5),(2122,18579,5),(2123,18579,5),(2124,18579,5),(2125,18579,5),(2126,18579,5),(2016,22343,5),(2017,22343,5),(18552,22343,5),(22345,22381,5),(18569,22381,5),(18571,22381,5),(18572,22381,5),(18575,22381,5),(2001,22381,5),(2002,22381,5),(2003,22381,5),(22381,22392,5),(22364,22392,5),(22365,22392,5),(22370,22392,5),(22372,22392,5),(22373,22392,5),(22374,22392,5),(22376,22392,5),(22380,22392,5),(22381,22401,5),(22364,22401,5),(22372,22401,5),(22373,22401,5),(22374,22401,5),(22376,22401,5),(22380,22401,5),(22478,22517,5),(22466,22517,5),(22467,22517,5),(22468,22517,5),(22469,22517,5),(22471,22517,5),(22472,22517,5),(22473,22517,5),(22474,22517,5),(22475,
 
22517,5),(22476,22517,5),(22477,22517,5),(22482,22517,5),(22487,22517,5),(22494,22517,5),(22499,22517,5),(22478,22528,5),(22466,22528,5),(22467,22528,5),(22469,22528,5),(22471,22528,5),(22472,22528,5),(22473,22528,5),(22474,22528,5),(22475,22528,5),(22477,22528,5),(22482,22528,5),(22487,22528,5),(22494,22528,5),(22499,22528,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dependencies where 
depend_id = t1.c2);
@@ -5214,6 +5214,43 @@ update sys.functions set system = true w
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlc') and name in ('master', 'stop', 'flush', 'beat') 
and type = 2;
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlr') and name in ('clock', 'tick') and type = 1;
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlr') and name in ('master', 'stop', 'accept', 
'replicate', 'beat') and type = 2;
+create aggregate stddev_samp(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."stdev";
+GRANT EXECUTE ON AGGREGATE stddev_samp(INTERVAL SECOND) TO PUBLIC;
+create aggregate stddev_samp(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."stdev";
+GRANT EXECUTE ON AGGREGATE stddev_samp(INTERVAL MONTH) TO PUBLIC;
+create aggregate stddev_pop(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."stdevp";
+GRANT EXECUTE ON AGGREGATE stddev_pop(INTERVAL SECOND) TO PUBLIC;
+create aggregate stddev_pop(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."stdevp";
+GRANT EXECUTE ON AGGREGATE stddev_pop(INTERVAL MONTH) TO PUBLIC;
+create aggregate var_samp(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."variance";
+GRANT EXECUTE ON AGGREGATE var_samp(INTERVAL SECOND) TO PUBLIC;
+create aggregate var_samp(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."variance";
+GRANT EXECUTE ON AGGREGATE var_samp(INTERVAL MONTH) TO PUBLIC;
+create aggregate var_pop(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."variancep";
+GRANT EXECUTE ON AGGREGATE var_pop(INTERVAL SECOND) TO PUBLIC;
+create aggregate var_pop(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."variancep";
+GRANT EXECUTE ON AGGREGATE var_pop(INTERVAL MONTH) TO PUBLIC;
+create aggregate median(val INTERVAL SECOND) returns INTERVAL SECOND
+external name "aggr"."median";
+GRANT EXECUTE ON AGGREGATE median(INTERVAL SECOND) TO PUBLIC;
+create aggregate median(val INTERVAL MONTH) returns INTERVAL MONTH
+external name "aggr"."median";
+GRANT EXECUTE ON AGGREGATE median(INTERVAL MONTH) TO PUBLIC;
+create aggregate quantile(val INTERVAL SECOND, q DOUBLE) returns INTERVAL 
SECOND
+external name "aggr"."quantile";
+GRANT EXECUTE ON AGGREGATE quantile(INTERVAL SECOND, DOUBLE) TO PUBLIC;
+create aggregate quantile(val INTERVAL MONTH, q DOUBLE) returns INTERVAL MONTH
+external name "aggr"."quantile";
+GRANT EXECUTE ON AGGREGATE quantile(INTERVAL MONTH, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'sys') and name in ('stddev_samp', 'stddev_pop', 
'var_samp', 'var_pop', 'median', 'quantile') and type = 3;
 drop function json.text(string);
 drop function json.text(int);
 update "sys"."args" set "type" = 'ptr' where "func_id" = (select "id" from 
"sys"."functions" where "name" = 'copyfrom' and "func" = 'copy_from' and "mod" 
= 'sql') and "name" = 'arg_1';
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit 
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -5097,7 +5097,7 @@ drop procedure sys.times();
 set schema "sys";
 
 Running database upgrade commands:
-insert into sys.dependencies select c1, c2, c3 from 
(values(10816,10825,7),(10820,10829,7),(10574,11065,7),(10567,11065,7),(10570,11065,7),(10571,11065,7),(10572,11065,7),(10573,11065,7),(10633,11077,7),(11065,11077,7),(11069,11077,7),(22478,22480,13),(22466,22480,13),(22467,22480,13),(22468,22480,13),(22469,22480,13),(22470,22480,13),(22471,22480,13),(22472,22480,13),(22473,22480,13),(22474,22480,13),(22475,22480,13),(22476,22480,13),(22477,22480,13),(22381,22480,13),(22364,22480,13),(22365,22480,13),(22366,22480,13),(22367,22480,13),(22368,22480,13),(22369,22480,13),(22370,22480,13),(22371,22480,13),(22372,22480,13),(22373,22480,13),(22374,22480,13),(22375,22480,13),(22376,22480,13),(22377,22480,13),(22378,22480,13),(22379,22480,13),(22380,22480,13),(2079,22480,13),(2080,22480,13),(2081,22480,13),(2082,22480,13),(2083,22480,13),(2084,22480,13),(2085,22480,13),(2102,22480,13),(2103,22480,13),(2104,22480,13),(2105,22480,13),(18569,22480,13),(18570,22480,13),(18571,22480,13),(18572,2
 
2480,13),(18573,22480,13),(18574,22480,13),(18575,22480,13),(18576,22480,13),(18577,22480,13),(18578,22480,13),(2001,22480,13),(2002,22480,13),(2003,22480,13),(2004,22480,13),(2005,22480,13),(2006,22480,13),(18579,22480,13),(18580,22480,13),(18581,22480,13),(18582,22480,13),(18583,22480,13),(18584,22480,13),(18585,22480,13),(18586,22480,13),(18587,22480,13),(18588,22480,13),(18589,22480,13),(5240,5242,5),(5236,5242,5),(5237,5242,5),(5238,5242,5),(5239,5242,5),(5446,5475,5),(5515,5543,5),(5669,5683,5),(5755,5763,5),(5791,5809,5),(5829,5839,5),(11307,11327,5),(5446,11345,5),(11307,11345,5),(18569,14769,5),(18570,14769,5),(18571,14769,5),(18572,14769,5),(2001,14769,5),(2002,14769,5),(2003,14769,5),(18579,14769,5),(18581,14769,5),(18582,14769,5),(18583,14769,5),(18584,14769,5),(18585,14769,5),(2007,14769,5),(2009,14769,5),(2010,14769,5),(10554,14769,5),(10558,14769,5),(10562,14769,5),(2001,18150,5),(2002,18150,5),(2003,18150,5),(2005,18150,5),(5249,18150,5),(5250,18150,5),(5251,18150,5)
 
,(2102,18162,5),(2103,18162,5),(2104,18162,5),(2105,18162,5),(2079,18162,5),(2080,18162,5),(2081,18162,5),(2082,18162,5),(2083,18162,5),(18579,18162,5),(18580,18162,5),(18581,18162,5),(18585,18162,5),(18569,18162,5),(18570,18162,5),(18571,18162,5),(18572,18162,5),(18569,18171,5),(18570,18171,5),(18571,18171,5),(18572,18171,5),(18574,18171,5),(2046,18171,5),(2047,18171,5),(2048,18171,5),(2049,18171,5),(18569,18180,5),(18570,18180,5),(18571,18180,5),(18572,18180,5),(18574,18180,5),(2046,18180,5),(2047,18180,5),(2048,18180,5),(2049,18180,5),(18569,18191,5),(18570,18191,5),(18571,18191,5),(18572,18191,5),(18574,18191,5),(2046,18191,5),(2047,18191,5),(2048,18191,5),(2049,18191,5),(18579,18191,5),(18580,18191,5),(18581,18191,5),(18585,18191,5),(18569,18200,5),(18570,18200,5),(18571,18200,5),(18572,18200,5),(18574,18200,5),(2046,18200,5),(2047,18200,5),(2048,18200,5),(2049,18200,5),(2016,18200,5),(2017,18200,5),(2018,18200,5),(2026,18200,5),(5242,18206,5),(5243,18206,5),(5245,18206,5),(200
 
1,18206,5),(2002,18206,5),(2003,18206,5),(2016,18214,5),(2017,18214,5),(2018,18214,5),(2022,18214,5),(2046,18214,5),(2047,18214,5),(2048,18214,5),(2049,18214,5),(18569,18214,5),(18570,18214,5),(18571,18214,5),(18572,18214,5),(18574,18214,5),(2016,18222,5),(2017,18222,5),(2018,18222,5),(2022,18222,5),(2046,18222,5),(2047,18222,5),(2048,18222,5),(2049,18222,5),(18569,18222,5),(18570,18222,5),(18571,18222,5),(18572,18222,5),(18574,18222,5),(2016,18231,5),(2017,18231,5),(2018,18231,5),(2022,18231,5),(2046,18231,5),(2047,18231,5),(2048,18231,5),(2049,18231,5),(18579,18231,5),(18580,18231,5),(18581,18231,5),(18585,18231,5),(2016,18242,5),(2017,18242,5),(2018,18242,5),(2022,18242,5),(2026,18242,5),(2046,18242,5),(2047,18242,5),(2048,18242,5),(2049,18242,5),(2091,18250,5),(2092,18250,5),(2093,18250,5),(2094,18250,5),(18569,18250,5),(18570,18250,5),(18571,18250,5),(18572,18250,5),(2046,18250,5),(2047,18250,5),(2048,18250,5),(2049,18250,5),(2046,18260,5),(2047,18260,5),(2048,18260,5),(2049,18
 
260,5),(18579,18260,5),(18580,18260,5),(18581,18260,5),(18585,18260,5),(2091,18260,5),(2092,18260,5),(2093,18260,5),(18569,18260,5),(18570,18260,5),(18571,18260,5),(18572,18260,5),(2046,18270,5),(2047,18270,5),(2048,18270,5),(2049,18270,5),(2016,18270,5),(2017,18270,5),(2018,18270,5),(2022,18270,5),(2026,18270,5),(2091,18270,5),(2092,18270,5),(2093,18270,5),(2094,18270,5),(2086,18279,5),(2087,18279,5),(2088,18279,5),(2089,18279,5),(2090,18279,5),(18569,18279,5),(18570,18279,5),(18571,18279,5),(18572,18279,5),(2079,18279,5),(2081,18279,5),(2083,18279,5),(2102,18291,5),(2103,18291,5),(2104,18291,5),(2105,18291,5),(2086,18291,5),(2087,18291,5),(2088,18291,5),(2089,18291,5),(2090,18291,5),(18579,18291,5),(18580,18291,5),(18581,18291,5),(18585,18291,5),(18569,18291,5),(18570,18291,5),(18571,18291,5),(18572,18291,5),(2079,18291,5),(2081,18291,5),(2083,18291,5),(2079,18299,5),(2083,18299,5),(2084,18299,5),(2080,18299,5),(2081,18299,5),(2082,18299,5),(18569,18299,5),(18570,18299,5),(18571,1
 
8299,5),(18572,18299,5),(2079,18309,5),(2080,18309,5),(2081,18309,5),(2082,18309,5),(2083,18309,5),(2084,18309,5),(2016,18318,5),(2017,18318,5),(2018,18318,5),(2022,18318,5),(2046,18318,5),(2047,18318,5),(2048,18318,5),(2049,18318,5),(18569,18318,5),(18570,18318,5),(18571,18318,5),(18572,18318,5),(18574,18318,5),(2016,18327,5),(2017,18327,5),(2018,18327,5),(2022,18327,5),(2046,18327,5),(2047,18327,5),(2048,18327,5),(2049,18327,5),(18569,18327,5),(18570,18327,5),(18571,18327,5),(18572,18327,5),(18574,18327,5),(2016,18336,5),(2017,18336,5),(2018,18336,5),(2022,18336,5),(2046,18336,5),(2047,18336,5),(2048,18336,5),(2049,18336,5),(18579,18336,5),(18580,18336,5),(18581,18336,5),(18585,18336,5),(2016,18347,5),(2017,18347,5),(2018,18347,5),(2022,18347,5),(2026,18347,5),(2046,18347,5),(2047,18347,5),(2048,18347,5),(2049,18347,5),(2046,18357,5),(2047,18357,5),(2048,18357,5),(2049,18357,5),(2007,18357,5),(2008,18357,5),(2010,18357,5),(18579,18357,5),(18580,18357,5),(18581,18357,5),(18585,1835
 
7,5),(18569,18357,5),(18570,18357,5),(18571,18357,5),(18572,18357,5),(2046,18365,5),(2047,18365,5),(2048,18365,5),(2049,18365,5),(2007,18365,5),(2008,18365,5),(2010,18365,5),(2016,18365,5),(2017,18365,5),(2018,18365,5),(2022,18365,5),(2046,18375,5),(2047,18375,5),(2048,18375,5),(2049,18375,5),(2007,18375,5),(2008,18375,5),(2010,18375,5),(2027,18375,5),(2028,18375,5),(2029,18375,5),(2030,18375,5),(2035,18375,5),(2016,18375,5),(2017,18375,5),(2018,18375,5),(5231,18379,5),(5249,18409,5),(5250,18409,5),(5251,18409,5),(5252,18409,5),(5240,18409,5),(5249,18505,5),(5250,18505,5),(5251,18505,5),(2001,18505,5),(2002,18505,5),(2003,18505,5),(2059,18505,5),(2060,18505,5),(2061,18505,5),(2062,18505,5),(2064,18505,5),(2107,18505,5),(2108,18505,5),(2109,18505,5),(2110,18505,5),(2112,18505,5),(2068,18505,5),(2069,18505,5),(2070,18505,5),(2074,18505,5),(2116,18505,5),(2117,18505,5),(2118,18505,5),(2122,18505,5),(2079,18505,5),(2080,18505,5),(2081,18505,5),(2083,18505,5),(2127,18505,5),(2128,18505,5
 
),(2129,18505,5),(2131,18505,5),(2086,18505,5),(2087,18505,5),(2088,18505,5),(2090,18505,5),(2134,18505,5),(2135,18505,5),(2136,18505,5),(2138,18505,5),(2091,18505,5),(2092,18505,5),(2093,18505,5),(2094,18505,5),(2139,18505,5),(2140,18505,5),(2141,18505,5),(2142,18505,5),(2016,18505,5),(2017,18505,5),(2018,18505,5),(2022,18505,5),(2026,18505,5),(2027,18505,5),(2028,18505,5),(2029,18505,5),(2030,18505,5),(2036,18505,5),(2037,18505,5),(2038,18505,5),(2039,18505,5),(2007,18505,5),(2008,18505,5),(2010,18505,5),(2015,18505,5),(2046,18515,5),(2047,18515,5),(2048,18515,5),(2049,18515,5),(6478,18515,5),(6472,18515,5),(6475,18515,5),(18505,18515,5),(18498,18515,5),(18499,18515,5),(18503,18515,5),(2059,18569,5),(2060,18569,5),(2061,18569,5),(2062,18569,5),(2063,18569,5),(2064,18569,5),(2065,18569,5),(2066,18569,5),(2067,18569,5),(2107,18569,5),(2108,18569,5),(2109,18569,5),(2110,18569,5),(2111,18569,5),(2112,18569,5),(2113,18569,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dep
 endencies where depend_id = t1.c2);
+insert into sys.dependencies select c1, c2, c3 from 
(values(10816,10825,7),(10820,10829,7),(10574,11065,7),(10567,11065,7),(10570,11065,7),(10571,11065,7),(10572,11065,7),(10573,11065,7),(10633,11077,7),(11065,11077,7),(11069,11077,7),(22478,22480,13),(22466,22480,13),(22467,22480,13),(22468,22480,13),(22469,22480,13),(22470,22480,13),(22471,22480,13),(22472,22480,13),(22473,22480,13),(22474,22480,13),(22475,22480,13),(22476,22480,13),(22477,22480,13),(22381,22480,13),(22364,22480,13),(22365,22480,13),(22366,22480,13),(22367,22480,13),(22368,22480,13),(22369,22480,13),(22370,22480,13),(22371,22480,13),(22372,22480,13),(22373,22480,13),(22374,22480,13),(22375,22480,13),(22376,22480,13),(22377,22480,13),(22378,22480,13),(22379,22480,13),(22380,22480,13),(2079,22480,13),(2080,22480,13),(2081,22480,13),(2082,22480,13),(2083,22480,13),(2084,22480,13),(2085,22480,13),(2102,22480,13),(2103,22480,13),(2104,22480,13),(2105,22480,13),(18569,22480,13),(18570,22480,13),(18571,22480,13),(18572,2
 
2480,13),(18573,22480,13),(18574,22480,13),(18575,22480,13),(18576,22480,13),(18577,22480,13),(18578,22480,13),(2001,22480,13),(2002,22480,13),(2003,22480,13),(2004,22480,13),(2005,22480,13),(2006,22480,13),(18579,22480,13),(18580,22480,13),(18581,22480,13),(18582,22480,13),(18583,22480,13),(18584,22480,13),(18585,22480,13),(18586,22480,13),(18587,22480,13),(18588,22480,13),(18589,22480,13),(5240,5242,5),(5236,5242,5),(5237,5242,5),(5238,5242,5),(5239,5242,5),(5446,5475,5),(5515,5543,5),(5669,5683,5),(5755,5763,5),(5791,5809,5),(5829,5839,5),(11307,11327,5),(5446,11345,5),(11307,11345,5),(18569,14769,5),(18570,14769,5),(18571,14769,5),(18572,14769,5),(2001,14769,5),(2002,14769,5),(2003,14769,5),(18579,14769,5),(18581,14769,5),(18582,14769,5),(18583,14769,5),(18584,14769,5),(18585,14769,5),(2007,14769,5),(2009,14769,5),(2010,14769,5),(10554,14769,5),(10558,14769,5),(10562,14769,5),(2001,18150,5),(2002,18150,5),(2003,18150,5),(2005,18150,5),(5249,18150,5),(5250,18150,5),(5251,18150,5)
 
,(2102,18162,5),(2103,18162,5),(2104,18162,5),(2105,18162,5),(2079,18162,5),(2080,18162,5),(2081,18162,5),(2082,18162,5),(2083,18162,5),(18579,18162,5),(18580,18162,5),(18581,18162,5),(18585,18162,5),(18569,18162,5),(18570,18162,5),(18571,18162,5),(18572,18162,5),(18569,18171,5),(18570,18171,5),(18571,18171,5),(18572,18171,5),(18574,18171,5),(2046,18171,5),(2047,18171,5),(2048,18171,5),(2049,18171,5),(18569,18180,5),(18570,18180,5),(18571,18180,5),(18572,18180,5),(18574,18180,5),(2046,18180,5),(2047,18180,5),(2048,18180,5),(2049,18180,5),(18569,18191,5),(18570,18191,5),(18571,18191,5),(18572,18191,5),(18574,18191,5),(2046,18191,5),(2047,18191,5),(2048,18191,5),(2049,18191,5),(18579,18191,5),(18580,18191,5),(18581,18191,5),(18585,18191,5),(18569,18200,5),(18570,18200,5),(18571,18200,5),(18572,18200,5),(18574,18200,5),(2046,18200,5),(2047,18200,5),(2048,18200,5),(2049,18200,5),(2016,18200,5),(2017,18200,5),(2018,18200,5),(2026,18200,5),(5242,18206,5),(5243,18206,5),(5245,18206,5),(200
 
1,18206,5),(2002,18206,5),(2003,18206,5),(18569,18214,5),(18570,18214,5),(18571,18214,5),(18572,18214,5),(18574,18214,5),(2046,18214,5),(2047,18214,5),(2048,18214,5),(2049,18214,5),(2016,18214,5),(2017,18214,5),(2018,18214,5),(2022,18214,5),(18569,18222,5),(18570,18222,5),(18571,18222,5),(18572,18222,5),(18574,18222,5),(2046,18222,5),(2047,18222,5),(2048,18222,5),(2049,18222,5),(2016,18222,5),(2017,18222,5),(2018,18222,5),(2022,18222,5),(2016,18231,5),(2017,18231,5),(2018,18231,5),(2022,18231,5),(2046,18231,5),(2047,18231,5),(2048,18231,5),(2049,18231,5),(18579,18231,5),(18580,18231,5),(18581,18231,5),(18585,18231,5),(2016,18242,5),(2017,18242,5),(2018,18242,5),(2022,18242,5),(2026,18242,5),(2046,18242,5),(2047,18242,5),(2048,18242,5),(2049,18242,5),(2091,18250,5),(2092,18250,5),(2093,18250,5),(2094,18250,5),(18569,18250,5),(18570,18250,5),(18571,18250,5),(18572,18250,5),(2046,18250,5),(2047,18250,5),(2048,18250,5),(2049,18250,5),(2046,18260,5),(2047,18260,5),(2048,18260,5),(2049,18
 
260,5),(18579,18260,5),(18580,18260,5),(18581,18260,5),(18585,18260,5),(2091,18260,5),(2092,18260,5),(2093,18260,5),(18569,18260,5),(18570,18260,5),(18571,18260,5),(18572,18260,5),(2046,18270,5),(2047,18270,5),(2048,18270,5),(2049,18270,5),(2016,18270,5),(2017,18270,5),(2018,18270,5),(2022,18270,5),(2026,18270,5),(2091,18270,5),(2092,18270,5),(2093,18270,5),(2094,18270,5),(2086,18279,5),(2087,18279,5),(2088,18279,5),(2089,18279,5),(2090,18279,5),(18569,18279,5),(18570,18279,5),(18571,18279,5),(18572,18279,5),(2079,18279,5),(2081,18279,5),(2083,18279,5),(2102,18291,5),(2103,18291,5),(2104,18291,5),(2105,18291,5),(2086,18291,5),(2087,18291,5),(2088,18291,5),(2089,18291,5),(2090,18291,5),(18579,18291,5),(18580,18291,5),(18581,18291,5),(18585,18291,5),(18569,18291,5),(18570,18291,5),(18571,18291,5),(18572,18291,5),(2079,18291,5),(2081,18291,5),(2083,18291,5),(2079,18299,5),(2083,18299,5),(2084,18299,5),(2080,18299,5),(2081,18299,5),(2082,18299,5),(18569,18299,5),(18570,18299,5),(18571,1
 
8299,5),(18572,18299,5),(2079,18309,5),(2080,18309,5),(2081,18309,5),(2082,18309,5),(2083,18309,5),(2084,18309,5),(18569,18318,5),(18570,18318,5),(18571,18318,5),(18572,18318,5),(18574,18318,5),(2046,18318,5),(2047,18318,5),(2048,18318,5),(2049,18318,5),(2016,18318,5),(2017,18318,5),(2018,18318,5),(2022,18318,5),(18569,18327,5),(18570,18327,5),(18571,18327,5),(18572,18327,5),(18574,18327,5),(2046,18327,5),(2047,18327,5),(2048,18327,5),(2049,18327,5),(2016,18327,5),(2017,18327,5),(2018,18327,5),(2022,18327,5),(2016,18336,5),(2017,18336,5),(2018,18336,5),(2022,18336,5),(2046,18336,5),(2047,18336,5),(2048,18336,5),(2049,18336,5),(18579,18336,5),(18580,18336,5),(18581,18336,5),(18585,18336,5),(2016,18347,5),(2017,18347,5),(2018,18347,5),(2022,18347,5),(2026,18347,5),(2046,18347,5),(2047,18347,5),(2048,18347,5),(2049,18347,5),(2046,18357,5),(2047,18357,5),(2048,18357,5),(2049,18357,5),(2007,18357,5),(2008,18357,5),(2010,18357,5),(18579,18357,5),(18580,18357,5),(18581,18357,5),(18585,1835
 
7,5),(18569,18357,5),(18570,18357,5),(18571,18357,5),(18572,18357,5),(2046,18365,5),(2047,18365,5),(2048,18365,5),(2049,18365,5),(2007,18365,5),(2008,18365,5),(2010,18365,5),(2016,18365,5),(2017,18365,5),(2018,18365,5),(2022,18365,5),(2046,18375,5),(2047,18375,5),(2048,18375,5),(2049,18375,5),(2007,18375,5),(2008,18375,5),(2010,18375,5),(2027,18375,5),(2028,18375,5),(2029,18375,5),(2030,18375,5),(2035,18375,5),(2016,18375,5),(2017,18375,5),(2018,18375,5),(5231,18379,5),(5249,18409,5),(5250,18409,5),(5251,18409,5),(5252,18409,5),(5240,18409,5),(5249,18505,5),(5250,18505,5),(5251,18505,5),(2001,18505,5),(2002,18505,5),(2003,18505,5),(2059,18505,5),(2060,18505,5),(2061,18505,5),(2062,18505,5),(2064,18505,5),(2107,18505,5),(2108,18505,5),(2109,18505,5),(2110,18505,5),(2112,18505,5),(2068,18505,5),(2069,18505,5),(2070,18505,5),(2074,18505,5),(2116,18505,5),(2117,18505,5),(2118,18505,5),(2122,18505,5),(2079,18505,5),(2080,18505,5),(2081,18505,5),(2083,18505,5),(2127,18505,5),(2128,18505,5
 
),(2129,18505,5),(2131,18505,5),(2086,18505,5),(2087,18505,5),(2088,18505,5),(2090,18505,5),(2134,18505,5),(2135,18505,5),(2136,18505,5),(2138,18505,5),(2091,18505,5),(2092,18505,5),(2093,18505,5),(2094,18505,5),(2139,18505,5),(2140,18505,5),(2141,18505,5),(2142,18505,5),(2016,18505,5),(2017,18505,5),(2018,18505,5),(2022,18505,5),(2026,18505,5),(2027,18505,5),(2028,18505,5),(2029,18505,5),(2030,18505,5),(2036,18505,5),(2037,18505,5),(2038,18505,5),(2039,18505,5),(2007,18505,5),(2008,18505,5),(2010,18505,5),(2015,18505,5),(2046,18515,5),(2047,18515,5),(2048,18515,5),(2049,18515,5),(6478,18515,5),(6472,18515,5),(6475,18515,5),(18505,18515,5),(18498,18515,5),(18499,18515,5),(18503,18515,5),(2059,18569,5),(2060,18569,5),(2061,18569,5),(2062,18569,5),(2063,18569,5),(2064,18569,5),(2065,18569,5),(2066,18569,5),(2067,18569,5),(2107,18569,5),(2108,18569,5),(2109,18569,5),(2110,18569,5),(2111,18569,5),(2112,18569,5),(2113,18569,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dep
 endencies where depend_id = t1.c2);
 
 Running database upgrade commands:
 insert into sys.dependencies select c1, c2, c3 from 
(values(2114,18569,5),(2115,18569,5),(2068,18579,5),(2069,18579,5),(2070,18579,5),(2071,18579,5),(2072,18579,5),(2073,18579,5),(2074,18579,5),(2075,18579,5),(2076,18579,5),(2077,18579,5),(2078,18579,5),(2116,18579,5),(2117,18579,5),(2118,18579,5),(2119,18579,5),(2120,18579,5),(2121,18579,5),(2122,18579,5),(2123,18579,5),(2124,18579,5),(2125,18579,5),(2126,18579,5),(2016,22343,5),(2017,22343,5),(18552,22343,5),(22345,22381,5),(18569,22381,5),(18571,22381,5),(18572,22381,5),(18575,22381,5),(2001,22381,5),(2002,22381,5),(2003,22381,5),(22381,22392,5),(22364,22392,5),(22365,22392,5),(22370,22392,5),(22372,22392,5),(22373,22392,5),(22374,22392,5),(22376,22392,5),(22380,22392,5),(22381,22401,5),(22364,22401,5),(22372,22401,5),(22373,22401,5),(22374,22401,5),(22376,22401,5),(22380,22401,5),(22478,22517,5),(22466,22517,5),(22467,22517,5),(22468,22517,5),(22469,22517,5),(22471,22517,5),(22472,22517,5),(22473,22517,5),(22474,22517,5),(22475,
 
22517,5),(22476,22517,5),(22477,22517,5),(22482,22517,5),(22487,22517,5),(22494,22517,5),(22499,22517,5),(22478,22528,5),(22466,22528,5),(22467,22528,5),(22469,22528,5),(22471,22528,5),(22472,22528,5),(22473,22528,5),(22474,22528,5),(22475,22528,5),(22477,22528,5),(22482,22528,5),(22487,22528,5),(22494,22528,5),(22499,22528,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dependencies where 
depend_id = t1.c2);
@@ -5214,6 +5214,43 @@ update sys.functions set system = true w
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlc') and name in ('master', 'stop', 'flush', 'beat') 
and type = 2;
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlr') and name in ('clock', 'tick') and type = 1;
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlr') and name in ('master', 'stop', 'accept', 
'replicate', 'beat') and type = 2;
+create aggregate stddev_samp(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."stdev";
+GRANT EXECUTE ON AGGREGATE stddev_samp(INTERVAL SECOND) TO PUBLIC;
+create aggregate stddev_samp(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."stdev";
+GRANT EXECUTE ON AGGREGATE stddev_samp(INTERVAL MONTH) TO PUBLIC;
+create aggregate stddev_pop(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."stdevp";
+GRANT EXECUTE ON AGGREGATE stddev_pop(INTERVAL SECOND) TO PUBLIC;
+create aggregate stddev_pop(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."stdevp";
+GRANT EXECUTE ON AGGREGATE stddev_pop(INTERVAL MONTH) TO PUBLIC;
+create aggregate var_samp(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."variance";
+GRANT EXECUTE ON AGGREGATE var_samp(INTERVAL SECOND) TO PUBLIC;
+create aggregate var_samp(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."variance";
+GRANT EXECUTE ON AGGREGATE var_samp(INTERVAL MONTH) TO PUBLIC;
+create aggregate var_pop(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."variancep";
+GRANT EXECUTE ON AGGREGATE var_pop(INTERVAL SECOND) TO PUBLIC;
+create aggregate var_pop(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."variancep";
+GRANT EXECUTE ON AGGREGATE var_pop(INTERVAL MONTH) TO PUBLIC;
+create aggregate median(val INTERVAL SECOND) returns INTERVAL SECOND
+external name "aggr"."median";
+GRANT EXECUTE ON AGGREGATE median(INTERVAL SECOND) TO PUBLIC;
+create aggregate median(val INTERVAL MONTH) returns INTERVAL MONTH
+external name "aggr"."median";
+GRANT EXECUTE ON AGGREGATE median(INTERVAL MONTH) TO PUBLIC;
+create aggregate quantile(val INTERVAL SECOND, q DOUBLE) returns INTERVAL 
SECOND
+external name "aggr"."quantile";
+GRANT EXECUTE ON AGGREGATE quantile(INTERVAL SECOND, DOUBLE) TO PUBLIC;
+create aggregate quantile(val INTERVAL MONTH, q DOUBLE) returns INTERVAL MONTH
+external name "aggr"."quantile";
+GRANT EXECUTE ON AGGREGATE quantile(INTERVAL MONTH, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'sys') and name in ('stddev_samp', 'stddev_pop', 
'var_samp', 'var_pop', 'median', 'quantile') and type = 3;
 drop function json.text(string);
 drop function json.text(int);
 update "sys"."args" set "type" = 'ptr' where "func_id" = (select "id" from 
"sys"."functions" where "name" = 'copyfrom' and "func" = 'copy_from' and "mod" 
= 'sql') and "name" = 'arg_1';
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -5919,7 +5919,7 @@ drop procedure sys.times();
 set schema "sys";
 
 Running database upgrade commands:
-insert into sys.dependencies select c1, c2, c3 from 
(values(10816,10825,7),(10820,10829,7),(10574,11065,7),(10567,11065,7),(10570,11065,7),(10571,11065,7),(10572,11065,7),(10573,11065,7),(10633,11077,7),(11065,11077,7),(11069,11077,7),(22478,22480,13),(22466,22480,13),(22467,22480,13),(22468,22480,13),(22469,22480,13),(22470,22480,13),(22471,22480,13),(22472,22480,13),(22473,22480,13),(22474,22480,13),(22475,22480,13),(22476,22480,13),(22477,22480,13),(22381,22480,13),(22364,22480,13),(22365,22480,13),(22366,22480,13),(22367,22480,13),(22368,22480,13),(22369,22480,13),(22370,22480,13),(22371,22480,13),(22372,22480,13),(22373,22480,13),(22374,22480,13),(22375,22480,13),(22376,22480,13),(22377,22480,13),(22378,22480,13),(22379,22480,13),(22380,22480,13),(2079,22480,13),(2080,22480,13),(2081,22480,13),(2082,22480,13),(2083,22480,13),(2084,22480,13),(2085,22480,13),(2102,22480,13),(2103,22480,13),(2104,22480,13),(2105,22480,13),(18569,22480,13),(18570,22480,13),(18571,22480,13),(18572,2
 
2480,13),(18573,22480,13),(18574,22480,13),(18575,22480,13),(18576,22480,13),(18577,22480,13),(18578,22480,13),(2001,22480,13),(2002,22480,13),(2003,22480,13),(2004,22480,13),(2005,22480,13),(2006,22480,13),(18579,22480,13),(18580,22480,13),(18581,22480,13),(18582,22480,13),(18583,22480,13),(18584,22480,13),(18585,22480,13),(18586,22480,13),(18587,22480,13),(18588,22480,13),(18589,22480,13),(5240,5242,5),(5236,5242,5),(5237,5242,5),(5238,5242,5),(5239,5242,5),(5446,5475,5),(5515,5543,5),(5669,5683,5),(5755,5763,5),(5791,5809,5),(5829,5839,5),(11307,11327,5),(5446,11345,5),(11307,11345,5),(18569,14769,5),(18570,14769,5),(18571,14769,5),(18572,14769,5),(2001,14769,5),(2002,14769,5),(2003,14769,5),(18579,14769,5),(18581,14769,5),(18582,14769,5),(18583,14769,5),(18584,14769,5),(18585,14769,5),(2007,14769,5),(2009,14769,5),(2010,14769,5),(10554,14769,5),(10558,14769,5),(10562,14769,5),(2001,18150,5),(2002,18150,5),(2003,18150,5),(2005,18150,5),(5249,18150,5),(5250,18150,5),(5251,18150,5)
 
,(2102,18162,5),(2103,18162,5),(2104,18162,5),(2105,18162,5),(2079,18162,5),(2080,18162,5),(2081,18162,5),(2082,18162,5),(2083,18162,5),(18579,18162,5),(18580,18162,5),(18581,18162,5),(18585,18162,5),(18569,18162,5),(18570,18162,5),(18571,18162,5),(18572,18162,5),(18569,18171,5),(18570,18171,5),(18571,18171,5),(18572,18171,5),(18574,18171,5),(2046,18171,5),(2047,18171,5),(2048,18171,5),(2049,18171,5),(18569,18180,5),(18570,18180,5),(18571,18180,5),(18572,18180,5),(18574,18180,5),(2046,18180,5),(2047,18180,5),(2048,18180,5),(2049,18180,5),(18569,18191,5),(18570,18191,5),(18571,18191,5),(18572,18191,5),(18574,18191,5),(2046,18191,5),(2047,18191,5),(2048,18191,5),(2049,18191,5),(18579,18191,5),(18580,18191,5),(18581,18191,5),(18585,18191,5),(18569,18200,5),(18570,18200,5),(18571,18200,5),(18572,18200,5),(18574,18200,5),(2046,18200,5),(2047,18200,5),(2048,18200,5),(2049,18200,5),(2016,18200,5),(2017,18200,5),(2018,18200,5),(2026,18200,5),(5242,18206,5),(5243,18206,5),(5245,18206,5),(200
 
1,18206,5),(2002,18206,5),(2003,18206,5),(2016,18214,5),(2017,18214,5),(2018,18214,5),(2022,18214,5),(2046,18214,5),(2047,18214,5),(2048,18214,5),(2049,18214,5),(18569,18214,5),(18570,18214,5),(18571,18214,5),(18572,18214,5),(18574,18214,5),(2016,18222,5),(2017,18222,5),(2018,18222,5),(2022,18222,5),(2046,18222,5),(2047,18222,5),(2048,18222,5),(2049,18222,5),(18569,18222,5),(18570,18222,5),(18571,18222,5),(18572,18222,5),(18574,18222,5),(2016,18231,5),(2017,18231,5),(2018,18231,5),(2022,18231,5),(2046,18231,5),(2047,18231,5),(2048,18231,5),(2049,18231,5),(18579,18231,5),(18580,18231,5),(18581,18231,5),(18585,18231,5),(2016,18242,5),(2017,18242,5),(2018,18242,5),(2022,18242,5),(2026,18242,5),(2046,18242,5),(2047,18242,5),(2048,18242,5),(2049,18242,5),(2091,18250,5),(2092,18250,5),(2093,18250,5),(2094,18250,5),(18569,18250,5),(18570,18250,5),(18571,18250,5),(18572,18250,5),(2046,18250,5),(2047,18250,5),(2048,18250,5),(2049,18250,5),(2046,18260,5),(2047,18260,5),(2048,18260,5),(2049,18
 
260,5),(18579,18260,5),(18580,18260,5),(18581,18260,5),(18585,18260,5),(2091,18260,5),(2092,18260,5),(2093,18260,5),(18569,18260,5),(18570,18260,5),(18571,18260,5),(18572,18260,5),(2046,18270,5),(2047,18270,5),(2048,18270,5),(2049,18270,5),(2016,18270,5),(2017,18270,5),(2018,18270,5),(2022,18270,5),(2026,18270,5),(2091,18270,5),(2092,18270,5),(2093,18270,5),(2094,18270,5),(2086,18279,5),(2087,18279,5),(2088,18279,5),(2089,18279,5),(2090,18279,5),(18569,18279,5),(18570,18279,5),(18571,18279,5),(18572,18279,5),(2079,18279,5),(2081,18279,5),(2083,18279,5),(2102,18291,5),(2103,18291,5),(2104,18291,5),(2105,18291,5),(2086,18291,5),(2087,18291,5),(2088,18291,5),(2089,18291,5),(2090,18291,5),(18579,18291,5),(18580,18291,5),(18581,18291,5),(18585,18291,5),(18569,18291,5),(18570,18291,5),(18571,18291,5),(18572,18291,5),(2079,18291,5),(2081,18291,5),(2083,18291,5),(2079,18299,5),(2083,18299,5),(2084,18299,5),(2080,18299,5),(2081,18299,5),(2082,18299,5),(18569,18299,5),(18570,18299,5),(18571,1
 
8299,5),(18572,18299,5),(2079,18309,5),(2080,18309,5),(2081,18309,5),(2082,18309,5),(2083,18309,5),(2084,18309,5),(2016,18318,5),(2017,18318,5),(2018,18318,5),(2022,18318,5),(2046,18318,5),(2047,18318,5),(2048,18318,5),(2049,18318,5),(18569,18318,5),(18570,18318,5),(18571,18318,5),(18572,18318,5),(18574,18318,5),(2016,18327,5),(2017,18327,5),(2018,18327,5),(2022,18327,5),(2046,18327,5),(2047,18327,5),(2048,18327,5),(2049,18327,5),(18569,18327,5),(18570,18327,5),(18571,18327,5),(18572,18327,5),(18574,18327,5),(2016,18336,5),(2017,18336,5),(2018,18336,5),(2022,18336,5),(2046,18336,5),(2047,18336,5),(2048,18336,5),(2049,18336,5),(18579,18336,5),(18580,18336,5),(18581,18336,5),(18585,18336,5),(2016,18347,5),(2017,18347,5),(2018,18347,5),(2022,18347,5),(2026,18347,5),(2046,18347,5),(2047,18347,5),(2048,18347,5),(2049,18347,5),(2046,18357,5),(2047,18357,5),(2048,18357,5),(2049,18357,5),(2007,18357,5),(2008,18357,5),(2010,18357,5),(18579,18357,5),(18580,18357,5),(18581,18357,5),(18585,1835
 
7,5),(18569,18357,5),(18570,18357,5),(18571,18357,5),(18572,18357,5),(2046,18365,5),(2047,18365,5),(2048,18365,5),(2049,18365,5),(2007,18365,5),(2008,18365,5),(2010,18365,5),(2016,18365,5),(2017,18365,5),(2018,18365,5),(2022,18365,5),(2046,18375,5),(2047,18375,5),(2048,18375,5),(2049,18375,5),(2007,18375,5),(2008,18375,5),(2010,18375,5),(2027,18375,5),(2028,18375,5),(2029,18375,5),(2030,18375,5),(2035,18375,5),(2016,18375,5),(2017,18375,5),(2018,18375,5),(5231,18379,5),(5249,18409,5),(5250,18409,5),(5251,18409,5),(5252,18409,5),(5240,18409,5),(5249,18505,5),(5250,18505,5),(5251,18505,5),(2001,18505,5),(2002,18505,5),(2003,18505,5),(2059,18505,5),(2060,18505,5),(2061,18505,5),(2062,18505,5),(2064,18505,5),(2107,18505,5),(2108,18505,5),(2109,18505,5),(2110,18505,5),(2112,18505,5),(2068,18505,5),(2069,18505,5),(2070,18505,5),(2074,18505,5),(2116,18505,5),(2117,18505,5),(2118,18505,5),(2122,18505,5),(2079,18505,5),(2080,18505,5),(2081,18505,5),(2083,18505,5),(2127,18505,5),(2128,18505,5
 
),(2129,18505,5),(2131,18505,5),(2086,18505,5),(2087,18505,5),(2088,18505,5),(2090,18505,5),(2134,18505,5),(2135,18505,5),(2136,18505,5),(2138,18505,5),(2091,18505,5),(2092,18505,5),(2093,18505,5),(2094,18505,5),(2139,18505,5),(2140,18505,5),(2141,18505,5),(2142,18505,5),(2016,18505,5),(2017,18505,5),(2018,18505,5),(2022,18505,5),(2026,18505,5),(2027,18505,5),(2028,18505,5),(2029,18505,5),(2030,18505,5),(2036,18505,5),(2037,18505,5),(2038,18505,5),(2039,18505,5),(2007,18505,5),(2008,18505,5),(2010,18505,5),(2015,18505,5),(2046,18515,5),(2047,18515,5),(2048,18515,5),(2049,18515,5),(6478,18515,5),(6472,18515,5),(6475,18515,5),(18505,18515,5),(18498,18515,5),(18499,18515,5),(18503,18515,5),(2059,18569,5),(2060,18569,5),(2061,18569,5),(2062,18569,5),(2063,18569,5),(2064,18569,5),(2065,18569,5),(2066,18569,5),(2067,18569,5),(2107,18569,5),(2108,18569,5),(2109,18569,5),(2110,18569,5),(2111,18569,5),(2112,18569,5),(2113,18569,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dep
 endencies where depend_id = t1.c2);
+insert into sys.dependencies select c1, c2, c3 from 
(values(10816,10825,7),(10820,10829,7),(10574,11065,7),(10567,11065,7),(10570,11065,7),(10571,11065,7),(10572,11065,7),(10573,11065,7),(10633,11077,7),(11065,11077,7),(11069,11077,7),(22478,22480,13),(22466,22480,13),(22467,22480,13),(22468,22480,13),(22469,22480,13),(22470,22480,13),(22471,22480,13),(22472,22480,13),(22473,22480,13),(22474,22480,13),(22475,22480,13),(22476,22480,13),(22477,22480,13),(22381,22480,13),(22364,22480,13),(22365,22480,13),(22366,22480,13),(22367,22480,13),(22368,22480,13),(22369,22480,13),(22370,22480,13),(22371,22480,13),(22372,22480,13),(22373,22480,13),(22374,22480,13),(22375,22480,13),(22376,22480,13),(22377,22480,13),(22378,22480,13),(22379,22480,13),(22380,22480,13),(2079,22480,13),(2080,22480,13),(2081,22480,13),(2082,22480,13),(2083,22480,13),(2084,22480,13),(2085,22480,13),(2102,22480,13),(2103,22480,13),(2104,22480,13),(2105,22480,13),(18569,22480,13),(18570,22480,13),(18571,22480,13),(18572,2
 
2480,13),(18573,22480,13),(18574,22480,13),(18575,22480,13),(18576,22480,13),(18577,22480,13),(18578,22480,13),(2001,22480,13),(2002,22480,13),(2003,22480,13),(2004,22480,13),(2005,22480,13),(2006,22480,13),(18579,22480,13),(18580,22480,13),(18581,22480,13),(18582,22480,13),(18583,22480,13),(18584,22480,13),(18585,22480,13),(18586,22480,13),(18587,22480,13),(18588,22480,13),(18589,22480,13),(5240,5242,5),(5236,5242,5),(5237,5242,5),(5238,5242,5),(5239,5242,5),(5446,5475,5),(5515,5543,5),(5669,5683,5),(5755,5763,5),(5791,5809,5),(5829,5839,5),(11307,11327,5),(5446,11345,5),(11307,11345,5),(18569,14769,5),(18570,14769,5),(18571,14769,5),(18572,14769,5),(2001,14769,5),(2002,14769,5),(2003,14769,5),(18579,14769,5),(18581,14769,5),(18582,14769,5),(18583,14769,5),(18584,14769,5),(18585,14769,5),(2007,14769,5),(2009,14769,5),(2010,14769,5),(10554,14769,5),(10558,14769,5),(10562,14769,5),(2001,18150,5),(2002,18150,5),(2003,18150,5),(2005,18150,5),(5249,18150,5),(5250,18150,5),(5251,18150,5)
 
,(2102,18162,5),(2103,18162,5),(2104,18162,5),(2105,18162,5),(2079,18162,5),(2080,18162,5),(2081,18162,5),(2082,18162,5),(2083,18162,5),(18579,18162,5),(18580,18162,5),(18581,18162,5),(18585,18162,5),(18569,18162,5),(18570,18162,5),(18571,18162,5),(18572,18162,5),(18569,18171,5),(18570,18171,5),(18571,18171,5),(18572,18171,5),(18574,18171,5),(2046,18171,5),(2047,18171,5),(2048,18171,5),(2049,18171,5),(18569,18180,5),(18570,18180,5),(18571,18180,5),(18572,18180,5),(18574,18180,5),(2046,18180,5),(2047,18180,5),(2048,18180,5),(2049,18180,5),(18569,18191,5),(18570,18191,5),(18571,18191,5),(18572,18191,5),(18574,18191,5),(2046,18191,5),(2047,18191,5),(2048,18191,5),(2049,18191,5),(18579,18191,5),(18580,18191,5),(18581,18191,5),(18585,18191,5),(18569,18200,5),(18570,18200,5),(18571,18200,5),(18572,18200,5),(18574,18200,5),(2046,18200,5),(2047,18200,5),(2048,18200,5),(2049,18200,5),(2016,18200,5),(2017,18200,5),(2018,18200,5),(2026,18200,5),(5242,18206,5),(5243,18206,5),(5245,18206,5),(200
 
1,18206,5),(2002,18206,5),(2003,18206,5),(18569,18214,5),(18570,18214,5),(18571,18214,5),(18572,18214,5),(18574,18214,5),(2046,18214,5),(2047,18214,5),(2048,18214,5),(2049,18214,5),(2016,18214,5),(2017,18214,5),(2018,18214,5),(2022,18214,5),(18569,18222,5),(18570,18222,5),(18571,18222,5),(18572,18222,5),(18574,18222,5),(2046,18222,5),(2047,18222,5),(2048,18222,5),(2049,18222,5),(2016,18222,5),(2017,18222,5),(2018,18222,5),(2022,18222,5),(2016,18231,5),(2017,18231,5),(2018,18231,5),(2022,18231,5),(2046,18231,5),(2047,18231,5),(2048,18231,5),(2049,18231,5),(18579,18231,5),(18580,18231,5),(18581,18231,5),(18585,18231,5),(2016,18242,5),(2017,18242,5),(2018,18242,5),(2022,18242,5),(2026,18242,5),(2046,18242,5),(2047,18242,5),(2048,18242,5),(2049,18242,5),(2091,18250,5),(2092,18250,5),(2093,18250,5),(2094,18250,5),(18569,18250,5),(18570,18250,5),(18571,18250,5),(18572,18250,5),(2046,18250,5),(2047,18250,5),(2048,18250,5),(2049,18250,5),(2046,18260,5),(2047,18260,5),(2048,18260,5),(2049,18
 
260,5),(18579,18260,5),(18580,18260,5),(18581,18260,5),(18585,18260,5),(2091,18260,5),(2092,18260,5),(2093,18260,5),(18569,18260,5),(18570,18260,5),(18571,18260,5),(18572,18260,5),(2046,18270,5),(2047,18270,5),(2048,18270,5),(2049,18270,5),(2016,18270,5),(2017,18270,5),(2018,18270,5),(2022,18270,5),(2026,18270,5),(2091,18270,5),(2092,18270,5),(2093,18270,5),(2094,18270,5),(2086,18279,5),(2087,18279,5),(2088,18279,5),(2089,18279,5),(2090,18279,5),(18569,18279,5),(18570,18279,5),(18571,18279,5),(18572,18279,5),(2079,18279,5),(2081,18279,5),(2083,18279,5),(2102,18291,5),(2103,18291,5),(2104,18291,5),(2105,18291,5),(2086,18291,5),(2087,18291,5),(2088,18291,5),(2089,18291,5),(2090,18291,5),(18579,18291,5),(18580,18291,5),(18581,18291,5),(18585,18291,5),(18569,18291,5),(18570,18291,5),(18571,18291,5),(18572,18291,5),(2079,18291,5),(2081,18291,5),(2083,18291,5),(2079,18299,5),(2083,18299,5),(2084,18299,5),(2080,18299,5),(2081,18299,5),(2082,18299,5),(18569,18299,5),(18570,18299,5),(18571,1
 
8299,5),(18572,18299,5),(2079,18309,5),(2080,18309,5),(2081,18309,5),(2082,18309,5),(2083,18309,5),(2084,18309,5),(18569,18318,5),(18570,18318,5),(18571,18318,5),(18572,18318,5),(18574,18318,5),(2046,18318,5),(2047,18318,5),(2048,18318,5),(2049,18318,5),(2016,18318,5),(2017,18318,5),(2018,18318,5),(2022,18318,5),(18569,18327,5),(18570,18327,5),(18571,18327,5),(18572,18327,5),(18574,18327,5),(2046,18327,5),(2047,18327,5),(2048,18327,5),(2049,18327,5),(2016,18327,5),(2017,18327,5),(2018,18327,5),(2022,18327,5),(2016,18336,5),(2017,18336,5),(2018,18336,5),(2022,18336,5),(2046,18336,5),(2047,18336,5),(2048,18336,5),(2049,18336,5),(18579,18336,5),(18580,18336,5),(18581,18336,5),(18585,18336,5),(2016,18347,5),(2017,18347,5),(2018,18347,5),(2022,18347,5),(2026,18347,5),(2046,18347,5),(2047,18347,5),(2048,18347,5),(2049,18347,5),(2046,18357,5),(2047,18357,5),(2048,18357,5),(2049,18357,5),(2007,18357,5),(2008,18357,5),(2010,18357,5),(18579,18357,5),(18580,18357,5),(18581,18357,5),(18585,1835
 
7,5),(18569,18357,5),(18570,18357,5),(18571,18357,5),(18572,18357,5),(2046,18365,5),(2047,18365,5),(2048,18365,5),(2049,18365,5),(2007,18365,5),(2008,18365,5),(2010,18365,5),(2016,18365,5),(2017,18365,5),(2018,18365,5),(2022,18365,5),(2046,18375,5),(2047,18375,5),(2048,18375,5),(2049,18375,5),(2007,18375,5),(2008,18375,5),(2010,18375,5),(2027,18375,5),(2028,18375,5),(2029,18375,5),(2030,18375,5),(2035,18375,5),(2016,18375,5),(2017,18375,5),(2018,18375,5),(5231,18379,5),(5249,18409,5),(5250,18409,5),(5251,18409,5),(5252,18409,5),(5240,18409,5),(5249,18505,5),(5250,18505,5),(5251,18505,5),(2001,18505,5),(2002,18505,5),(2003,18505,5),(2059,18505,5),(2060,18505,5),(2061,18505,5),(2062,18505,5),(2064,18505,5),(2107,18505,5),(2108,18505,5),(2109,18505,5),(2110,18505,5),(2112,18505,5),(2068,18505,5),(2069,18505,5),(2070,18505,5),(2074,18505,5),(2116,18505,5),(2117,18505,5),(2118,18505,5),(2122,18505,5),(2079,18505,5),(2080,18505,5),(2081,18505,5),(2083,18505,5),(2127,18505,5),(2128,18505,5
 
),(2129,18505,5),(2131,18505,5),(2086,18505,5),(2087,18505,5),(2088,18505,5),(2090,18505,5),(2134,18505,5),(2135,18505,5),(2136,18505,5),(2138,18505,5),(2091,18505,5),(2092,18505,5),(2093,18505,5),(2094,18505,5),(2139,18505,5),(2140,18505,5),(2141,18505,5),(2142,18505,5),(2016,18505,5),(2017,18505,5),(2018,18505,5),(2022,18505,5),(2026,18505,5),(2027,18505,5),(2028,18505,5),(2029,18505,5),(2030,18505,5),(2036,18505,5),(2037,18505,5),(2038,18505,5),(2039,18505,5),(2007,18505,5),(2008,18505,5),(2010,18505,5),(2015,18505,5),(2046,18515,5),(2047,18515,5),(2048,18515,5),(2049,18515,5),(6478,18515,5),(6472,18515,5),(6475,18515,5),(18505,18515,5),(18498,18515,5),(18499,18515,5),(18503,18515,5),(2059,18569,5),(2060,18569,5),(2061,18569,5),(2062,18569,5),(2063,18569,5),(2064,18569,5),(2065,18569,5),(2066,18569,5),(2067,18569,5),(2107,18569,5),(2108,18569,5),(2109,18569,5),(2110,18569,5),(2111,18569,5),(2112,18569,5),(2113,18569,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dep
 endencies where depend_id = t1.c2);
 
 Running database upgrade commands:
 insert into sys.dependencies select c1, c2, c3 from 
(values(2114,18569,5),(2115,18569,5),(2068,18579,5),(2069,18579,5),(2070,18579,5),(2071,18579,5),(2072,18579,5),(2073,18579,5),(2074,18579,5),(2075,18579,5),(2076,18579,5),(2077,18579,5),(2078,18579,5),(2116,18579,5),(2117,18579,5),(2118,18579,5),(2119,18579,5),(2120,18579,5),(2121,18579,5),(2122,18579,5),(2123,18579,5),(2124,18579,5),(2125,18579,5),(2126,18579,5),(2016,22343,5),(2017,22343,5),(18552,22343,5),(22345,22381,5),(18569,22381,5),(18571,22381,5),(18572,22381,5),(18575,22381,5),(2001,22381,5),(2002,22381,5),(2003,22381,5),(22381,22392,5),(22364,22392,5),(22365,22392,5),(22370,22392,5),(22372,22392,5),(22373,22392,5),(22374,22392,5),(22376,22392,5),(22380,22392,5),(22381,22401,5),(22364,22401,5),(22372,22401,5),(22373,22401,5),(22374,22401,5),(22376,22401,5),(22380,22401,5),(22478,22517,5),(22466,22517,5),(22467,22517,5),(22468,22517,5),(22469,22517,5),(22471,22517,5),(22472,22517,5),(22473,22517,5),(22474,22517,5),(22475,
 
22517,5),(22476,22517,5),(22477,22517,5),(22482,22517,5),(22487,22517,5),(22494,22517,5),(22499,22517,5),(22478,22528,5),(22466,22528,5),(22467,22528,5),(22469,22528,5),(22471,22528,5),(22472,22528,5),(22473,22528,5),(22474,22528,5),(22475,22528,5),(22477,22528,5),(22482,22528,5),(22487,22528,5),(22494,22528,5),(22499,22528,5))
 as t1(c1,c2,c3) where t1.c1 not in (select "id" from sys.dependencies where 
depend_id = t1.c2);
@@ -6042,6 +6042,43 @@ update sys.functions set system = true w
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlc') and name in ('master', 'stop', 'flush', 'beat') 
and type = 2;
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlr') and name in ('clock', 'tick') and type = 1;
 update sys.functions set system = true where schema_id = (select id from 
sys.schemas where name = 'wlr') and name in ('master', 'stop', 'accept', 
'replicate', 'beat') and type = 2;
+create aggregate stddev_samp(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."stdev";
+GRANT EXECUTE ON AGGREGATE stddev_samp(INTERVAL SECOND) TO PUBLIC;
+create aggregate stddev_samp(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."stdev";
+GRANT EXECUTE ON AGGREGATE stddev_samp(INTERVAL MONTH) TO PUBLIC;
+create aggregate stddev_pop(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."stdevp";
+GRANT EXECUTE ON AGGREGATE stddev_pop(INTERVAL SECOND) TO PUBLIC;
+create aggregate stddev_pop(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."stdevp";
+GRANT EXECUTE ON AGGREGATE stddev_pop(INTERVAL MONTH) TO PUBLIC;
+create aggregate var_samp(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."variance";
+GRANT EXECUTE ON AGGREGATE var_samp(INTERVAL SECOND) TO PUBLIC;
+create aggregate var_samp(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."variance";
+GRANT EXECUTE ON AGGREGATE var_samp(INTERVAL MONTH) TO PUBLIC;
+create aggregate var_pop(val INTERVAL SECOND) returns DOUBLE
+external name "aggr"."variancep";
+GRANT EXECUTE ON AGGREGATE var_pop(INTERVAL SECOND) TO PUBLIC;
+create aggregate var_pop(val INTERVAL MONTH) returns DOUBLE
+external name "aggr"."variancep";
+GRANT EXECUTE ON AGGREGATE var_pop(INTERVAL MONTH) TO PUBLIC;
+create aggregate median(val INTERVAL SECOND) returns INTERVAL SECOND
+external name "aggr"."median";
+GRANT EXECUTE ON AGGREGATE median(INTERVAL SECOND) TO PUBLIC;
+create aggregate median(val INTERVAL MONTH) returns INTERVAL MONTH
+external name "aggr"."median";
+GRANT EXECUTE ON AGGREGATE median(INTERVAL MONTH) TO PUBLIC;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list