pingcap / pingcap/tidb

DNF on different column is not pushing down to I_S

Open
#55,243 0 comments 0 reactions 0 assignees View on GitHub
type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

The second query is not pushing down

```
mysql> explain select * from information_schema.tables where table_name = 'a';
+----------------+----------+------+---------------+------------------+
| id | estRows | task | access object | operator info |
+----------------+----------+------+---------------+------------------+
| MemTableScan_5 | 10000.00 | root | table:TABLES | table_name:["a"] |
+----------------+----------+------+---------------+------------------+
1 row in set (0.01 sec)

mysql> explain select * from information_schema.tables where table_name = 'a' or table_schema = 'b';
+----------------------+----------+------+---------------+------------------------------------------+
| id | estRows | task | access object | operator info |
+----------------------+----------+------+---------------+------------------------------------------+
| Selection_5 | 8000.00 | root | | or(eq(Column#3, "a"), eq(Column#2, "b")) |
| └─MemTableScan_6 | 10000.00 | root | table:TABLES | |
+----------------------+----------+------+---------------+------------------------------------------+
2 rows in set (0.00 sec)
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.