From 106dda29156565c6c22bfc2bd741988d0cc42117 Mon Sep 17 00:00:00 2001 From: Dave Cramer Date: Thu, 6 Jun 2002 14:47:52 +0000 Subject: [PATCH] change table name to lower case in getColumns --- .../jdbc/org/postgresql/jdbc1/DatabaseMetaData.java | 8 ++++---- .../jdbc/org/postgresql/jdbc2/DatabaseMetaData.java | 4 ++-- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java b/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java index 38efcb1e36..29f641e02f 100644 --- a/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java +++ b/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java @@ -13,7 +13,7 @@ import org.postgresql.util.PSQLException; /* * 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 $ * *

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 class DatabaseMetaData implements java.sql.DatabaseMetaData 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 class DatabaseMetaData implements java.sql.DatabaseMetaData 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 index d8327f1544..2eb2b07087 100644 --- a/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java +++ b/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java @@ -15,7 +15,7 @@ import org.postgresql.util.PSQLException; /* * 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 $ * *

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 class DatabaseMetaData implements java.sql.DatabaseMetaData 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("%")) -- 2.40.0