Re: Wrong count(*)

[larry]

mysql> SELECT COUNT(*) FROM vote IGNORE INDEX (model_2) WHERE model=49;
+----------+
| COUNT(*) |
+----------+
| 4 |
+----------+
1 row in set (0.04 sec)

mysql> SELECT COUNT(id) FROM vote IGNORE INDEX (model_2) WHERE model=49;
+-----------+
| COUNT(id) |
+-----------+
| 4 |
+-----------+
1 row in set (0.00 sec)

mysql>

Dump: http://83.142.27.226/vote.dump

So the problem seems to be with index handling. First there was another index model on field model, but, as I got from docs, it is not needed as mysql can use beginning of composite (forgot correct word) index.
Excuse my english, I write much worse, than read :(



Edited 1 time(s). Last edit at 11/16/2005 05:10AM by larry.