Changeset: 70402bf08abf for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/70402bf08abf
Modified Files:
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
Branch: Aug2024
Log Message:
Approve non-hge upgrade.
diffs (72 lines):
diff --git a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
@@ -13,10 +13,10 @@ update sys.args set type_digits = 31 whe
update sys.args set type_digits = 63 where type = 'bigint' and type_digits <>
63;
update sys.args set type_digits = 127 where type = 'hugeint' and type_digits
<> 127;
update sys.args set type = 'varchar' where type in ('clob', 'char');
-drop aggregate median(decimal);
-drop aggregate median_avg(decimal);
-drop aggregate quantile(decimal, double);
-drop aggregate quantile_avg(decimal, double);
+drop aggregate median(decimal(18,3));
+drop aggregate median_avg(decimal(18,3));
+drop aggregate quantile(decimal(18,3), double);
+drop aggregate quantile_avg(decimal(18,3), double);
create aggregate median(val DECIMAL(2)) returns DECIMAL(2)
external name "aggr"."median";
GRANT EXECUTE ON AGGREGATE median(DECIMAL(2)) TO PUBLIC;
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
@@ -13,10 +13,10 @@ update sys.args set type_digits = 31 whe
update sys.args set type_digits = 63 where type = 'bigint' and type_digits <>
63;
update sys.args set type_digits = 127 where type = 'hugeint' and type_digits
<> 127;
update sys.args set type = 'varchar' where type in ('clob', 'char');
-drop aggregate median(decimal);
-drop aggregate median_avg(decimal);
-drop aggregate quantile(decimal, double);
-drop aggregate quantile_avg(decimal, double);
+drop aggregate median(decimal(18,3));
+drop aggregate median_avg(decimal(18,3));
+drop aggregate quantile(decimal(18,3), double);
+drop aggregate quantile_avg(decimal(18,3), double);
create aggregate median(val DECIMAL(2)) returns DECIMAL(2)
external name "aggr"."median";
GRANT EXECUTE ON AGGREGATE median(DECIMAL(2)) TO PUBLIC;
diff --git a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
@@ -13,10 +13,10 @@ update sys.args set type_digits = 31 whe
update sys.args set type_digits = 63 where type = 'bigint' and type_digits <>
63;
update sys.args set type_digits = 127 where type = 'hugeint' and type_digits
<> 127;
update sys.args set type = 'varchar' where type in ('clob', 'char');
-drop aggregate median(decimal);
-drop aggregate median_avg(decimal);
-drop aggregate quantile(decimal, double);
-drop aggregate quantile_avg(decimal, double);
+drop aggregate median(decimal(18,3));
+drop aggregate median_avg(decimal(18,3));
+drop aggregate quantile(decimal(18,3), double);
+drop aggregate quantile_avg(decimal(18,3), double);
create aggregate median(val DECIMAL(2)) returns DECIMAL(2)
external name "aggr"."median";
GRANT EXECUTE ON AGGREGATE median(DECIMAL(2)) TO PUBLIC;
diff --git a/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
b/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
--- a/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
@@ -13,10 +13,10 @@ update sys.args set type_digits = 31 whe
update sys.args set type_digits = 63 where type = 'bigint' and type_digits <>
63;
update sys.args set type_digits = 127 where type = 'hugeint' and type_digits
<> 127;
update sys.args set type = 'varchar' where type in ('clob', 'char');
-drop aggregate median(decimal);
-drop aggregate median_avg(decimal);
-drop aggregate quantile(decimal, double);
-drop aggregate quantile_avg(decimal, double);
+drop aggregate median(decimal(18,3));
+drop aggregate median_avg(decimal(18,3));
+drop aggregate quantile(decimal(18,3), double);
+drop aggregate quantile_avg(decimal(18,3), double);
create aggregate median(val DECIMAL(2)) returns DECIMAL(2)
external name "aggr"."median";
GRANT EXECUTE ON AGGREGATE median(DECIMAL(2)) TO PUBLIC;
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
