IT mysql_test index_merge_sqlgen_exprs failed

[jebter]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

https://ci.pingcap.net/blue/organizations/jenkins/tidb_ghpr_integration_common_test/detail/tidb_ghpr_integration_common_test/10243/pipeline/#step-455-log-172
[2022-03-19T03:08:42.168Z] time="2022-03-19T07:13:26+08:00" level=error msg="run test [index_merge_sqlgen_exprs] err: sql:select /*+ use_index_merge( tbl_0 ) / col_2 from tbl_0 where tbl_0.col_7 < -3 or tbl_0.col_0 between 9060299941946973014 and 7937566432067816132 and interval( left( tbl_0.col_6 , 4 ) , tbl_0.col_7 , tbl_0.col_5 ) order by tbl_0.col_0,tbl_0.col_1,tbl_0.col_2,tbl_0.col_3,tbl_0.col_4,tbl_0.col_5,tbl_0.col_6,tbl_0.col_7 for update;: failed to run query \n"select /+ use_index_merge( tbl_0 ) / col_2 from tbl_0 where tbl_0.col_7 < -3 or tbl_0.col_0 between 9060299941946973014 and 7937566432067816132 and interval( left( tbl_0.col_6 , 4 ) , tbl_0.col_7 , tbl_0.col_5 ) order by tbl_0.col_0,tbl_0.col_1,tbl_0.col_2,tbl_0.col_3,tbl_0.col_4,tbl_0.col_5,tbl_0.col_6,tbl_0.col_7 for update;" \n around line 71, \nwe need(468):\niFv\t13809\t2000-07-29 00:00:00\t53\ntHsbZRjxAwnw\t7068\t2029-06-15 00:00:00\t94\nKmxI\t17383\t2014-08-30 00:00:00\t103\nXB\t16463\t1975-06-16 00:00:00\t58\nCSfkFohsVVxSAZWEXe\t-30899\t1979-07-01 00:00:00\t78\nDGXqwpzwVGqMZ\t-31276\t2007-12-01 00:00:00\t86\nVRuSqf\t10983\t1974-12-13 00:00:00\t83\nselect /+ use_index_merge( tbl_0 ) / col_2 from tbl_0 where tbl_0.col_7 < -3 or tbl_0.col_0 between 9060299941946973014 and 7937566432067816132 and interval( left( tbl_0.col_6 , 4 ) , tbl_0.col_7 \nbut got(468):\nselect /+ use_index_merge( tbl_0 ) */ col_2 from tbl_0 where tbl_0.col_7 < -3 or tbl_0.col_0 between 9060299941946973014 and 7937566432067816132 and interval( left( tbl_0.col_6 , 4 ) , tbl_0.col_7 , tbl_0.col_5 ) order by tbl_0.col_0,tbl_0.col_1,tbl_0.col_2,tbl_0.col_3,tbl_0.col_4,tbl_0.col_5,tbl_0.col_6,tbl_0.col_7 for update;\ncol_2\n09:46:09\n05:44:03\n22:55:33\n03:53:30\n10:33:55\n13:15:41\n16:22:13\n23:00:00\n04:53:52\n23:47:01\n15:01:45\nNULL\n13:02:53\n02:36:32\n21:00:17\n\n"

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

master & v6.0.0

[guo-shaoge]

Introduced by #32553. I added this case in ci, but it needs tikv to reproduce this bug.