Re: 10g Bug with Numeric Precision/Scale?

James Carr wrote:
> I've found a 10.1.0.4.0 machine
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bi
> PL/SQL Release 10.1.0.4.0 - Production
> CORE 10.1.0.4.0 Production
> TNS for Solaris: Version 10.1.0.4.0 - Production
> NLSRTL Version 10.1.0.4.0 - Production
>
> I still get the same strange behaviour as on 10.1.0.3
>
> 1.23100007
> 1.23
> 1.23
> 1.231
> 1.23100007
> 1.23100007
> 1.23100007
> 1.231
>
> Daniel, when you tried it on 10.1.0.4.0 how did you get the correct
> answer?
>
> ~
> James

Just re-ran it in 10.1.0.4 and got the same thing you did.

I can't go into what I ran it on where it ran correctly due to NDA but I wasn't where I thought I was. Sorry.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)