Changeset: bde99d002da3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bde99d002da3 Modified Files: sql/test/sys-schema/Tests/systemfunctions.stable.out sql/test/sys-schema/Tests/systemfunctions.stable.out.int128 Branch: default Log Message:
approved output diffs (82 lines): diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out b/sql/test/sys-schema/Tests/systemfunctions.stable.out --- a/sql/test/sys-schema/Tests/systemfunctions.stable.out +++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out @@ -517,10 +517,33 @@ stdout of test 'systemfunctions` in dire [ "sys", "decade", 1, "timestamptz", "" ] [ "sys", "degrees", 0, "double", "create function degrees(r double)\nreturns double\n return r*180/pi();" ] [ "sys", "degrees", 1, "double", "" ] -[ "sys", "deltas", 0, "bigint", "create function sys.deltas (\"schema\" string, \"table\" string, \"column\" string)\n returns table (\"values\" bigint)\n external name \"sql\".\"deltas\";" ] -[ "sys", "deltas", 1, "clob", "" ] -[ "sys", "deltas", 2, "clob", "" ] -[ "sys", "deltas", 3, "clob", "" ] +[ "sys", "deltas", 0, "int", "create function sys.deltas (\"schema\" string)\n returns table (\"id\" int, \"cleared\" boolean, \"immutable\" bigint, \"inserted\" bigint, \"updates\" bigint, \"deletes\" bigint, \"level\" int)\n external name \"sql\".\"deltas\";" ] +[ "sys", "deltas", 1, "boolean", "" ] +[ "sys", "deltas", 2, "bigint", "" ] +[ "sys", "deltas", 3, "bigint", "" ] +[ "sys", "deltas", 4, "bigint", "" ] +[ "sys", "deltas", 5, "bigint", "" ] +[ "sys", "deltas", 6, "int", "" ] +[ "sys", "deltas", 7, "clob", "" ] +[ "sys", "deltas", 0, "int", "create function sys.deltas (\"schema\" string, \"table\" string)\n returns table (\"id\" int, \"cleared\" boolean, \"immutable\" bigint, \"inserted\" bigint, \"updates\" bigint, \"deletes\" bigint, \"level\" int)\n external name \"sql\".\"deltas\";" ] +[ "sys", "deltas", 1, "boolean", "" ] +[ "sys", "deltas", 2, "bigint", "" ] +[ "sys", "deltas", 3, "bigint", "" ] +[ "sys", "deltas", 4, "bigint", "" ] +[ "sys", "deltas", 5, "bigint", "" ] +[ "sys", "deltas", 6, "int", "" ] +[ "sys", "deltas", 7, "clob", "" ] +[ "sys", "deltas", 8, "clob", "" ] +[ "sys", "deltas", 0, "int", "create function sys.deltas (\"schema\" string, \"table\" string, \"column\" string)\n returns table (\"id\" int, \"cleared\" boolean, \"immutable\" bigint, \"inserted\" bigint, \"updates\" bigint, \"deletes\" bigint, \"level\" int)\n external name \"sql\".\"deltas\";" ] +[ "sys", "deltas", 1, "boolean", "" ] +[ "sys", "deltas", 2, "bigint", "" ] +[ "sys", "deltas", 3, "bigint", "" ] +[ "sys", "deltas", 4, "bigint", "" ] +[ "sys", "deltas", 5, "bigint", "" ] +[ "sys", "deltas", 6, "int", "" ] +[ "sys", "deltas", 7, "clob", "" ] +[ "sys", "deltas", 8, "clob", "" ] +[ "sys", "deltas", 9, "clob", "" ] [ "sys", "dense_rank", 0, "int", "dense_rank" ] [ "sys", "dense_rank", 1, "any", "" ] [ "sys", "dense_rank", 2, "boolean", "" ] diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128 b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128 --- a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128 +++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128 @@ -553,10 +553,33 @@ stdout of test 'systemfunctions` in dire [ "sys", "decade", 1, "timestamptz", "" ] [ "sys", "degrees", 0, "double", "create function degrees(r double)\nreturns double\n return r*180/pi();" ] [ "sys", "degrees", 1, "double", "" ] -[ "sys", "deltas", 0, "bigint", "create function sys.deltas (\"schema\" string, \"table\" string, \"column\" string)\n returns table (\"values\" bigint)\n external name \"sql\".\"deltas\";" ] -[ "sys", "deltas", 1, "clob", "" ] -[ "sys", "deltas", 2, "clob", "" ] -[ "sys", "deltas", 3, "clob", "" ] +[ "sys", "deltas", 0, "int", "create function sys.deltas (\"schema\" string)\n returns table (\"id\" int, \"cleared\" boolean, \"immutable\" bigint, \"inserted\" bigint, \"updates\" bigint, \"deletes\" bigint, \"level\" int)\n external name \"sql\".\"deltas\";" ] +[ "sys", "deltas", 1, "boolean", "" ] +[ "sys", "deltas", 2, "bigint", "" ] +[ "sys", "deltas", 3, "bigint", "" ] +[ "sys", "deltas", 4, "bigint", "" ] +[ "sys", "deltas", 5, "bigint", "" ] +[ "sys", "deltas", 6, "int", "" ] +[ "sys", "deltas", 7, "clob", "" ] +[ "sys", "deltas", 0, "int", "create function sys.deltas (\"schema\" string, \"table\" string)\n returns table (\"id\" int, \"cleared\" boolean, \"immutable\" bigint, \"inserted\" bigint, \"updates\" bigint, \"deletes\" bigint, \"level\" int)\n external name \"sql\".\"deltas\";" ] +[ "sys", "deltas", 1, "boolean", "" ] +[ "sys", "deltas", 2, "bigint", "" ] +[ "sys", "deltas", 3, "bigint", "" ] +[ "sys", "deltas", 4, "bigint", "" ] +[ "sys", "deltas", 5, "bigint", "" ] +[ "sys", "deltas", 6, "int", "" ] +[ "sys", "deltas", 7, "clob", "" ] +[ "sys", "deltas", 8, "clob", "" ] +[ "sys", "deltas", 0, "int", "create function sys.deltas (\"schema\" string, \"table\" string, \"column\" string)\n returns table (\"id\" int, \"cleared\" boolean, \"immutable\" bigint, \"inserted\" bigint, \"updates\" bigint, \"deletes\" bigint, \"level\" int)\n external name \"sql\".\"deltas\";" ] +[ "sys", "deltas", 1, "boolean", "" ] +[ "sys", "deltas", 2, "bigint", "" ] +[ "sys", "deltas", 3, "bigint", "" ] +[ "sys", "deltas", 4, "bigint", "" ] +[ "sys", "deltas", 5, "bigint", "" ] +[ "sys", "deltas", 6, "int", "" ] +[ "sys", "deltas", 7, "clob", "" ] +[ "sys", "deltas", 8, "clob", "" ] +[ "sys", "deltas", 9, "clob", "" ] [ "sys", "dense_rank", 0, "int", "dense_rank" ] [ "sys", "dense_rank", 1, "any", "" ] [ "sys", "dense_rank", 2, "boolean", "" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list