============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Pierluigi Frullani
Your email address : pigi@frumar.it
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Architecture Other : Ultra 250
Operating System (example: Linux 2.0.26 ELF) : Linux 2.0.33 ELF
Operating System : Solaris 2.6
PostgreSQL version (example: PostgreSQL-6.4.2) : PostgreSQL-6.4.2
PostgreSQL version : PostgreSQL-6.3
Compiler used (example: gcc 2.8.0) : gcc 2.7.2.3
For solaris we used the bin distrib.
Please enter a FULL description of your problem:
------------------------------------------------
In a select with a sub select if you use a true condition as " AND 1 = 1 "
in the 6.4.2. you will get no result and in the 6.3 you will get coredump
This is needed when we compose the query string and we have no other condition.
In informix and oracle it work.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
we use this select :
SELECT chiamate.n_chiam, chiamate.probl, clienti.rag_soc,
chiamate.contatto, chiamate.severita,
tabseverita.desseverita, esecutori.cognome,
stato_chiamata.des_stato , chiamate.data_aper,
tabseverita.colore , chiamate.dta_primo_cont
FROM chiamate,chiamatedet,commesse,esecutori,clienti,
tabseverita,stato_chiamata
WHERE chiamatedet.n_chiam = chiamate.n_chiam
AND chiamatedet.data_ult = (select max(b.data_ult)
from chiamatedet b
where b.n_chiam= chiamate.n_chiam
AND 1 = 1) <=== here the problem.
AND chiamate.cod_com = commesse.cod_com
AND chiamatedet.stato_chiamata=stato_chiamata.cod_stato
AND chiamatedet.cod_ese = esecutori.cod_ese
AND commesse.cod_soc_cli = clienti.cod_societa
AND tabseverita.codseverita = chiamate.severita
AND stato_chiamata.flag_stato='O'
ORDER BY chiamate.n_chiam
If we do not use the showed condition the select will work .
Here attached there is the dump of our database