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

join on view fails with "not joined" error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.5
    • Fix Version/s: 1.4.5, 5.4.1
    • Component/s: Connector
    • Labels:
      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

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              David.Hall David Hall
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: