Decode() function fails in 8.1.5/Linux

From: Kevin O'Gorman <kevin_at_trixie.kosman.via.ayuda.com>
Date: Tue, 02 Nov 1999 10:35:15 -0800
Message-ID: <381F2EE3.6E77C408@trixie.kosman.via.ayuda.com>

I'm running 8.1.5 (8i) Enterprise Edition on RedHat Linux, and trying to execute some of the queries from the TPC-D benchmark suite (for research).

Infortunately, all of the queries with the decode() function in the select list fail. They all take the default value no matter what the other inputs are, it seems.

The pattern is

select

decode(gb_attribute, "foo", expr, 0) from

<some tables>

where

<some conditions>

group by

       gb_attribute,


       <and possibly some others>

Now it does seem that this should work: the group-by attribute is available, and constant per output row. However, the result is always zero.

Any clues out there? Any confirmation that this happens elsewhere?

--
Kevin O'Gorman (805) 650-6274 kogorman_at_pacbell.net At school: kogorman_at_cs.ucsb.edu
Permanent e-mail forwarder: Kevin.O'Gorman.64_at_Alum.Dartmouth.org Received on Tue Nov 02 1999 - 12:35:15 CST