Hi, i am wondering why the command "Show Tables" always uses the PUBLIC 
schema instead of the one set using the "Set Schema" command. The change 
would be very simple:

--- Parser.java (4146)
+++ Parser.java (working copy)
@@ -849,7 +850,7 @@
             buff.append("'UTF8' AS SERVER_ENCODING FROM DUAL");
         } else if (readIf("TABLES")) {
             // for MySQL compatibility
-            String schema = Constants.SCHEMA_MAIN;
+            String schema = session.getCurrentSchemaName();
             if (readIf("FROM")) {
                 schema = readUniqueIdentifier();
             }

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/wjFlqAPedEwJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to