pingcap / pingcap/tidb

Need to improve the execution efficiency of the ifnull function.

Open
#47,622 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

## Enhancement
when sql add condition ```AND ((IFNULL(t.a,0) + IFNULL(t.b,0)) != (IFNULL(t.c,0) + IFNULL(t.d,0))))``` ,The execution time will increase exponentially
Need improve exec efficiency for `ifnull` function
image

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.