============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Depetrini Daniele
Your email address : dany@nethouse.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
NULLvalue.
--------------------------------------------------------------------------
Test Case:
----------
SELECT nr AS n,squadra1.nome AS squadraA,squadra2.nome AS squadraB,valore FROM partite, squadre squadra1, squadre
squadra2,colonneWHERE (id_giornata=57)
and(squadra1.id=partite.id_squadra1)and(squadra2.id=partite.id_squadra2)and(ref_nr=nr)and(ref_schedina=10)ORDERBY nr;
and then get the metadata from squadraA.
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------