From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | General Bug Report: JDBC driver metadata error |
Date: | 1999-02-23 17:37:13 |
Message-ID: | 199902231737.MAA18303@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
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:
---------
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1999-02-24 23:21:25 | Re: [BUGS] General Bug Report: JDBC driver metadata error |
Previous Message | Bruce Momjian | 1999-02-22 02:42:06 | Re: [BUGS] Bug with a join and group by query. |