Re: Undocumented SQL REVERSE function.

From: Syltrem <syltremspammenot_at_videotron.com>
Date: Fri, 2 Aug 2002 13:53:15 -0400
Message-ID: <pEz29.7701$H67.40957@tor-nn1.netcom.ca>

As others reported, it does not crash every version 8.1.6.0 on OpenVMS does not crash either

I still don't know when will be the 1st time I'll be using this function though.

SQL> SELECT REVERSE(12345) FROM dual;

REVERSE(12345)

-7.790E+33
TINRCS Fri 2-AUG-2002 13:46:35 HELIOS::DGSI_A1:[TREMBLAY.ORACLE] ORACLE 1 row selected.

SQL> SELECT REVERSE(SYSDATE) FROM dual;

REVERSE(SYS

13-., -8448

1 row selected.

SQL> SELECT REVERSE(null) FROM dual;

R
-

1 row selected.

SQL> Exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address

"Nuno Souto" <nsouto_at_optushome.com.au.nospam> a écrit dans le message de
news: 3d4a84d5$0$29910$afc38c87_at_news.optusnet.com.au...


> In article <1e8276d6.0208012301.733c5775_at_posting.google.com>, you said

> (and I quote):

> > Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message

news:<3D49A7B2.D50B3490_at_exesolutions.com>...


> >

> > > Interesting. I especially enjoy

> > >

> > > SELECT REVERSE(12345) FROM dual;

> > > and

> > > SELECT REVERSE(SYSDATE) FROM dual;

> > >

> > > SELECT REVERSE(null) FROM dual brings SQL*Plus down in an

> > > unceremonious crash.

> >

> > I don't think so (for EE 8.1.7.1.0 32-bit NT):

> >

> > TBD01/SYSTEM>connect dbolek_at_DB813.world

> > Enter password: ******

> > Connected.

> > DB813/DBOLEK>SELECT REVERSE(null) FROM dual;

> >

> > R

> > -

> >

> > Sounds right, reverse from NULL is NULL. Expected behaviour.

> >

>


> It dies if you do the sequence of events he did.  Try doing the crazy

> ones: 12345 and sysdate.  THEN do the null one.  Or just try to exit

> SQL*Plus and see how it crashes.  8.1.7, Winblows 2K here.

>


> --

> Cheers

> Nuno Souto

> nsouto_at_optushome.com.au.nospam

Received on Fri Aug 02 2002 - 12:53:15 CDT