Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.0.1
-
None
-
Centos 6.5, any Linux
-
2016-20, 2016-21, 2016-22
Description
Consider the following using the dml database:
update orders, customer set c_comment = o_clerk, c_acctbal=c_acctbal+o_totalprice where c_custkey = o_orderkey and o_orderkey in (select l_orderkey from lineitem where l_orderkey < 100 order by l_orderkey, l_linenumber);
The result is:
ERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr
The error is misleading, as connection to ExeMgr is not the problem. That's the error spit out by getSelectPlan() in ha_calpont_execplan.cpp when a ... exception is caught. The real problem is that the subquery is being sent in with the regular table list, but with a NULL name. The name is used without test. That's all fine, but it shouldn't be there at all. It belongs elsewhere. Ignoring the entry leads to other problems.
We need to figure out how it used to work and then find a fix.
The query is from test005 and is in working_dml/misc/vtabledmlcol2col.sql
Attachments
Issue Links
- is duplicated by
-
MCOL-288 test001 vtabledmlcol2col.sql fails
- Closed