-
Notifications
You must be signed in to change notification settings - Fork 6.1k
Closed
Labels
fuzz/schrddlseverity/moderatesig/sql-infraSIG: SQL InfraSIG: SQL Infratype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
CREATE TABLE `17727daf-49e7-415c-83be-74c0ff7665a2` (
`2dbd888c-7a13-402e-b45e-df771c58b8a2` set('p','htwl','rg','5naac','8gnba','5njhl','g2','8kl2','ga9v3','hm89u','v') DEFAULT 'p,5naac',
`b10a5e29-8ec8-49f8-812a-eb6aca85081f` mediumint(9) NOT NULL DEFAULT '-4713386',
`aecbdd04-400d-41e0-93fc-8fe949f3fe71` year(4) NOT NULL DEFAULT '1908',
PRIMARY KEY (`b10a5e29-8ec8-49f8-812a-eb6aca85081f`,`aecbdd04-400d-41e0-93fc-8fe949f3fe71`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_chinese_ci;
CREATE TABLE `4e8a7745-94c7-49f7-b653-3e3e255ccf45` (
`66856456-0550-4ac2-bc3d-484dae5d3655` set('rj','ouk3','y8o','k','vy4en','u1','7jj1','6','kf9ra','5p8g','nud') DEFAULT 'ouk3,y8o'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='db6bab11-18a8-49de-b4af-f237795b7db0';
CREATE TABLE `f93abdb0-c6af-472c-93ab-33432e8fd836` (
`7c0cb0f1-4160-4718-be37-4dcc8bd62155` enum('8hrtq','7xs','jum1p','uyc','pj','vh913','db','i','5nle','si','9y') NOT NULL DEFAULT '7xs',
`e1001878-7411-42aa-b22f-3419a944355c` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`7c0cb0f1-4160-4718-be37-4dcc8bd62155`,`e1001878-7411-42aa-b22f-3419a944355c`) /*T![clustered_index] CLUSTERED */,
UNIQUE KEY `fe523fd1-7161-4d5a-b074-588119679bf1` (`7c0cb0f1-4160-4718-be37-4dcc8bd62155`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;
set @@sql_mode="";
INSERT INTO `17727daf-49e7-415c-83be-74c0ff7665a2` VALUES ('8kl2',-6698594,'1997'), ('8kl2',-6468423,'2004'), ('8kl2',-5661283,'1994'), ('8kl2',-5482103,'1908'), ('8kl2',-5146834,'2018'), ('rg',-4713386,'0000'), ('8kl2',-4713386,'1908'), ('5naac',-4713386,'1987'), ('v',-4713386,'2009'), ('8kl2',-4713386,'2018'), ('8kl2',-4713386,'2027'), ('8kl2',-4057715,'2017'), ('8kl2',-3427611,'0000'), ('8kl2',-3213207,'1975'), ('8kl2',-2282447,'1908'), ('8kl2',-2240520,'1975'), ('8kl2',-1890607,'2015'), ('p,5naac',-34879,'1974'), ('8kl2',0,'1985'), ('8kl2',219634,'2020'), ('8kl2',697507,'1991'), ('p,5naac',1298584,'1973'), ('p,5naac',1401179,'2030'), ('p,5naac',1507974,'1978'), ('p,5naac',2512413,'2035'), ('p,5naac',2740745,'2023'), ('8kl2',2779651,'1995'), ('8kl2',4098469,'1984'), ('8kl2',4660647,'2028'), ('p,5naac',5723619,'0000'), ('8kl2',6056113,'1979'), ('p',7039256,'2026');
INSERT INTO `f93abdb0-c6af-472c-93ab-33432e8fd836` VALUES ('',0), ('7xs',0), ('jum1p',1), ('pj',0), ('db',0), ('si',0);
select * from `17727daf-49e7-415c-83be-74c0ff7665a2` where not( `17727daf-49e7-415c-83be-74c0ff7665a2`.`2dbd888c-7a13-402e-b45e-df771c58b8a2` in ( select `66856456-0550-4ac2-bc3d-484dae5d3655` from `4e8a7745-94c7-49f7-b653-3e3e255ccf45` where not( `17727daf-49e7-415c-83be-74c0ff7665a2`.`2dbd888c-7a13-402e-b45e-df771c58b8a2` in ( select `66856456-0550-4ac2-bc3d-484dae5d3655` from `4e8a7745-94c7-49f7-b653-3e3e255ccf45` where `17727daf-49e7-415c-83be-74c0ff7665a2`.`aecbdd04-400d-41e0-93fc-8fe949f3fe71` in ( select `7c0cb0f1-4160-4718-be37-4dcc8bd62155` from `f93abdb0-c6af-472c-93ab-33432e8fd836` ) ) ) ) );
2. What did you expect to see? (Required)
No error
3. What did you see instead (Required)
[err="Input byte is not a mysql type\ngithub.com/pingcap/tidb/executor.(*probeSideTupleFetcher).handleProbeSideFetcherPanic\n\t/Users/bba/pc/tidb/executor/join.go:391\ngithub.com/pingcap/tidb/util.(*WaitGroupWrapper).RunWithRecover.func1.1\n\t/Users/bba/pc/tidb/util/wait_group_wrapper.go:168\nruntime.gopanic\n\t/Users/bba/.gvm/gos/go1.19/src/runtime/panic.go:884\ngithub.com/pingcap/tidb/types.IntergerSignedUpperBound\n\t/Users/bba/pc/tidb/types/convert.go:77\ngithub.com/pingcap/tidb/expression.(*compareFunctionClass).refineArgsByUnsignedFlag\n\t/Users/bba/pc/tidb/expression/builtin_compare.go:1705\ngithub.com/pingcap/tidb/expression.(*compareFunctionClass).refineArgs\n\t/Users/bba/pc/tidb/expression/builtin_compare.go:1672\ngithub.com/pingcap/tidb/expression.(*compareFunctionClass).getFunction\n\t/Users/bba/pc/tidb/expression/builtin_compare.go:1740\ngithub.com/pingcap/tidb/expression.newFunctionImpl\n\t/Users/bba/pc/tidb/expression/scalar_function.go:230\ngithub.com/pingcap/tidb/expression.NewFunction\n\t/Users/bba/pc/tidb/expression/scalar_function.go:261\ngithub.com/pingcap/tidb/expression.NewFunctionInternal\n\t/Users/bba/pc/tidb/expression/scalar_function.go:276\ngithub.com/pingcap/tidb/expression.SubstituteCorCol2Constant\n\t/Users/bba/pc/tidb/expression/util.go:570\ngithub.com/pingcap/tidb/planner/core.(*PhysicalTableScan).ResolveCorrelatedColumns\n\t/Users/bba/pc/tidb/planner/core/physical_plans.go:891\ngithub.com/pingcap/tidb/executor.(*TableReaderExecutor).Open\n\t/Users/bba/pc/tidb/executor/table_reader.go:172\ngithub.com/pingcap/tidb/executor.(*baseExecutor).Open\n\t/Users/bba/pc/tidb/executor/executor.go:202\ngithub.com/pingcap/tidb/executor.(*SelectionExec).Open\n\t/Users/bba/pc/tidb/executor/executor.go:1607\ngithub.com/pingcap/tidb/executor.(*baseExecutor).Open\n\t/Users/bba/pc/tidb/executor/executor.go:202\ngithub.com/pingcap/tidb/executor.(*HashJoinExec).Open\n\t/Users/bba/pc/tidb/executor/join.go:196\ngithub.com/pingcap/tidb/executor.(*baseExecutor).Open\n\t/Users/bba/pc/tidb/executor/executor.go:202\ngithub.com/pingcap/tidb/executor.(*SelectionExec).Open\n\t/Users/bba/pc/tidb/executor/executor.go:1607\ngithub.com/pingcap/tidb/executor.(*baseExecutor).Open\n\t/Users/bba/pc/tidb/executor/executor.go:202\ngithub.com/pingcap/tidb/executor.(*HashJoinExec).Open\n\t/Users/bba/pc/tidb/executor/join.go:196\ngithub.com/pingcap/tidb/executor.(*baseExecutor).Open\n\t/Users/bba/pc/tidb/executor/executor.go:202\ngithub.com/pingcap/tidb/executor.(*SelectionExec).Open\n\t/Users/bba/pc/tidb/executor/executor.go:1607\ngithub.com/pingcap/tidb/executor.(*NestedLoopApplyExec).fetchAllInners\n\t/Users/bba/pc/tidb/executor/join.go:1397\ngithub.com/pingcap/tidb/executor.(*NestedLoopApplyExec).Next\n\t/Users/bba/pc/tidb/executor/join.go:1464\ngithub.com/pingcap/tidb/executor.Next\n\t/Users/bba/pc/tidb/executor/executor.go:328\ngithub.com/pingcap/tidb/executor.(*SelectionExec).Next\n\t/Users/bba/pc/tidb/executor/executor.go:1663\ngithub.com/pingcap/tidb/executor.Next\n\t/Users/bba/pc/tidb/executor/executor.go:328\ngithub.com/pingcap/tidb/executor.(*probeSideTupleFetcher).fetchProbeSideChunks\n\t/Users/bba/pc/tidb/executor/join.go:245\ngithub.com/pingcap/tidb/executor.(*HashJoinExec).fetchAndProbeHashTable.func1\n\t/Users/bba/pc/tidb/executor/join.go:373\ngithub.com/pingcap/tidb/util.(*WaitGroupWrapper).RunWithRecover.func1\n\t/Users/bba/pc/tidb/util/wait_group_wrapper.go:172\nruntime.goexit\n\t/Users/bba/.gvm/gos/go1.19/src/runtime4. What is your TiDB version? (Required)
master
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
fuzz/schrddlseverity/moderatesig/sql-infraSIG: SQL InfraSIG: SQL Infratype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.