changeset 443:ab3022da0686

When current schema is tmp or logging show the system tables in that schema instead of those in sys.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Wed, 17 Feb 2021 18:54:13 +0100 (2021-02-17)
parents de1b452b662b
children bc39810b3faa
files src/main/java/org/monetdb/client/JdbcClient.java
diffstat 1 files changed, 5 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/src/main/java/org/monetdb/client/JdbcClient.java
+++ b/src/main/java/org/monetdb/client/JdbcClient.java
@@ -698,8 +698,11 @@ public class JdbcClient {	/* cannot (yet
 						ResultSet tbl = null;
 						try {
 							if (command.equals("\\dS")) {
-								// list available system tables and views in sys schema
-								tbl = dbmd.getTables(null, "sys", null, null);
+								String curSchema = con.getSchema();
+								if (!("sys".equals(curSchema) || "tmp".equals(curSchema) || "logging".equals(curSchema)))
+									curSchema = "sys";
+								// list available system tables and views in sys/tmp/logging schema
+								tbl = dbmd.getTables(null, curSchema, null, null);
 
 								// give us a list of all non-system tables and views (including temp ones)
 								while (tbl.next()) {