Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.0.8
-
centos 7; XFS
Description
CalShowPartitions is not working properly to show partitions
{{MariaDB [lkqd_stats]> select theDate,count(theDate) from lkqd_daily group by 1 order by 1;
--------------------------+
theDate | count(theDate) |
--------------------------+
2017-04-13 | 30646909 |
2017-04-14 | 25754602 |
--------------------------+
2 rows in set (1.02 sec)
MariaDB [lkqd_stats]> select calShowPartitionsByValue('lkqd_daily','theDate','2017-04-13','2017-04-13');
ERROR 1815 (HY000): Internal error: IDB-2040: No partition found for the given value range.
MariaDB [lkqd_stats]> select calShowPartitionsByValue('lkqd_daily','theDate','2017-04-14','2017-04-14');
ERROR 1815 (HY000): Internal error: IDB-2040: No partition found for the given value range.
MariaDB [lkqd_stats]> select calShowPartitions('lkqd_daily','theDate');
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
calShowPartitions('lkqd_daily','theDate') |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Part# Min Max Status 0.0.1 2017-04-13 2017-04-14 Enabled 0.1.2 2017-04-13 2017-04-14 Enabled 0.2.1 2017-04-13 2017-04-14 Enabled 0.3.2 2017-04-13 2017-04-14 Enabled |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)}}