[Sqlshell-svn] /devel/src/main/java/nl/improved/sqlclient/commands

[SVN by r. <sv...@ca...>]

Author: roy
Date: 2010-05-08 12:31:50 +0200 (Sat, 08 May 2010)
New Revision: 475

Modified:
   src/main/java/nl/improved/sqlclient/commands/ShowCommand.java
Log:
fix case sensitivity in 'show tables having ...'


Modified: src/main/java/nl/improved/sqlclient/commands/ShowCommand.java
===================================================================
--- src/main/java/nl/improved/sqlclient/commands/ShowCommand.java	2010-05-08 10:15:34 UTC (rev 474)
+++ src/main/java/nl/improved/sqlclient/commands/ShowCommand.java	2010-05-08 10:31:50 UTC (rev 475)
@@ -42,8 +42,9 @@
             cmd = cmd.substring(0, cmd.length()-1);
         }
         StringBuilder returnValue = new StringBuilder();
-        String subCommand = cmd.substring(cmd.indexOf(' ')).trim().toUpperCase();
-        if (subCommand.startsWith("TABLES")) {
+        String subCommand = cmd.substring(cmd.indexOf(' ')).trim();
+        String subCommandUp = subCommand.toUpperCase();
+        if (subCommandUp.startsWith("TABLES")) {
             if (subCommand.indexOf(' ') > 0) {
                 String otherCommand = subCommand.substring(subCommand.indexOf(' ')).trim();
                 String columnName = DBConnector.getInstance().translateDbVar(otherCommand.substring(otherCommand.indexOf(' ')).trim());
@@ -63,7 +64,7 @@
                                 match.append('\t');
                                 String columnSize = rs.getString("COLUMN_SIZE");
                                 if (columnSize != null) {
-                                    match.append(rs.getString("TYPE_NAME") +"("+columnSize+")");
+                                    match.append(rs.getString("TYPE_NAME")).append("(").append(columnSize).append(")");
                                 } else {
                                     match.append(rs.getString("TYPE_NAME"));
                                 }