Changeset: 28a69ed1f5f1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=28a69ed1f5f1
Modified Files:
        sql/scripts/97_comments.sql
        sql/test/Tests/comment-on.stable.out
Branch: Mar2018
Log Message:

Fix missing schemas in \dn

Only the current schema was listed.


diffs (23 lines):

diff --git a/sql/scripts/97_comments.sql b/sql/scripts/97_comments.sql
--- a/sql/scripts/97_comments.sql
+++ b/sql/scripts/97_comments.sql
@@ -73,7 +73,7 @@ SELECT DISTINCT s.name AS sname,  -- DIS
   LEFT OUTER JOIN sys.schemas s ON f.schema_id = s.id
   LEFT OUTER JOIN sys.systemfunctions sf ON f.id = sf.function_id
 UNION ALL
-SELECT s.name AS sname,
+SELECT NULL AS sname,
          s.name,
          s.name AS fullname,
          CAST(16 AS SMALLINT) AS ntype,
diff --git a/sql/test/Tests/comment-on.stable.out 
b/sql/test/Tests/comment-on.stable.out
--- a/sql/test/Tests/comment-on.stable.out
+++ b/sql/test/Tests/comment-on.stable.out
@@ -82,6 +82,7 @@ SCHEMA  foo
 CREATE SCHEMA "foo" AUTHORIZATION "monetdb";
 #CREATE SCHEMA "space separated";
 SCHEMA  foo              'one final comment'
+SCHEMA  space separated  'space separated'
 CREATE SCHEMA "space separated" AUTHORIZATION "monetdb";
 COMMENT ON SCHEMA "space separated" IS 'space separated';
 #DROP SCHEMA "space separated";
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to