apparent mysql float behavior change from 4.0 to 4.1 (without any warning?)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I've got some strange mysql behavior, wondered if anyone encountered it.
 
I have a database with some float(4,3) fields.
I have a version of this running on mysql 4.0[.23], and another running
on mysql 4.1[.7].
When I insert, for example, 12 into it - the 4.0 version stores '12.00'
- but the 4.1 version stores '9.999'.  It seems that mysql made a change
somewhere between 4.0 and 4.1 to force the decimal space of floats.
 
This is all well and good, I rather like losing data - it builds
character - but I've thoroughly checked their changelogs and have found
nothing to indicate this behavior change.
 
It's likely a change for sql compliance - but just to forewarn anyone
who may want to do an upgrade - this isn't an issue I've found written
out anywhere.
 
Has anyone seen this anywhere?
 
****
Incidentally, I tried to warn that this was O  -  T...
> Hi. This is the qmail-send program at pb1.pair.com.
> I'm afraid I wasn't able to deliver your message to the following
addresses. This is a permanent error; I've given up. Sorry it didn't
work out.
> <php-db@xxxxxxxxxxxxx>:
> Apparent off-topic email rejected.
It's good to know that you can post O  -  T to a list, but if you dare
to indicate it as such (with the bracketed Oh-Tee indicator at the start
of the subject) as a service to those uninterested, your mail won't go
through.  That's good policy - stomp on the good citizens and make them
misbehave.

Cheers,
- Martin Norland, Database / Web Developer, International Outreach x3257

The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital. 
 

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux