Changeset: ea8748e83291 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ea8748e83291 Modified Files: sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out sql/test/sys-schema/Tests/check_Not_Nullable_columns.stable.out Branch: out2in Log Message:
Approve output changes related to additional semantics column. diffs (223 lines): diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out b/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out --- a/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out +++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out @@ -65,10 +65,10 @@ stdout of test 'pyloader3_01` in directo #DROP LOADER myfunc2; #DROP LOADER myfunc3; #SELECT * FROM functions WHERE name='myfunc'; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #ROLLBACK; # 13:26:39 > diff --git a/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out b/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out --- a/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out +++ b/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out @@ -70,11 +70,12 @@ stdout of test 'CrashMe_SQL_server_crash [ NULL, "sys", "functions", "mod", "varchar", 8196, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 4, NULL, NULL, NULL ] [ NULL, "sys", "functions", "language", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 5, NULL, NULL, NULL ] [ NULL, "sys", "functions", "type", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 6, NULL, NULL, NULL ] -[ NULL, "sys", "functions", "side_effect", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 7, NULL, NULL, NULL ] -[ NULL, "sys", "functions", "varres", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 8, NULL, NULL, NULL ] -[ NULL, "sys", "functions", "vararg", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 9, NULL, NULL, NULL ] -[ NULL, "sys", "functions", "schema_id", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 10, NULL, NULL, NULL ] -[ NULL, "sys", "functions", "system", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 11, NULL, NULL, NULL ] +[ NULL, "sys", "functions", "semantics", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 7, NULL, NULL, NULL ] +[ NULL, "sys", "functions", "side_effect", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 8, NULL, NULL, NULL ] +[ NULL, "sys", "functions", "varres", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 9, NULL, NULL, NULL ] +[ NULL, "sys", "functions", "vararg", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 10, NULL, NULL, NULL ] +[ NULL, "sys", "functions", "schema_id", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 11, NULL, NULL, NULL ] +[ NULL, "sys", "functions", "system", "boolean", 1, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 12, NULL, NULL, NULL ] [ NULL, "sys", "keys", "id", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 1, NULL, NULL, NULL ] [ NULL, "sys", "keys", "table_id", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 2, NULL, NULL, NULL ] [ NULL, "sys", "keys", "type", "int", 32, 0, 0, 10, NULL, NULL, NULL, 0, 0, 0, 3, NULL, NULL, NULL ] diff --git a/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out b/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out --- a/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out +++ b/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out @@ -40,7 +40,7 @@ stdout of test 'join_topn.SF-2654133` in [ 2016, "functions", 2000, NULL, 10, true, 0, 0, 0, 1, "one" ] [ 2016, "functions", 2000, NULL, 10, true, 0, 0, 0, 2, "two" ] [ 2016, "functions", 2000, NULL, 10, true, 0, 0, 0, 3, "three" ] -[ 2028, "args", 2000, NULL, 10, true, 0, 0, 0, 1, "one" ] +[ 2029, "args", 2000, NULL, 10, true, 0, 0, 0, 1, "one" ] #drop table x cascade; # 19:39:26 > diff --git a/sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out b/sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out --- a/sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out +++ b/sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out @@ -62,6 +62,7 @@ stdout of test 'innerjoin_multiple-bug-s [ "sys", "functions", "mod" ] [ "sys", "functions", "name" ] [ "sys", "functions", "schema_id" ] +[ "sys", "functions", "semantics" ] [ "sys", "functions", "side_effect" ] [ "sys", "functions", "system" ] [ "sys", "functions", "type" ] @@ -141,6 +142,7 @@ stdout of test 'innerjoin_multiple-bug-s [ "sys", "functions", "mod" ] [ "sys", "functions", "name" ] [ "sys", "functions", "schema_id" ] +[ "sys", "functions", "semantics" ] [ "sys", "functions", "side_effect" ] [ "sys", "functions", "system" ] [ "sys", "functions", "type" ] diff --git a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out --- a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out +++ b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out @@ -94,25 +94,25 @@ stdout of test 'check_ForeignKey_referen % int, varchar, varchar, int, int, int, varchar, boolean, int, varchar # type % 1, 0, 0, 1, 1, 1, 0, 5, 1, 0 # length #SELECT * FROM sys.functions WHERE schema_id NOT IN (SELECT id FROM sys.schemas); -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.functions WHERE type NOT IN (SELECT function_type_id FROM sys.function_types); -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.functions WHERE language NOT IN (SELECT language_id FROM sys.function_languages); -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.functions WHERE system AND schema_id NOT IN (SELECT id FROM sys.schemas WHERE system); -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.args WHERE func_id NOT IN (SELECT id FROM sys.functions); % sys.args, sys.args, sys.args, sys.args, sys.args, sys.args, sys.args, sys.args # table_name % id, func_id, name, type, type_digits, type_scale, inout, number # name diff --git a/sql/test/sys-schema/Tests/check_Not_Nullable_columns.stable.out b/sql/test/sys-schema/Tests/check_Not_Nullable_columns.stable.out --- a/sql/test/sys-schema/Tests/check_Not_Nullable_columns.stable.out +++ b/sql/test/sys-schema/Tests/check_Not_Nullable_columns.stable.out @@ -329,60 +329,60 @@ stdout of test 'check_Not_Nullable_colum % smallint, int, int, smallint # type % 1, 1, 1, 1 # length #SELECT "id", * FROM "sys"."functions" WHERE "id" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% int, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 1, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% id, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% int, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 1, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "name", * FROM "sys"."functions" WHERE "name" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% name, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% varchar, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 0, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% name, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% varchar, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 0, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "func", * FROM "sys"."functions" WHERE "func" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% func, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% varchar, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 0, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% func, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% varchar, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 0, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "mod", * FROM "sys"."functions" WHERE "mod" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% mod, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% varchar, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 0, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% mod, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% varchar, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 0, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "language", * FROM "sys"."functions" WHERE "language" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% language, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% int, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 1, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% language, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% int, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 1, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "type", * FROM "sys"."functions" WHERE "type" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% type, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% int, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 1, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% type, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% int, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 1, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "side_effect", * FROM "sys"."functions" WHERE "side_effect" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% side_effect, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% boolean, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 5, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% side_effect, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% boolean, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 5, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "varres", * FROM "sys"."functions" WHERE "varres" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% varres, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% boolean, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 5, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% varres, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% boolean, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 5, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "vararg", * FROM "sys"."functions" WHERE "vararg" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% vararg, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% boolean, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 5, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% vararg, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% boolean, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 5, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "schema_id", * FROM "sys"."functions" WHERE "schema_id" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% schema_id, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% int, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 1, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% schema_id, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% int, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 1, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "system", * FROM "sys"."functions" WHERE "system" IS NULL; -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% system, id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system # name -% boolean, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean # type -% 5, 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5 # length +% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name +% system, id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name +% boolean, int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type +% 5, 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT "id", * FROM "sys"."idxs" WHERE "id" IS NULL; % sys.idxs, sys.idxs, sys.idxs, sys.idxs, sys.idxs # table_name % id, id, table_id, type, name # name _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list