Changeset: dea53750a16f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dea53750a16f
Added Files:
sql/test/Users/Tests/changePasswordUser.reqtests
Modified Files:
sql/scripts/52_describe.sql
sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
Branch: mtest
Log Message:
describe_function sql
diffs (53 lines):
diff --git a/sql/scripts/52_describe.sql b/sql/scripts/52_describe.sql
--- a/sql/scripts/52_describe.sql
+++ b/sql/scripts/52_describe.sql
@@ -28,3 +28,16 @@ BEGIN
AND s.name = schemaName
ORDER BY c.number;
END;
+
+create function describe_function(schemaName string, functionName string)
+ returns table(id integer, name string, type string, language string,
remark string)
+BEGIN
+ return SELECT f.id, f.name, ft.function_type_keyword, fl.language_keyword,
c.remark
+ FROM sys.functions f
+ JOIN sys.schemas s ON f.schema_id = s.id
+ JOIN sys.function_types ft ON f.type = ft.function_type_id
+ LEFT OUTER JOIN sys.function_languages fl ON f.language =
fl.language_id
+ LEFT OUTER JOIN sys.comments c ON f.id = c.id
+ WHERE f.name=functionName AND s.name = schemaName;
+END;
+
diff --git
a/sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
b/sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
--- a/sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
+++ b/sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.test
@@ -14,9 +14,9 @@ query TTTT rowsort
select "name", "query", "type", "remark" from describe_table('sys', 'x')
----
--- TODO FIX ME
statement ok
-\df test
+select "name", "type", "language", "remark" from describe_function('sys',
'test')
+----
statement ok
drop procedure test
@@ -34,9 +34,9 @@ query TTTT rowsort
select "name", "query", "type", "remark" from describe_table('sys', 'x')
----
--- TODO FIX ME
statement ok
-\df test
+select "name", "type", "language", "remark" from describe_function('sys',
'test')
+----
statement ok
drop procedure test
diff --git a/sql/test/Users/Tests/changePasswordUser.reqtests
b/sql/test/Users/Tests/changePasswordUser.reqtests
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/changePasswordUser.reqtests
@@ -0,0 +1,1 @@
+createSetUp
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
