pingcap / pingcap/tidb

Plan Cache: `?*?` leads to unexpected error in Plan Cache

Open
#57,319 4 comments 0 reactions 0 assignees View on GitHub
fuzz/comp severity/minor sig/planner type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

```
CREATE TABLE `IDT_MULTI15760STROBJSTROBJ` (
`COL1` set('^YSQT0]V@9TFN>^WB6G?NG@S8>VYOM;BSC@64=ZISGS?O[JDFBI5M]QXJYQNSKU>NGAWLXS26LMTZ2YNN`XKIUGKY0IHDWV>E[BJJCABOKH1M^CB5E@DLS7Q88PWZTEAY]1ZQMN5NX[IFIYA983K:E4N77@FINM5HVGQCUCVNF5WLOOOEORAM=_JLMVFURMUASTVDBE','NL3V:J9LM4U5KUCVR;P','M5=T5FLQEZMPZAXH]4G:TSYYYVQ7O@4S6C3N8WPFKSP;SRD6VW@94BBH8XCT','P]I52Y46F?@RMOOF6;FWDTO`7FIT]R:]ELHD[CNLDSHC7FPBYOOJXLZSBV^5C^AAF6J5BCKE4V9==@H=4C]GMZXPNM','ECIQWH>?MK=ARGI0WVJNIBZFCFVJHFIUYJ:2?2WWZBNBWTPFNQPLLBFP9R_','E<_Y9OT@SOPYR72VIJVMBWIVPF@TTBZ@8ZPBZL=LXZF`WM4V2?K>AT','PZ@PR6XN28JL`B','ZOHBSCRMZPOI`IVTSEZAIDAF7DS@1TT20AP9','QLDIOY[Y:JZR@OL__I^@FBO=O_?WOOR:2BE:QJC','BI^TGJ_NEEXYKV1POHTOJQPGCPVR=TYZMGWABUQR07J8U::W4','N`ZN4P@9T[JW;FR6=FA4WP@APNPG[XQVIK4]F]2>EC>JEIOXC``;;?OHP') DEFAULT NULL,
`COL2` tinyint DEFAULT NULL,
`COL3` date DEFAULT NULL,
KEY `U_M_COL4` (`COL1`,`COL2`) /*!80000 INVISIBLE */,
KEY `U_M_COL5` (`COL3`,`COL2`) /*!80000 INVISIBLE */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
```
[data.csv](https://github.com/user-attachments/files/17714646/data.csv)
**Use` | `Split csv file**
```
prepare stmt from 'SELECT * FROM IDT_MULTI15760STROBJSTROBJ WHERE col2 = ? AND COL2 * ? != ?;';
set @a=126, @b=126, @c=126;
execute stmt using @a,@b,@c;
set @a=-119, @b=-119, @c=-119;
execute stmt using @a,@b,@c;
set @a=93, @b=-110, @c=-78;
execute stmt using @a,@b,@c;
set @a=892849545565, @b=307794851912, @c=-1045704790071;
execute stmt using @a,@b,@c;
```

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

### 3. What did you see instead (Required)
Error 1815 (HY000): expression ne(mul(892849545565, 307794851912), -1045704790071) cannot be pushed down

### 4. What is your TiDB version? (Required)

Release Version: v8.5.0-alpha-91-g169210aaaa
Edition: Community
Git Commit Hash: 169210aaaaba599d555c689786305c4a297edd7c
Git Branch: HEAD
UTC Build Time: 2024-11-11 17:04:25
GoVersion: go1.23.2
Race Enabled: false
Check Table Before Drop: false
Store: tikv

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.