incorrect tableDual plan caused by corner case values and partition

[wjhuang2016]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `t428fc8c8` (
  `col_51` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`col_51`) /*T![clustered_index] CLUSTERED */,
  UNIQUE KEY `idx_28` (`col_51`),
  KEY `idx_29` (`col_51`),
  KEY `idx_31` (`col_51`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
PARTITION BY HASH (`col_51`) PARTITIONS 4;
desc SELECT 1  FROM `t428fc8c8` WHERE `t428fc8c8`.`col_51` BETWEEN 9223372036854775807 AND 9223372036854775808;

2. What did you expect to see? (Required)

TableScan

3. What did you see instead (Required)

mysql> desc SELECT 1  FROM `t428fc8c8` WHERE `t428fc8c8`.`col_51` BETWEEN 9223372036854775807 AND 9223372036854775808;
+-------------------+---------+------+---------------+---------------+
| id                | estRows | task | access object | operator info |
+-------------------+---------+------+---------------+---------------+
| Projection_6      | 0.00    | root |               | 1->Column#2   |
| └─TableDual_7     | 0.00    | root |               | rows:0        |
+-------------------+---------+------+---------------+---------------+
2 rows in set, 1 warning (0.00 sec)

4. What is your TiDB version? (Required)

cb7d2b7

[wjhuang2016]

It's correct if the table is not partition table:

mysql> desc SELECT 1  FROM `t428fc8c8` WHERE `t428fc8c8`.`col_51` BETWEEN 9223372036854775807 AND 9223372036854775808;
+--------------------------+---------+-----------+-----------------+---------------------------------------------------------------------------------+
| id                       | estRows | task      | access object   | operator info                                                                   |
+--------------------------+---------+-----------+-----------------+---------------------------------------------------------------------------------+
| Projection_4             | 1.00    | root      |                 | 1->Column#2                                                                     |
| └─TableReader_6          | 1.00    | root      |                 | data:TableRangeScan_5                                                           |
|   └─TableRangeScan_5     | 1.00    | cop[tikv] | table:t428fc8c8 | range:[9223372036854775807,9223372036854775808], keep order:false, stats:pseudo |
+--------------------------+---------+-----------+-----------------+---------------------------------------------------------------------------------+
3 rows in set (0.00 sec)