Bug #86951 !~~~tables PARTITION BY RANGE
Submitted: 5 Jul 2017 9:22 Modified: 5 Jul 2017 10:21
Reporter: wang jian Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.5.51-5.5.55 OS:CentOS (6.8 X86_64)
Assigned to: CPU Architecture:Any
Tags: Tables PARTITION BY RANGE

[5 Jul 2017 9:22] wang jian 
Description:
对表按主键ID与创建时间字段结合做分区表,表引擎为INNODB,在select查询时,AND条件中的字段,如果显示时在select中就会出现查询数据不完整.
举例:
查询tab.abc值为1的数据,并全部显示tab.abc或者主键字段的值时,有多行就会出现只显示4行.
select tab.abc from tab where tab.abc = '1';

查询tab.abc值为1的数据,并全部显示tab.ddd的值,或者tab.*时,显示数据就会正常.
select tab.ddd from tab where tab.abc = '1';

在MYSIAM引擎中不会出现此问题.

How to repeat:
目前将表引擎改为myisam引擎
[5 Jul 2017 9:43] MySQL Verification Team 
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.