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;
Other related posts:
