postgresql-jdbc.git / summary / log / commit / refs

commit    4db623c3fd15e4675d48ad2fdf91ab3dd07465ad
Author:   Kris Jurka <books@ejurka.com>
Date:     Mon Jul 23 17:30:38 2007 +0000

    Don't return quotes around identifiers in the results of
    DatabaseMetaData.getIndexInfo even if they would require quoting
    in SQL.  The code was making a "col = NULL" comparison which doesn't
    work.
    
    Reported by Andrei Badea.


 org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java b/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java
index c4d74e4d..89a535cf 100644
--- a/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java
+++ b/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java
@@ -3,7 +3,7 @@
 * Copyright (c) 2004-2005, PostgreSQL Global Development Group
 *
 * IDENTIFICATION
-*   $PostgreSQL: pgjdbc/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java,v 1.35 2007/04/16 16:16:21 jurka Exp $
+*   $PostgreSQL: pgjdbc/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java,v 1.36 2007/07/15 15:33:33 jurka Exp $
 *
 *-------------------------------------------------------------------------
 */
@@ -3756,7 +3756,7 @@ public abstract class AbstractJdbc2DatabaseMetaData
 
         if( connection.haveMinimumServerVersion("7.4"))
         {
-            sql += " CASE i.indexprs WHEN null THEN a.attname ELSE pg_get_indexdef(ci.oid,a.attnum,false) END AS COLUMN_NAME, ";
+            sql += " CASE WHEN i.indexprs IS NULL THEN a.attname ELSE pg_get_indexdef(ci.oid,a.attnum,false) END AS COLUMN_NAME, ";
         }
         else
         {


[parent: 3a3526ba7299]