Bug: getColumns returns bad data for numeric types in 7.3.2 - Mailing list pgsql-jdbc

From Michael L. Gantz
Subject Bug: getColumns returns bad data for numeric types in 7.3.2
Date
Msg-id 3E5B836D.9080803@barcodesolutions.com
Whole thread Raw
Responses Re: Bug: getColumns returns bad data for numeric types in  (Barry Lind <blind@xythos.com>)
List pgsql-jdbc
The metadata method getColumns is returning bad data for numeric types.
  If I apply the following patch it fixes the problem.  Could someone
confirm this and have whoever tracks this piece of code apply this patch?

Short version :

2340c2340
<                               int attypmod = rs.getInt(8) - VARHDRSZ;
---
 >                               int attypmod = rs.getInt(6) - VARHDRSZ;


Context version :

*** AbstractJdbc1DatabaseMetaData.java.old      Mon Feb 24 18:04:03 2003
--- AbstractJdbc1DatabaseMetaData.java  Mon Feb 24 18:03:47 2003
***************
*** 2337,2343 ****
                         }
                         else if (pgType.equals("numeric") ||
pgType.equals("decimal"))
                         {
!                               int attypmod = rs.getInt(8) - VARHDRSZ;
                                 tuple[6] = Integer.toString( ( attypmod
 >> 16 ) & 0xffff ).getBytes();
                                 tuple[8] = Integer.toString(attypmod &
0xffff).getBytes();
                                 tuple[9] = "10".getBytes();
--- 2337,2343 ----
                         }
                         else if (pgType.equals("numeric") ||
pgType.equals("decimal"))
                         {
!                               int attypmod = rs.getInt(6) - VARHDRSZ;
                                 tuple[6] = Integer.toString( ( attypmod
 >> 16 ) & 0xffff ).getBytes();
                                 tuple[8] = Integer.toString(attypmod &
0xffff).getBytes();
                                 tuple[9] = "10".getBytes();





Thanks,
Michael L. Gantz




pgsql-jdbc by date:

Previous
From: "Agrawal, Manish"
Date:
Subject: Re: PgAdmin problem
Next
From: Barry Lind
Date:
Subject: Re: Bug: getColumns returns bad data for numeric types in