============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Michael Davis
Your email address : mdavis@sevainc.com
Category : runtime: back-end: SQL
Severity : serious
Summary: Case statements in selects with table joins causes psql to abort
System Configuration
--------------------
Operating System : Red Hat 5.1 linux 2.0.34 ELF
PostgreSQL version : 6.5
Compiler used : gcc version 2.7.2.3
Hardware:
---------
Dual Pentium II, 128M RAM
Linux linus 2.0.34 #12 Tue Oct 6 23:24:13 MDT 1998 i686 unknown
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
Case statements in selects with table joins causes psql to abort
--------------------------------------------------------------------------
Test Case:
----------
The following works:
1) SELECT OrderTypeID, invoiceid, (CASE OrderTypeID WHEN 1 THEN 'OrderTypeName'::text ELSE 'iname'::text END) as
invdesc
FROM Invoice
WHERE invoiceid = 16476;
The following causes psql to abort:
2) SELECT i.OrderTypeID, i.invoiceid, il.memberid, (CASE i.OrderTypeID WHEN 1 THEN 'OrderTypeName'::text ELSE
'iname'::textEND) as invdesc
FROM Invoice i, InvoiceLines il
WHERE i.invoiceid = 16476 and i.InvoiceID = il.InvoiceID and il.memberid = 685;
The following causes psql to abort:
3) SELECT OrderTypeID, invoiceid, (CASE OrderTypeID WHEN 1 THEN 'OrderTypeName'::text ELSE 'iname'::text END) as
invdesc
FROM InvoiceInvoiceLines
WHERE invoiceid = 16476;
InvoiceInvoiceLines is view that basically looks just like #2 about
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------