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

join on view fails with "not joined" error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.5
    • 1.4.5, 5.4.1
    • MDB Plugin
    • None

    Description

      Consider the following from queries/working_tpch1_compareLogOnly/partitionOptimization/vTpch02b.sql

      drop view if exists vTemp;
      create view vTemp as select * from v_part where p_size=15 and p_type like '%BRASS';

      select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment
      from vTemp, supplier, partsupp pso, nation, region
      where p_partkey = pso.ps_partkey
      and s_suppkey = pso.ps_suppkey
      and s_nationkey = n_nationkey
      and n_regionkey = r_regionkey
      and r_name = 'EUROPE'
      and pso.ps_supplycost = (select min(psi.ps_supplycost)
      from partsupp psi, supplier, nation, region
      where pso.ps_partkey = psi.ps_partkey
      and s_suppkey = psi.ps_suppkey
      and s_nationkey = n_nationkey
      and n_regionkey = r_regionkey
      and r_name = 'EUROPE')
      order by s_acctbal desc,
      n_name,
      s_name,
      p_partkey
      limit 100;

      In 1.1, this produces the correct answer.
      In 1.2.5 forward, this produces:
      ERROR 1815 (HY000) at line 4: Internal error: IDB-1000: 'vtemp' and 'vTemp, nation, pso, region, sub-query, supplier' are not joined.

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              David.Hall David Hall (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.