Skip to content

unexpected dropping predicate for memtable  #40937

@zhongzc

Description

@zhongzc

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql [email protected]:information_schema> explain select * from `CLUSTER_HARDWARE` where `TYPE`;
+----------------+----------+------+------------------------+---------------+
| id             | estRows  | task | access object          | operator info |
+----------------+----------+------+------------------------+---------------+
| MemTableScan_5 | 10000.00 | root | table:CLUSTER_HARDWARE |               |
+----------------+----------+------+------------------------+---------------+

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

mysql [email protected]:information_schema> explain select * from `CLUSTER_HARDWARE` where `TYPE`;
+------------------+----------+------+------------------------+---------------+
| id               | estRows  | task | access object          | operator info |
+------------------+----------+------+------------------------+---------------+
| Selection_5      | 8000.00  | root |                        | Column#1      |
| └─MemTableScan_6 | 10000.00 | root | table:CLUSTER_HARDWARE |               |
+------------------+----------+------+------------------------+---------------+

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

master

Metadata

Metadata

Assignees

No one assigned

    Labels

    affects-6.1This bug affects the 6.1.x(LTS) versions.affects-6.5This bug affects the 6.5.x(LTS) versions.severity/moderatesig/plannerSIG: Plannertype/bugThe issue is confirmed as a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions