Anyone know what this is? (MySQL)
This is a table:
fix mysql. most of the people use it because they can get the source and "we can fix it".
Maybe OSX comes with more apples and bananas than Windows :-)
Not a bad thought, though I dont know jack about OSX and Im not in a position to dictate platform choices for my client.
Do you get the expected results if you do COUNT(*) or COUNT(ID) instead of COUNT(Fruit)?
MySQL 3.23.58-Max produces correct result on Red Hat Linux.
Evgeny Gesin /Javadesk.com/
Konrad > No, any count /group by statement produces very weird numbers.
But your client saved a bunch of money didn't they?
I've never seen that type of error on my copy of MySQL running on my Mac. I can try this later today and verify, but I haven't seen any strange behavior like this. And yes, MySQL has been on the Mac for quite a while, and this sounds like a possibly hosed config/install.
Academically, it would be interesting to know what part of the install/config could be so hosed that the thing can't COUNT. That's really impressive. :-p
Brad Wilson (dotnetguy.techieswithcats.com)
>Are you sure there are no decimals hidden in that long numeric?
I was taking a guess that the MySQL installation was improperly told the type of device it was running on (x86 versus PPC, etc) and this was some result of that (big-endian little-endian and whatnot). Of course I'm not certain it would even compile in that state.
This does look exactly like a problem with numeric representation. Try a recompile and reinstall. Also give a shot at SELECT * FROM tblFruit and see if you notice anything funky, in case the database is corrupt.
I believe this is a bug in the MySQL compiled for Panther SERVER. Installing the MySQL from www.mysql.com will fix the problem. See the Apple message boards for more info.
Michael H. Pryor (fogcreek)
It is an incorrectly installed version of Mysql, more than likely some unix flavor was installed instead of the mac version. The in correct counts are because of how different OS's consider the sizes of ints, floats, and so on.
Great responses ppl. Thanks.
Good that you got an answer. But I have another question, why the general anger at MySql?
Because MySQL is a horrible SQL DBMS that is, really, barely a DBMS.
What you're getting doesn't look like one of these, but it's certainly worth a read of this page:
Fog Creek Home