Bug #13323 select count(*) error in partition engine

• Submitted: 19 Sep 2005 14:00
• Modified: 19 Sep 2005 21:38
• Reporter: Tomas Ulin
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.1
• Assigned to: Mikael Ronström
• CPU Architecture: Any

[19 Sep 2005 14:00] Tomas Ulin

Description:
master> CREATE TABLE t1 ( a int NOT NULL primary key, b int default NULL) ENGINE=myisam DEFAULT CHARSET=latin1 COLLATE=latin1_bin PARTITION BY KEY (a);
Query OK, 0 rows affected (0.01 sec)

master> select count(*) from t1;
+----------+
| count(*) |
+----------+
|        2 |
+----------+
1 row in set (0.00 sec)

master> 

How to repeat:
see above

Suggested fix:
see above

[19 Sep 2005 21:38] Mikael Ronström

Small fix for calculating records when HA_NOT_EXACT_COUNT not set