Comment 4 for bug 1067051

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

Verified with recent Percona server 5.5.28 also:

...
mysql> explain partitions SELECT * FROM test_nico WHERE time_id >= '2012-10-09 00:00:00' AND time_id < '2012-10-16 00:00:00' AND cid = 'TpqiCvy6S9af5KbEL5fQ'\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: test_nico
   partitions: PM_2010_01_31,PM_2010_02_28,PM_2010_03_31,PM_2010_04_30,PM_2010_05_31,PM_2010_06_30,PM_2010_07_31,PM_2010_08_31,PM_2010_09_30,PM_2010_10_31,PM_2010_11_30,PM_2010_12_31,PM_2011_01_31,PM_2011_02_28,PM_2011_03_31,PM_2011_04_30,PM_2011_05_31,PM_2011_06_30,PM_2011_07_31,PM_2011_08_31,PM_2011_09_30,PM_2011_10_31,PM_2011_11_30,PM_2011_12_31,PM_2012_01_31,PM_2012_02_29,PM_2012_03_31,PM_2012_04_30,PM_2012_05_31,PM_2012_06_30,PM_2012_07_31,PM_2012_08_31,PM_2012_09_30,PM_2012_10_31,PM_2012_11_30,PM_2012_12_31
         type: ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 20
          ref: const
         rows: 36
        Extra: Using where; Using index
1 row in set (0.00 sec)

mysql> show variables like '%ver%';
+----------------------------------+------------------------------+
| Variable_name | Value |
+----------------------------------+------------------------------+
| character_set_server | utf8 |
| collation_server | utf8_unicode_ci |
| innodb_force_recovery | 0 |
| innodb_recovery_stats | OFF |
| innodb_recovery_update_relay_log | OFF |
| innodb_show_verbose_locks | 0 |
| innodb_version | 1.1.8-29.0 |
| log_slow_verbosity | |
| myisam_recover_options | OFF |
| protocol_version | 10 |
| relay_log_recovery | OFF |
| rpl_recovery_rank | 0 |
| server_id | 0 |
| slave_type_conversions | |
| version | 5.5.28 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+----------------------------------+------------------------------+
18 rows in set (0.00 sec)

mysql> show variables like 'char%';
+--------------------------+---------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /home/openxs/dbs/p5.5/share/charsets/ |
+--------------------------+---------------------------------------+
8 rows in set (0.00 sec)