Changeset: 2e77f0b45dab for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/2e77f0b45dab
Modified Files:
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.test
sql/test/Tests/trace.test
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: scatter
Log Message:
approved output
diffs (263 lines):
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test
@@ -8,11 +8,7 @@ user.main
1
querylog.define
1
-sql.mvc
-1
-sql.tid
-1
-aggr.count
+sql.count
1
sql.resultSet
1
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test
@@ -8,11 +8,7 @@ user.main
1
querylog.define
1
-sql.mvc
-1
-sql.tid
-1
-aggr.count
+sql.count
1
sql.resultSet
1
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test
@@ -8,11 +8,7 @@ user.main
1
querylog.define
1
-sql.mvc
-1
-sql.tid
-1
-aggr.count
+sql.count
1
sql.resultSet
1
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test
@@ -8,11 +8,7 @@ user.main
1
querylog.define
1
-sql.mvc
-1
-sql.tid
-1
-aggr.count
+sql.count
1
sql.resultSet
1
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test
@@ -8,11 +8,7 @@ user.main
1
querylog.define
1
-sql.mvc
-1
-sql.tid
-1
-aggr.count
+sql.count
1
sql.resultSet
1
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test
@@ -5,9 +5,7 @@ query T nosort
plan select count(*) from fk
----
project (
-| group by (
-| | table("sys"."fk") [ "fk"."%fk_fk2_fkey" JOINIDX "sys"."fk"."fk_fk2_fkey" ]
COUNT
-| ) [ ] [ "sys"."count"() NOT NULL as "%1"."%1" ]
+| [ "sys"."cnt"(clob "sys", clob "fk") NOT NULL as "%1"."%1" ]
) [ "%1"."%1" NOT NULL ]
query T nosort
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test
@@ -5,9 +5,7 @@ query T nosort
plan select count(*) from fk left outer join pk1 on fk.fk1 = pk1.pk1
----
project (
-| group by (
-| | table("sys"."fk") [ "fk"."%fk_fk2_fkey" JOINIDX "sys"."fk"."fk_fk2_fkey" ]
COUNT
-| ) [ ] [ "sys"."count"() NOT NULL as "%1"."%1" ]
+| [ "sys"."cnt"(clob "sys", clob "fk") NOT NULL as "%1"."%1" ]
) [ "%1"."%1" NOT NULL ]
query T nosort
@@ -41,9 +39,7 @@ query T nosort
plan select count(*) from pk1 right outer join fk on fk.fk1 = pk1.pk1
----
project (
-| group by (
-| | table("sys"."fk") [ "fk"."%fk_fk2_fkey" JOINIDX "sys"."fk"."fk_fk2_fkey" ]
COUNT
-| ) [ ] [ "sys"."count"() NOT NULL as "%1"."%1" ]
+| [ "sys"."cnt"(clob "sys", clob "fk") NOT NULL as "%1"."%1" ]
) [ "%1"."%1" NOT NULL ]
query T nosort
@@ -77,9 +73,7 @@ query T nosort
plan select count(*) from pk1 full outer join fk on fk.fk1 = pk1.pk1
----
project (
-| group by (
-| | table("sys"."fk") [ "fk"."%fk_fk2_fkey" JOINIDX "sys"."fk"."fk_fk2_fkey" ]
COUNT
-| ) [ ] [ "sys"."count"() NOT NULL as "%1"."%1" ]
+| [ "sys"."cnt"(clob "sys", clob "fk") NOT NULL as "%1"."%1" ]
) [ "%1"."%1" NOT NULL ]
query T nosort
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test
@@ -5,9 +5,7 @@ query T nosort
plan select count(*) from v1
----
project (
-| group by (
-| | table("sys"."fk") [ "fk"."%fk_fk2_fkey" JOINIDX "sys"."fk"."fk_fk2_fkey" ]
COUNT
-| ) [ ] [ "sys"."count"() NOT NULL as "%1"."%1" ]
+| [ "sys"."cnt"(clob "sys", clob "fk") NOT NULL as "%1"."%1" ]
) [ "%1"."%1" NOT NULL ]
query T nosort
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.test
@@ -5,9 +5,7 @@ query T nosort
plan select count(*) from fk left outer join pk1 on fk.fk1 = pk1.pk1 left
outer join pk2 on fk.fk2 = pk2.pk2
----
project (
-| group by (
-| | table("sys"."fk") [ "fk"."%fk_fk2_fkey" JOINIDX "sys"."fk"."fk_fk2_fkey" ]
COUNT
-| ) [ ] [ "sys"."count"() NOT NULL as "%1"."%1" ]
+| [ "sys"."cnt"(clob "sys", clob "fk") NOT NULL as "%1"."%1" ]
) [ "%1"."%1" NOT NULL ]
query T nosort
@@ -44,9 +42,7 @@ query T nosort
plan select count(*) from pk2 right outer join (pk1 right outer join fk on
fk.fk1 = pk1.pk1) on fk.fk2 = pk2.pk2
----
project (
-| group by (
-| | table("sys"."fk") [ "fk"."%fk_fk2_fkey" JOINIDX "sys"."fk"."fk_fk2_fkey" ]
COUNT
-| ) [ ] [ "sys"."count"() NOT NULL as "%1"."%1" ]
+| [ "sys"."cnt"(clob "sys", clob "fk") NOT NULL as "%1"."%1" ]
) [ "%1"."%1" NOT NULL ]
query T nosort
@@ -83,9 +79,7 @@ query T nosort
plan select count(*) from pk2 full outer join (pk1 full outer join fk on
fk.fk1 = pk1.pk1) on fk.fk2 = pk2.pk2
----
project (
-| group by (
-| | table("sys"."fk") [ "fk"."%fk_fk2_fkey" JOINIDX "sys"."fk"."fk_fk2_fkey" ]
COUNT
-| ) [ ] [ "sys"."count"() NOT NULL as "%1"."%1" ]
+| [ "sys"."cnt"(clob "sys", clob "fk") NOT NULL as "%1"."%1" ]
) [ "%1"."%1" NOT NULL ]
query T nosort
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.test
@@ -5,9 +5,7 @@ query T nosort
plan select count(*) from v2
----
project (
-| group by (
-| | table("sys"."fk") [ "fk"."%fk_fk2_fkey" JOINIDX "sys"."fk"."fk_fk2_fkey" ]
COUNT
-| ) [ ] [ "sys"."count"() NOT NULL as "%1"."%1" ]
+| [ "sys"."cnt"(clob "sys", clob "fk") NOT NULL as "%1"."%1" ]
) [ "%1"."%1" NOT NULL ]
query T nosort
diff --git a/sql/test/Tests/trace.test b/sql/test/Tests/trace.test
--- a/sql/test/Tests/trace.test
+++ b/sql/test/Tests/trace.test
@@ -25,7 +25,7 @@ select '~EndVariableOutput~'
query I rowsort
SELECT COUNT(*) FROM tracelog()
----
-5
+3
statement ok
DROP TABLE mytypes
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -545,6 +545,7 @@ SYSTEM FUNCTION sys.char_length
SYSTEM FUNCTION sys.character_length
SYSTEM FUNCTION sys.charindex
SYSTEM PROCEDURE sys.clearrejects
+SYSTEM FUNCTION sys.cnt
SYSTEM FUNCTION sys.coalesce
SYSTEM FUNCTION sys.code
SYSTEM FUNCTION sys.columnsize
@@ -2592,6 +2593,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "charindex", "SYSTEM", "locate3",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "clob", 0,
0, "in", "arg_2", "clob", 0, 0, "in", "arg_3",
"int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "charindex", "SYSTEM", "locate3",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "varchar",
0, 0, "in", "arg_2", "varchar", 0, 0, "in",
"arg_3", "int", 32, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "clearrejects", "SYSTEM", "create
procedure sys.clearrejects() external name sql.copy_rejects_clear;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "cnt", "SYSTEM", "count", "sql",
"Internal C", "Scalar function", false, false, false, true,
"res_0", "bigint", 64, 0, "out", "arg_1", "clob",
0, 0, "in", "arg_2", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "coalesce", "SYSTEM", "", "",
"Internal C", "Scalar function", false, false, false, true,
"res_0", "any", 0, 0, "out", "arg_1", "any", 0,
0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "code", "SYSTEM", "unicode", "str",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "char", 0, 0, "out", "arg_1", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "code", "SYSTEM", "unicode", "str",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "clob", 0, 0, "out", "arg_1", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -544,6 +544,7 @@ SYSTEM FUNCTION sys.char_length
SYSTEM FUNCTION sys.character_length
SYSTEM FUNCTION sys.charindex
SYSTEM PROCEDURE sys.clearrejects
+SYSTEM FUNCTION sys.cnt
SYSTEM FUNCTION sys.coalesce
SYSTEM FUNCTION sys.code
SYSTEM FUNCTION sys.columnsize
@@ -2591,6 +2592,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "charindex", "SYSTEM", "locate3",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "clob", 0,
0, "in", "arg_2", "clob", 0, 0, "in", "arg_3",
"int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "charindex", "SYSTEM", "locate3",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "varchar",
0, 0, "in", "arg_2", "varchar", 0, 0, "in",
"arg_3", "int", 32, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "clearrejects", "SYSTEM", "create
procedure sys.clearrejects() external name sql.copy_rejects_clear;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "cnt", "SYSTEM", "count", "sql",
"Internal C", "Scalar function", false, false, false, true,
"res_0", "bigint", 64, 0, "out", "arg_1", "clob",
0, 0, "in", "arg_2", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "coalesce", "SYSTEM", "", "",
"Internal C", "Scalar function", false, false, false, true,
"res_0", "any", 0, 0, "out", "arg_1", "any", 0,
0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "code", "SYSTEM", "unicode", "str",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "char", 0, 0, "out", "arg_1", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "code", "SYSTEM", "unicode", "str",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "clob", 0, 0, "out", "arg_1", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -545,6 +545,7 @@ SYSTEM FUNCTION sys.char_length
SYSTEM FUNCTION sys.character_length
SYSTEM FUNCTION sys.charindex
SYSTEM PROCEDURE sys.clearrejects
+SYSTEM FUNCTION sys.cnt
SYSTEM FUNCTION sys.coalesce
SYSTEM FUNCTION sys.code
SYSTEM FUNCTION sys.columnsize
@@ -2628,6 +2629,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "charindex", "SYSTEM", "locate3",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "clob", 0,
0, "in", "arg_2", "clob", 0, 0, "in", "arg_3",
"int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "charindex", "SYSTEM", "locate3",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "varchar",
0, 0, "in", "arg_2", "varchar", 0, 0, "in",
"arg_3", "int", 32, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "clearrejects", "SYSTEM", "create
procedure sys.clearrejects() external name sql.copy_rejects_clear;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "cnt", "SYSTEM", "count", "sql",
"Internal C", "Scalar function", false, false, false, true,
"res_0", "bigint", 64, 0, "out", "arg_1", "clob",
0, 0, "in", "arg_2", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "coalesce", "SYSTEM", "", "",
"Internal C", "Scalar function", false, false, false, true,
"res_0", "any", 0, 0, "out", "arg_1", "any", 0,
0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "code", "SYSTEM", "unicode", "str",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "char", 0, 0, "out", "arg_1", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "code", "SYSTEM", "unicode", "str",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "clob", 0, 0, "out", "arg_1", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
