Fixes for JDBC's getColumns() in Postgresql 7.2 & CVS
От | Panu Outinen |
---|---|
Тема | Fixes for JDBC's getColumns() in Postgresql 7.2 & CVS |
Дата | |
Msg-id | 5.1.0.14.0.20020416114737.0356e1a0@vertex.fi обсуждение исходный текст |
Ответы |
Re: Fixes for JDBC's getColumns() in Postgresql 7.2 & CVS
|
Список | pgsql-jdbc |
Following patches are against the current CVS version (HEAD) as of 2002-04-16. Especially the current CVS version of DatabaseMetaData.getColumns() doesn't work at all because the CVS version 1.50 of org/postgresql/jdbc2/DatabaseMetaData.java has accidentally wiped out the row: v.addElement(tuple); - Panu PS. Only the JDBC2 version was tested !! --------------------------------------------------------------------------- --- org/postgresql/jdbc2/DatabaseMetaData.java.org Tue Apr 16 11:17:34 2002 +++ org/postgresql/jdbc2/DatabaseMetaData.java Tue Apr 16 11:32:12 2002 @@ -2053,12 +2053,12 @@ 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( @@ -2146,6 +2146,7 @@ tuple[16] = r.getBytes(5); // ordinal position tuple[17] = (nullFlag.equals("f") ? "YES" : "NO").getBytes(); // Is nullable + v.addElement(tuple); } r.close(); --- org/postgresql/jdbc1/DatabaseMetaData.java.org Tue Mar 5 05:02:47 2002 +++ org/postgresql/jdbc1/DatabaseMetaData.java Tue Apr 16 11:45:15 2002 @@ -1953,12 +1953,12 @@ 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(
В списке pgsql-jdbc по дате отправления: