Re: truncate partition not happening

[samir devaliya]

please find the O/P

mysql> SELECT SQL_NO_CACHE * FROM dist_product_clover ;
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
| sourceid | sku | isavailable | warehouseid | qtyonhand | lastmodeifiedon | activeflag | qtyonorder | pandarequestid |
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 0 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 0 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 1 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 1 | NULL | NULL |
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
4 rows in set (0.00 sec)

mysql> alter table dist_product_clover truncate partition p0;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from dist_product_clover;
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
| sourceid | sku | isavailable | warehouseid | qtyonhand | lastmodeifiedon | activeflag | qtyonorder | pandarequestid |
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 0 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 0 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 1 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 1 | NULL | NULL |
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
4 rows in set (0.00 sec)


kindly suggest

regards
Samir