Re: Empty String IS NOT NULL

Yes, it's a joke. As bitmap indexes stores NULL values (instead of B+ indexes, which don't) they not suffer this bug.

Em ter., 26 de mai. de 2020 às 09:25, Norman Dunbar <oracle_at_dunbar-it.co.uk> escreveu:

> On 26/05/2020 12:40, Luis Claudio Dias dos Santos wrote:
> > Use bitmap indexes! :-)
>
> No, please don't! At least, not in an OLTP or frequently updated system.
> Deadlocks will occur! (Ask me how I know!)
>
> (I did notice the smiley by the way Luis, but some may not have.)
>
>
> Cheers,
> Norm.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> 27a Lidget Hill
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7LG
>
> Company Number: 05132767
>

--
http://www.freelists.org/webpage/oracle-l