General Bug Report: JDBC driver metadata error

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Depetrini Daniele
Your email address : dany(at)nethouse(dot)it

Category : runtime: back-end: SQL
Severity : non-critical

Summary: JDBC driver metadata error

System Configuration
--------------------
Operating System : linux 2.2.1 slackware 3.6

PostgreSQL version : 6.4.2

Compiler used : gcc 2.7.2

Hardware:
---------
Linux nt1 2.2.1 #3 Wed Feb 10 15:34:11 CET 1999 i586 unknown
AMD k6 300, 64M ram

Versions of other tools:
------------------------
make

--------------------------------------------------------------------------

Problem Description:
--------------------
With the JDBC driver, performing a query with the 'AS' clause renaming a column, the correspondig meta-data is set to NULL value.

--------------------------------------------------------------------------

Test Case:
----------
SELECT nr AS n,squadra1.nome AS squadraA,squadra2.nome AS squadraB,valore FROM partite, squadre squadra1, squadre squadra2,colonne WHERE (id_giornata=57) and(squadra1.id=partite.id_squadra1)and(squadra2.id=partite.id_squadra2)and(ref_nr=nr)and(ref_schedina=10)ORDER BY nr;
and then get the metadata from squadraA.

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------