X-Original-To: pgsql-jdbc-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 30D2DD1B1CD
	for <pgsql-jdbc-postgresql.org@localhost.postgresql.org>;
	Fri,  2 Jul 2004 22:14:58 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 63532-03
	for <pgsql-jdbc-postgresql.org@localhost.postgresql.org>;
	Sat,  3 Jul 2004 01:14:57 +0000 (GMT)
Received: from smtp107.mail.sc5.yahoo.com (smtp107.mail.sc5.yahoo.com
	[66.163.169.227])
	by svr1.postgresql.org (Postfix) with SMTP id 10EA2D1B174
	for <pgsql-jdbc@postgresql.org>; Fri,  2 Jul 2004 22:14:53 -0300 (ADT)
Received: from unknown (HELO yahoo.com.ar) (dariovfassi@200.80.239.18 with
	plain)
	by smtp107.mail.sc5.yahoo.com with SMTP; 3 Jul 2004 01:14:56 -0000
Message-ID: <40E6088E.6030703@yahoo.com.ar>
Date: Fri, 02 Jul 2004 22:14:54 -0300
From: Dario Fassi <dariovfassi@yahoo.com.ar>
Reply-To: software@sistemat.com.ar
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.0.2) Gecko/20030208 Netscape/7.02
X-Accept-Language: es-ar, es, en
MIME-Version: 1.0
To: pgsql-jdbc@postgresql.org
Subject: Error in DatabaseMetaData.getColumns() with Views
Content-Type: multipart/alternative;
	boundary="------------010207020205090608060300"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_20_30,
	HTML_MESSAGE, HTML_TITLE_EMPTY
X-Spam-Level: *
X-Archive-Number: 200407/22
X-Sequence-Number: 10406

--------------010207020205090608060300
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hi, I wish to report a erroneous information returned by   
DatabaseMetaData.getColumns()  method.

This happens with ResultSet's column (7) COLUMN_SIZE  and  (9) 
DECIMAL_DIGITS ,
when DatabaseMetaData.getColumns() inform about a VIEW with columns 
formed with :
coalesce , case or numeric operations over DECIMAL fields.

Suppose

CREATE TABLE A (  f1 DEC(6,3), f2 dec(6,3) );
CREATE VIEW B as ( select ( f1 + f2 ) as f from a;

Then DatabaseMetaData.getColumns() returns:

VIEW B
    F   NUMERIC(  65535 ,  -65531 )

This error its very molest because if you are trying to do 
CodeGeneration from DatabaseMetaData.

Any suggestion will be appreciated.
Best regards,
Dario Fassi

--------------010207020205090608060300
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
Hi, I wish to report a erroneous information returned by&nbsp;&nbsp; <b>DatabaseMetaData.getColumns()</b>&nbsp; 
method.<br>
 <br>
 This happens with ResultSet's column (7) COLUMN_SIZE&nbsp; and&nbsp; (9) DECIMAL_DIGITS
, <br>
 when DatabaseMetaData.getColumns() inform about a VIEW with columns formed
with :<br>
 coalesce , case or numeric operations over DECIMAL fields.<br>
 <br>
 Suppose <br>
 <br>
 CREATE TABLE A (&nbsp; f1 DEC(6,3), f2 dec(6,3) );<br>
 CREATE VIEW B as ( select ( f1 + f2 ) as f from a;<br>
 <br>
 Then DatabaseMetaData.getColumns() returns:<br>
 <br>
 VIEW B <br>
 &nbsp;&nbsp;&nbsp; F&nbsp;&nbsp; NUMERIC(&nbsp; 65535 ,&nbsp; -65531 )<br>
 <br>
 This error its very molest because if you are trying to do CodeGeneration
from DatabaseMetaData.<br>
 <br>
 Any suggestion will be appreciated.<br>
  Best regards,<br>
  <i>Dario Fassi</i><small><small><font
 face="Helvetica, Arial, sans-serif"><big><br>
 </big></font></small></small>
</body>
</html>

--------------010207020205090608060300--