Horton

General Bug Report: JDBC driver metadata error

Unprivileged user <nobody>

View thread
From: Unprivileged user <nobody>
To: pgsql-bugs@postgresql.org
Date: 1999-02-23T17:37:13Z
Lists: pgsql-bugs 
============================================================================
                        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 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:
---------


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