Changeset: a240fbcdb837 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a240fbcdb837
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: Aug2018
Log Message:
Fix arguments to functions created during upgrade.
When creating new functions during upgrade, might as well make the
arguments the same as they would be when creating a new database.
diffs (82 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -213,12 +213,12 @@ sql_update_hugeint(Client c, mvc *sql)
"external name udf.fuse;\n");
pos += snprintf(buf + pos, bufsize - pos,
- "create function sys.generate_series(first hugeint,
last hugeint)\n"
+ "create function sys.generate_series(first hugeint,
\"limit\" hugeint)\n"
"returns table (value hugeint)\n"
"external name generator.series;\n");
pos += snprintf(buf + pos, bufsize - pos,
- "create function sys.generate_series(first hugeint,
last hugeint, stepsize hugeint)\n"
+ "create function sys.generate_series(first hugeint,
\"limit\" hugeint, stepsize hugeint)\n"
"returns table (value hugeint)\n"
"external name generator.series;\n");
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
@@ -5298,10 +5298,10 @@ set schema "sys";
create function fuse(one bigint, two bigint)
returns hugeint
external name udf.fuse;
-create function sys.generate_series(first hugeint, last hugeint)
+create function sys.generate_series(first hugeint, "limit" hugeint)
returns table (value hugeint)
external name generator.series;
-create function sys.generate_series(first hugeint, last hugeint, stepsize
hugeint)
+create function sys.generate_series(first hugeint, "limit" hugeint, stepsize
hugeint)
returns table (value hugeint)
external name generator.series;
create aggregate stddev_samp(val HUGEINT) returns DOUBLE
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
@@ -5298,10 +5298,10 @@ set schema "sys";
create function fuse(one bigint, two bigint)
returns hugeint
external name udf.fuse;
-create function sys.generate_series(first hugeint, last hugeint)
+create function sys.generate_series(first hugeint, "limit" hugeint)
returns table (value hugeint)
external name generator.series;
-create function sys.generate_series(first hugeint, last hugeint, stepsize
hugeint)
+create function sys.generate_series(first hugeint, "limit" hugeint, stepsize
hugeint)
returns table (value hugeint)
external name generator.series;
create aggregate stddev_samp(val HUGEINT) returns DOUBLE
diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -5297,10 +5297,10 @@ set schema "sys";
create function fuse(one bigint, two bigint)
returns hugeint
external name udf.fuse;
-create function sys.generate_series(first hugeint, last hugeint)
+create function sys.generate_series(first hugeint, "limit" hugeint)
returns table (value hugeint)
external name generator.series;
-create function sys.generate_series(first hugeint, last hugeint, stepsize
hugeint)
+create function sys.generate_series(first hugeint, "limit" hugeint, stepsize
hugeint)
returns table (value hugeint)
external name generator.series;
create aggregate stddev_samp(val HUGEINT) returns DOUBLE
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
@@ -5298,10 +5298,10 @@ set schema "sys";
create function fuse(one bigint, two bigint)
returns hugeint
external name udf.fuse;
-create function sys.generate_series(first hugeint, last hugeint)
+create function sys.generate_series(first hugeint, "limit" hugeint)
returns table (value hugeint)
external name generator.series;
-create function sys.generate_series(first hugeint, last hugeint, stepsize
hugeint)
+create function sys.generate_series(first hugeint, "limit" hugeint, stepsize
hugeint)
returns table (value hugeint)
external name generator.series;
create aggregate stddev_samp(val HUGEINT) returns DOUBLE
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
