RE: Sql Oddity

From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
To: <Richard.Goulet@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 18 Jan 2010 15:43:43 -0500

I've seen the same thing. We were getting null for this in 9i and it was
evaluating true in 10G.

(CASE
  4               WHEN j.INSTALLVALUE = 'On-site Installation'
  5                    OR j.INSTALLVALUE = 'On-site Networking
Installation'
  6                    OR j.INSTALLVALUE = 'Professional'
  7               THEN
  8                  'Full'
  9               ELSE
 10                  j.INSTALLVALUE
 11           END) INSTALLVALUE

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Goulet, Richard
Sent: Monday, January 18, 2010 3:26 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Sql Oddity

 

Folks, 

        Anyone ever seen this:  A developer executes the following code in
an Oracle 9i database (9.2.0.6) 

create table test_date_drop_me (test_column timestamp default sysdate); 
        
insert into test_date_drop_me values (sysdate); 
        
select CASE WHEN systimestamp> t.test_column THEN 1 ELSE 0 END from
test_date_drop_me t;

References:

Sql Oddity
From: Goulet, Richard

RE: Sql Oddity

Other related posts: