General Bug Report: JDBC driver metadata error
От | Unprivileged user |
---|---|
Тема | General Bug Report: JDBC driver metadata error |
Дата | |
Msg-id | 199902231737.MAA18303@hub.org обсуждение исходный текст |
Ответы |
Re: [BUGS] General Bug Report: JDBC driver metadata error
|
Список | 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 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: --------- --------------------------------------------------------------------------
В списке pgsql-bugs по дате отправления: