Обсуждение: General Bug Report: Case statements in selects with table joins causes psql to abort
General Bug Report: Case statements in selects with table joins causes psql to abort
От
Unprivileged user
Дата:
============================================================================ 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: --------- --------------------------------------------------------------------------