Re: Is it possible to get MORE results by adding an AND clause to a SQL query?

[kris helenek]

Chad, thank you for responding. I assume you mean to use Decimal, since Double is just a larger storage Float?

It is confusing because the above statements all work perfectly fine when I dumped and restored the database. That led me to believe that if the value of a float is 1.2345 that I could do "where value = 1.2345". This is probably my misunderstanding. However I think there is still a problem.

Just to defend myself on my first post, I did not post my table definitions because I wasn't really looking for query help, I was just trying to point out that I was seeing behavior that should never happen, regardless of what my table definitions are. In other words, I don't think it should be possible to get the behavior I got even if you tried. I was looking for confirmation before I submitted a MySql bug report.

So does that makes sense? Should I post a bug report or am I missing something else?