Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-260

update two tables with a subquery fails

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.0.1
    • 1.0.5
    • MariaDB Server
    • 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

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              David.Hall David Hall (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.