Changeset: 16b334deaca3 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=16b334deaca3
Added Files:
        
sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.sql
        
sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.stable.err
        
sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.stable.out
Modified Files:
        sql/test/BugTracker-2016/Tests/All
Branch: default
Log Message:

Test script and expected outputs for Bug 3920


diffs (truncated from 532 to 300 lines):

diff --git a/sql/test/BugTracker-2016/Tests/All 
b/sql/test/BugTracker-2016/Tests/All
--- a/sql/test/BugTracker-2016/Tests/All
+++ b/sql/test/BugTracker-2016/Tests/All
@@ -1,3 +1,4 @@
 LEFT-JOIN_with_OR_conditions_triggers_assertion.Bug-3908
 incorrect_column_name_in_OR_condition_of_LEFT-JOIN_crashes_mserver.Bug-3909
+DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920
 create_table_from_complex_query.Bug-3921
diff --git 
a/sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.sql
 
b/sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.sql
new file mode 100644
--- /dev/null
+++ 
b/sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.sql
@@ -0,0 +1,69 @@
+SELECT "schemas"."name" AS "PROCEDURE_SCHEM", "functions"."name" AS 
"PROCEDURE_NAME"
+, CAST((SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = 
"functions"."id" and "args"."number" = 0) AS smallint) AS "PROCEDURE_TYPE"
+, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+AND "functions"."type" = 2
+AND "schemas"."name" = 'sys'
+ORDER BY "PROCEDURE_SCHEM", "PROCEDURE_NAME", "SPECIFIC_NAME";
+
+SELECT cast(NULL as char(1)) AS "PROCEDURE_CAT", "schemas"."name" AS 
"PROCEDURE_SCHEM", "functions"."name" AS "PROCEDURE_NAME"
+, CAST((SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = 
"functions"."id" and "args"."number" = 0) AS smallint) AS "PROCEDURE_TYPE"
+, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+AND "functions"."type" = 2
+AND "schemas"."name" = 'sys'
+ORDER BY "PROCEDURE_SCHEM", "PROCEDURE_NAME", "SPECIFIC_NAME";
+
+SELECT cast('' as char(1)) AS "PROCEDURE_CAT", "schemas"."name" AS 
"PROCEDURE_SCHEM", "functions"."name" AS "PROCEDURE_NAME"
+, CAST((SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = 
"functions"."id" and "args"."number" = 0) AS smallint) AS "PROCEDURE_TYPE"
+, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+AND "functions"."type" = 2
+AND "schemas"."name" = 'sys'
+ORDER BY "PROCEDURE_SCHEM", "PROCEDURE_NAME", "SPECIFIC_NAME";
+
+SELECT DISTINCT cast('' as char(1)) AS "PROCEDURE_CAT", "schemas"."name" AS 
"PROCEDURE_SCHEM", "functions"."name" AS "PROCEDURE_NAME"
+, CAST((SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = 
"functions"."id" and "args"."number" = 0) AS smallint) AS "PROCEDURE_TYPE"
+, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+AND "functions"."type" = 2
+AND "schemas"."name" = 'sys'
+ORDER BY "PROCEDURE_SCHEM", "PROCEDURE_NAME", "SPECIFIC_NAME";
+
+SELECT DISTINCT cast(NULL as char(1)) AS "PROCEDURE_CAT", "schemas"."name" AS 
"PROCEDURE_SCHEM", "functions"."name" AS "PROCEDURE_NAME"
+, CAST((SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = 
"functions"."id" and "args"."number" = 0) AS smallint) AS "PROCEDURE_TYPE"
+, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+AND "functions"."type" = 2
+AND "schemas"."name" = 'sys'
+ORDER BY "PROCEDURE_SCHEM", "PROCEDURE_NAME", "SPECIFIC_NAME";
+
+SELECT DISTINCT cast(NULL as char(1)) AS "PROCEDURE_CAT", "schemas"."name" AS 
"PROCEDURE_SCHEM", "functions"."name" AS "PROCEDURE_NAME"
+, (SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = "functions"."id" 
and "args"."number" = 0) AS "PROCEDURE_TYPE"
+, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+AND "functions"."type" = 2
+AND "schemas"."name" = 'sys'
+ORDER BY "PROCEDURE_SCHEM", "PROCEDURE_NAME", "SPECIFIC_NAME";
+
+SELECT DISTINCT cast(null as char(1)) AS "PROCEDURE_CAT", "schemas"."name" AS 
"PROCEDURE_SCHEM", "functions"."name" AS "PROCEDURE_NAME"
+, (SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = "functions"."id" 
and "args"."number" = 0) AS "PROCEDURE_TYPE"
+, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+AND "functions"."type" = 2
+AND "schemas"."name" = 'sys'
+ORDER BY "PROCEDURE_SCHEM", "PROCEDURE_NAME", "SPECIFIC_NAME";
+
+SELECT DISTINCT cast(null as char(1)) AS "PROCEDURE_CAT", "schemas"."name" AS 
"PROCEDURE_SCHEM", "functions"."name" AS "PROCEDURE_NAME"
+, (SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = "functions"."id" 
and "args"."number" = 0) AS "PROCEDURE_TYPE"
+, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+AND "functions"."type" = 2
+ORDER BY "PROCEDURE_SCHEM", "PROCEDURE_NAME", "SPECIFIC_NAME";
+
+SELECT DISTINCT cast(null as char(1)) AS "PROCEDURE_CAT", "schemas"."name" AS 
"PROCEDURE_SCHEM", "functions"."name" AS "PROCEDURE_NAME"
+, (SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = "functions"."id" 
and "args"."number" = 0) AS "PROCEDURE_TYPE"
+, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+AND "functions"."type" = 2;
+
diff --git 
a/sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.stable.err
 
b/sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.stable.err
new file mode 100644
--- /dev/null
+++ 
b/sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.stable.err
@@ -0,0 +1,37 @@
+stderr of test 
'DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920` in 
directory 'sql/test/BugTracker-2016` itself:
+
+
+# 15:33:15 >  
+# 15:33:15 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=32053" "--set" 
"mapi_usock=/var/tmp/mtest-3784/.s.monetdb.32053" "--set" "monet_prompt=" 
"--forcemito" 
"--dbpath=/export/scratch2/dinther_scratch1/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2016"
 "--set" "embedded_r=yes"
+# 15:33:15 >  
+
+# builtin opt  gdk_dbpath = 
/export/scratch2/dinther_scratch1/INSTALL/var/monetdb5/dbfarm/demo
+# builtin opt  gdk_debug = 0
+# builtin opt  gdk_vmtrim = no
+# builtin opt  monet_prompt = >
+# builtin opt  monet_daemon = no
+# builtin opt  mapi_port = 50000
+# builtin opt  mapi_open = false
+# builtin opt  mapi_autosense = false
+# builtin opt  sql_optimizer = default_pipe
+# builtin opt  sql_debug = 0
+# cmdline opt  gdk_nr_threads = 0
+# cmdline opt  mapi_open = true
+# cmdline opt  mapi_port = 32053
+# cmdline opt  mapi_usock = /var/tmp/mtest-3784/.s.monetdb.32053
+# cmdline opt  monet_prompt = 
+# cmdline opt  gdk_dbpath = 
/export/scratch2/dinther_scratch1/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2016
+# cmdline opt  embedded_r = yes
+# cmdline opt  gdk_debug = 536870922
+
+
+
+
+# 15:33:15 >  
+# 15:33:15 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-3784" "--port=32053"
+# 15:33:15 >  
+
+# 15:33:16 >  
+# 15:33:16 >  "Done."
+# 15:33:16 >  
+
diff --git 
a/sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.stable.out
 
b/sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.stable.out
new file mode 100644
--- /dev/null
+++ 
b/sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.stable.out
@@ -0,0 +1,403 @@
+stdout of test 
'DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920` in 
directory 'sql/test/BugTracker-2016` itself:
+
+
+# 15:33:15 >  
+# 15:33:15 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=32053" "--set" 
"mapi_usock=/var/tmp/mtest-3784/.s.monetdb.32053" "--set" "monet_prompt=" 
"--forcemito" 
"--dbpath=/export/scratch2/dinther_scratch1/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2016"
 "--set" "embedded_r=yes"
+# 15:33:15 >  
+
+# MonetDB 5 server v11.22.0
+# This is an unreleased version
+# Serving database 'mTests_sql_test_BugTracker-2016', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit 
integers dynamically linked
+# Found 15.589 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://bristol.da.cwi.nl:32053/
+# Listening for UNIX domain connection requests on 
mapi:monetdb:///var/tmp/mtest-3784/.s.monetdb.32053
+# MonetDB/GIS module loaded
+# Start processing logs sql/sql_logs version 52200
+# Finished processing logs sql/sql_logs
+# MonetDB/SQL module loaded
+# MonetDB/R   module loaded
+
+Ready.
+# SQL catalog created, loading sql scripts once
+# loading sql script: 09_like.sql
+# loading sql script: 10_math.sql
+# loading sql script: 11_times.sql
+# loading sql script: 12_url.sql
+# loading sql script: 13_date.sql
+# loading sql script: 14_inet.sql
+# loading sql script: 15_querylog.sql
+# loading sql script: 16_tracelog.sql
+# loading sql script: 17_temporal.sql
+# loading sql script: 20_vacuum.sql
+# loading sql script: 21_dependency_functions.sql
+# loading sql script: 22_clients.sql
+# loading sql script: 23_skyserver.sql
+# loading sql script: 24_zorder.sql
+# loading sql script: 25_debug.sql
+# loading sql script: 26_sysmon.sql
+# loading sql script: 27_rejects.sql
+# loading sql script: 39_analytics.sql
+# loading sql script: 39_analytics_hge.sql
+# loading sql script: 40_geom.sql
+# loading sql script: 40_json.sql
+# loading sql script: 40_json_hge.sql
+# loading sql script: 41_md5sum.sql
+# loading sql script: 45_uuid.sql
+# loading sql script: 46_gsl.sql
+# loading sql script: 46_profiler.sql
+# loading sql script: 51_sys_schema_extension.sql
+# loading sql script: 72_fits.sql
+# loading sql script: 74_netcdf.sql
+# loading sql script: 75_storagemodel.sql
+# loading sql script: 80_statistics.sql
+# loading sql script: 80_udf.sql
+# loading sql script: 80_udf_hge.sql
+# loading sql script: 85_bam.sql
+# loading sql script: 90_generator.sql
+# loading sql script: 90_generator_hge.sql
+# loading sql script: 99_system.sql
+
+# 15:33:15 >  
+# 15:33:15 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-3784" "--port=32053"
+# 15:33:15 >  
+
+#SELECT "schemas"."name" AS "PROCEDURE_SCHEM", "functions"."name" AS 
"PROCEDURE_NAME"
+#, CAST((SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = 
"functions"."id" and "args"."number" = 0) AS smallint) AS "PROCEDURE_TYPE"
+#, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+#FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+#AND "functions"."type" = 2
+% .L,  .L,     .L3,    .L4 # table_name
+% PROCEDURE_SCHEM,     PROCEDURE_NAME, PROCEDURE_TYPE, SPECIFIC_NAME # name
+% varchar,     varchar,        smallint,       varchar # type
+% 3,   16,     1,      20 # length
+[ "sys",       "analyze",      1,      "sys.analyze"   ]
+[ "sys",       "analyze",      1,      "sys.analyze"   ]
+[ "sys",       "analyze",      1,      "sys.analyze"   ]
+[ "sys",       "analyze",      1,      "sys.analyze"   ]
+[ "sys",       "clearrejects", 0,      "sys.clearrejects"      ]
+[ "sys",       "evalalgebra",  1,      "sys.evalalgebra"       ]
+[ "sys",       "fitsattach",   1,      "sys.fitsattach"        ]
+[ "sys",       "fitsload",     1,      "sys.fitsload"  ]
+[ "sys",       "flush_log",    0,      "sys.flush_log" ]
+[ "sys",       "listdir",      1,      "sys.listdir"   ]
+[ "sys",       "listdirpat",   1,      "sys.listdirpat"        ]
+[ "sys",       "netcdf_attach",        1,      "sys.netcdf_attach"     ]
+[ "sys",       "netcdf_importvar",     1,      "sys.netcdf_importvar"  ]
+[ "sys",       "pause",        1,      "sys.pause"     ]
+[ "sys",       "pause",        1,      "sys.pause"     ]
+[ "sys",       "querylog",     1,      "sys.querylog"  ]
+[ "sys",       "querylog_disable",     0,      "sys.querylog_disable"  ]
+[ "sys",       "querylog_empty",       0,      "sys.querylog_empty"    ]
+[ "sys",       "querylog_enable",      0,      "sys.querylog_enable"   ]
+[ "sys",       "querylog_enable",      1,      "sys.querylog_enable"   ]
+[ "sys",       "resume",       1,      "sys.resume"    ]
+[ "sys",       "resume",       1,      "sys.resume"    ]
+[ "sys",       "reuse",        1,      "sys.reuse"     ]
+[ "sys",       "setsession",   1,      "sys.setsession"        ]
+[ "sys",       "settimeout",   1,      "sys.settimeout"        ]
+[ "sys",       "settimeout",   1,      "sys.settimeout"        ]
+[ "sys",       "shrink",       1,      "sys.shrink"    ]
+[ "sys",       "shutdown",     1,      "sys.shutdown"  ]
+[ "sys",       "shutdown",     1,      "sys.shutdown"  ]
+[ "sys",       "stop", 1,      "sys.stop"      ]
+[ "sys",       "stop", 1,      "sys.stop"      ]
+[ "sys",       "storagemodelinit",     0,      "sys.storagemodelinit"  ]
+[ "sys",       "times",        0,      "sys.times"     ]
+[ "sys",       "vacuum",       1,      "sys.vacuum"    ]
+#SELECT cast(NULL as char(1)) AS "PROCEDURE_CAT", "schemas"."name" AS 
"PROCEDURE_SCHEM", "functions"."name" AS "PROCEDURE_NAME"
+#, CAST((SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = 
"functions"."id" and "args"."number" = 0) AS smallint) AS "PROCEDURE_TYPE"
+#, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+#FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+% .L1, .L1,    .L1,    .L4,    .L5 # table_name
+% PROCEDURE_CAT,       PROCEDURE_SCHEM,        PROCEDURE_NAME, PROCEDURE_TYPE, 
SPECIFIC_NAME # name
+% char,        varchar,        varchar,        smallint,       varchar # type
+% 0,   3,      16,     1,      20 # length
+[ null,        "sys",  "analyze",      1,      "sys.analyze"   ]
+[ null,        "sys",  "analyze",      1,      "sys.analyze"   ]
+[ null,        "sys",  "analyze",      1,      "sys.analyze"   ]
+[ null,        "sys",  "analyze",      1,      "sys.analyze"   ]
+[ null,        "sys",  "clearrejects", 0,      "sys.clearrejects"      ]
+[ null,        "sys",  "evalalgebra",  1,      "sys.evalalgebra"       ]
+[ null,        "sys",  "fitsattach",   1,      "sys.fitsattach"        ]
+[ null,        "sys",  "fitsload",     1,      "sys.fitsload"  ]
+[ null,        "sys",  "flush_log",    0,      "sys.flush_log" ]
+[ null,        "sys",  "listdir",      1,      "sys.listdir"   ]
+[ null,        "sys",  "listdirpat",   1,      "sys.listdirpat"        ]
+[ null,        "sys",  "netcdf_attach",        1,      "sys.netcdf_attach"     
]
+[ null,        "sys",  "netcdf_importvar",     1,      "sys.netcdf_importvar"  
]
+[ null,        "sys",  "pause",        1,      "sys.pause"     ]
+[ null,        "sys",  "pause",        1,      "sys.pause"     ]
+[ null,        "sys",  "querylog",     1,      "sys.querylog"  ]
+[ null,        "sys",  "querylog_disable",     0,      "sys.querylog_disable"  
]
+[ null,        "sys",  "querylog_empty",       0,      "sys.querylog_empty"    
]
+[ null,        "sys",  "querylog_enable",      0,      "sys.querylog_enable"   
]
+[ null,        "sys",  "querylog_enable",      1,      "sys.querylog_enable"   
]
+[ null,        "sys",  "resume",       1,      "sys.resume"    ]
+[ null,        "sys",  "resume",       1,      "sys.resume"    ]
+[ null,        "sys",  "reuse",        1,      "sys.reuse"     ]
+[ null,        "sys",  "setsession",   1,      "sys.setsession"        ]
+[ null,        "sys",  "settimeout",   1,      "sys.settimeout"        ]
+[ null,        "sys",  "settimeout",   1,      "sys.settimeout"        ]
+[ null,        "sys",  "shrink",       1,      "sys.shrink"    ]
+[ null,        "sys",  "shutdown",     1,      "sys.shutdown"  ]
+[ null,        "sys",  "shutdown",     1,      "sys.shutdown"  ]
+[ null,        "sys",  "stop", 1,      "sys.stop"      ]
+[ null,        "sys",  "stop", 1,      "sys.stop"      ]
+[ null,        "sys",  "storagemodelinit",     0,      "sys.storagemodelinit"  
]
+[ null,        "sys",  "times",        0,      "sys.times"     ]
+[ null,        "sys",  "vacuum",       1,      "sys.vacuum"    ]
+#SELECT cast('' as char(1)) AS "PROCEDURE_CAT", "schemas"."name" AS 
"PROCEDURE_SCHEM", "functions"."name" AS "PROCEDURE_NAME"
+#, CAST((SELECT COUNT(*) FROM "sys"."args" where "args"."func_id" = 
"functions"."id" and "args"."number" = 0) AS smallint) AS "PROCEDURE_TYPE"
+#, CAST(CASE "functions"."language" WHEN 0 THEN "functions"."mod" || '.' || 
"functions"."func" ELSE "schemas"."name" || '.' || "functions"."name" END AS 
VARCHAR(1500)) AS "SPECIFIC_NAME"
+#FROM "sys"."functions", "sys"."schemas" WHERE "functions"."schema_id" = 
"schemas"."id"
+% .L1, .L1,    .L1,    .L4,    .L5 # table_name
+% PROCEDURE_CAT,       PROCEDURE_SCHEM,        PROCEDURE_NAME, PROCEDURE_TYPE, 
SPECIFIC_NAME # name
+% char,        varchar,        varchar,        smallint,       varchar # type
+% 1,   3,      16,     1,      20 # length
+[ "",  "sys",  "analyze",      1,      "sys.analyze"   ]
+[ "",  "sys",  "analyze",      1,      "sys.analyze"   ]
+[ "",  "sys",  "analyze",      1,      "sys.analyze"   ]
+[ "",  "sys",  "analyze",      1,      "sys.analyze"   ]
+[ "",  "sys",  "clearrejects", 0,      "sys.clearrejects"      ]
+[ "",  "sys",  "evalalgebra",  1,      "sys.evalalgebra"       ]
+[ "",  "sys",  "fitsattach",   1,      "sys.fitsattach"        ]
+[ "",  "sys",  "fitsload",     1,      "sys.fitsload"  ]
+[ "",  "sys",  "flush_log",    0,      "sys.flush_log" ]
+[ "",  "sys",  "listdir",      1,      "sys.listdir"   ]
+[ "",  "sys",  "listdirpat",   1,      "sys.listdirpat"        ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to