change table name to lower case in getColumns

Dave Cramer · Dave Cramer · commit 106dda291565 · 2002-06-06T14:47:52.000Z
diff --git a/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java b/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java
@@ -13,7 +13,7 @@
 /*
  * This class provides information about the database as a whole.
  *
- * $Id: DatabaseMetaData.java,v 1.44 2002/03/05 03:02:47 davec Exp $
+ * $Id: DatabaseMetaData.java,v 1.45 2002/06/06 14:47:52 davec Exp $
  *
  * <p>Many of the methods here return lists of information in ResultSets.  You
  * can use the normal ResultSet methods such as getString and getInt to
@@ -1731,7 +1731,7 @@ public java.sql.ResultSet getTables(String catalog, String schemaPattern, String
 			String relKind;
 			switch (r.getBytes(3)[0])
 			{
-				case (byte) 'r':                                        
+				case (byte) 'r':
 					if ( r.getString(1).startsWith("pg_") )
                                         {
                                                 relKind = "SYSTEM TABLE";
@@ -1953,12 +1953,12 @@ public java.sql.ResultSet getColumns(String catalog, String schemaPattern, Strin
 
 		if ((tableNamePattern != null) && ! tableNamePattern.equals("%"))
 		{
-			sql.append("                and c.relname like \'" + tableNamePattern + "\'");
+			sql.append("                and c.relname like \'" + tableNamePattern.toLowerCase() + "\'");
 		}
 
 		if ((columnNamePattern != null) && ! columnNamePattern.equals("%"))
 		{
-			sql.append("                and a.attname like \'" + columnNamePattern + "\'");
+			sql.append("                and a.attname like \'" + columnNamePattern.toLowerCase() + "\'");
 		}
 
 		sql.append(
diff --git a/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java b/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java
@@ -15,7 +15,7 @@
 /*
  * This class provides information about the database as a whole.
  *
- * $Id: DatabaseMetaData.java,v 1.53 2002/06/05 19:12:01 davec Exp $
+ * $Id: DatabaseMetaData.java,v 1.54 2002/06/06 14:47:52 davec Exp $
  *
  * <p>Many of the methods here return lists of information in ResultSets.  You
  * can use the normal ResultSet methods such as getString and getInt to
@@ -2057,7 +2057,7 @@ public java.sql.ResultSet getColumns(String catalog, String schemaPattern, Strin
 
 		if ((tableNamePattern != null) && ! tableNamePattern.equals("%"))
 		{
-			sql.append(" and c.relname like \'" + tableNamePattern + "\'");
+			sql.append(" and c.relname like \'" + tableNamePattern.toLowerCase() + "\'");
 		}
 
 		if ((columnNamePattern != null) && ! columnNamePattern.equals("%"))

Original file line number	Diff line number	Diff line change
`@@ -13,7 +13,7 @@`
`13`	`13`	`/*`
`14`	`14`	`* This class provides information about the database as a whole.`
`15`	`15`	`*`
`16`		`- * $Id: DatabaseMetaData.java,v 1.44 2002/03/05 03:02:47 davec Exp $`
	`16`	`+ * $Id: DatabaseMetaData.java,v 1.45 2002/06/06 14:47:52 davec Exp $`
`17`	`17`	`*`
`18`	`18`	`* <p>Many of the methods here return lists of information in ResultSets. You`
`19`	`19`	`* can use the normal ResultSet methods such as getString and getInt to`
`@@ -1731,7 +1731,7 @@ public java.sql.ResultSet getTables(String catalog, String schemaPattern, String`
`1731`	`1731`	`String relKind;`
`1732`	`1732`	`switch (r.getBytes(3)[0])`
`1733`	`1733`	`{`
`1734`		`- case (byte) 'r':`
	`1734`	`+ case (byte) 'r':`
`1735`	`1735`	`if ( r.getString(1).startsWith("pg_") )`
`1736`	`1736`	`{`
`1737`	`1737`	`relKind = "SYSTEM TABLE";`
`@@ -1953,12 +1953,12 @@ public java.sql.ResultSet getColumns(String catalog, String schemaPattern, Strin`
`1953`	`1953`
`1954`	`1954`	`if ((tableNamePattern != null) && ! tableNamePattern.equals("%"))`
`1955`	`1955`	`{`
`1956`		`- sql.append(" and c.relname like \'" + tableNamePattern + "\'");`
	`1956`	`+ sql.append(" and c.relname like \'" + tableNamePattern.toLowerCase() + "\'");`
`1957`	`1957`	`}`
`1958`	`1958`
`1959`	`1959`	`if ((columnNamePattern != null) && ! columnNamePattern.equals("%"))`
`1960`	`1960`	`{`
`1961`		`- sql.append(" and a.attname like \'" + columnNamePattern + "\'");`
	`1961`	`+ sql.append(" and a.attname like \'" + columnNamePattern.toLowerCase() + "\'");`
`1962`	`1962`	`}`
`1963`	`1963`
`1964`	`1964`	`sql.append(`
Original file line number	Diff line number	Diff line change
`@@ -15,7 +15,7 @@`
`15`	`15`	`/*`
`16`	`16`	`* This class provides information about the database as a whole.`
`17`	`17`	`*`
`18`		`- * $Id: DatabaseMetaData.java,v 1.53 2002/06/05 19:12:01 davec Exp $`
	`18`	`+ * $Id: DatabaseMetaData.java,v 1.54 2002/06/06 14:47:52 davec Exp $`
`19`	`19`	`*`
`20`	`20`	`* <p>Many of the methods here return lists of information in ResultSets. You`
`21`	`21`	`* can use the normal ResultSet methods such as getString and getInt to`
`@@ -2057,7 +2057,7 @@ public java.sql.ResultSet getColumns(String catalog, String schemaPattern, Strin`
`2057`	`2057`
`2058`	`2058`	`if ((tableNamePattern != null) && ! tableNamePattern.equals("%"))`
`2059`	`2059`	`{`
`2060`		`- sql.append(" and c.relname like \'" + tableNamePattern + "\'");`
	`2060`	`+ sql.append(" and c.relname like \'" + tableNamePattern.toLowerCase() + "\'");`
`2061`	`2061`	`}`
`2062`	`2062`
`2063`	`2063`	`if ((columnNamePattern != null) && ! columnNamePattern.equals("%"))`