Re: FLOAT(0)

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 3 Mar 2004 04:22:19 -0800
Message-ID: <1e8276d6.0403030422.f037204@posting.google.com>

"TomekS" <t.smolarek_at_distriland.com.pl> wrote in message news:<c243g0$idg$1_at_nemesis.news.tpi.pl>...
> Hi
> Is FLOAT(0) datatype possible in 9.2.0.4 database?
>
> I'm asking because I've got a problem with database after upgrade from 8.1.7
> to 9204 - all NUMBER columns are FLOAT(0) now. Some selects are not working
> properly with CBO and working fine with RBO.

Quick test:

SQL> create table test1 (id float(0));
create table test1 (id float(0))

                              *

ERROR at line 1:
ORA-01724: floating point precision is out of range (1 to 126)

It looks like your upgrade process was not flawless.

--
Dusan Bolek

Email: spambin_at_seznam.cz
Pls add "Not Guilty" to the subject, otherwise your email is going to
be burnt as a SPAM.

Received on Wed Mar 03 2004 - 06:22:19 CST