Doubt related UPPER with spatial

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Thu, 15 Mar 2012 14:35:12 -0300
Message-ID: <CAJdDhaMJ8wxhOqTAYigjAEjc0w_kLBTeWk64Kkx2G3xiBOW_zg_at_mail.gmail.com>

Hello friends:
I have the following doubt related to UPPER.

• This sql does not run right SELECT tb1.id, upper('lote'), UPPER(tb2.FEATURE_TYPE), tb2.ID, tb2.feature_type, tb2.GEOMETRY FROM CH tb1, LOT tb2 WHERE SDO_RELATE(tb2.GEOMETRY,tb1.GEOMETRY,'mask=inside querytype=WINDOW') = 'TRUE' and UPPER(tb2.FEATURE_TYPE) = UPPER('lote')
• This one run right SELECT tb1.id, upper('lote'), UPPER(tb2.FEATURE_TYPE), tb2.ID, tb2.feature_type, tb2.GEOMETRY FROM CH tb1, LOT tb2 WHERE SDO_RELATE(tb2.GEOMETRY,tb1.GEOMETRY,'mask=inside querytype=WINDOW') = 'TRUE' and tb2.FEATURE_TYPE = 'lote';

        ID UPPER('LOTE') UPPER(LOT_F.FEATURE_TYPE)
ID          FEATURE_TYPE


----------- -------------

----------------------------------------------------------------------

----------- ----------------

         86 LOTE
 LOTE
 92         lote
         93 LOTE
 LOTE
91         lote

The content of the column feature_type is: FEATURE_TYPE

---

lote
lote
lote
What is wrong ?
Why UPPER does not work in this case?
Any idea ?

Regards
Eriovaldo

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 15 2012 - 12:35:12 CDT