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

Query aborts mysqld

    XMLWordPrintable

Details

    Description

      The following sql code from /working_tpch1_compareLogOnly/view/mts_view.50.sql

      create table t1 (x int, y int) engine=columnstore;
      create table t2 (x int, y int, z int) engine=columnstore;
      create table t3 (x int, y int, z int) engine=columnstore;
      create table t4 (x int, y int, z int) engine=columnstore;
      insert into t1 values (1, 1), (2, 2), (3, null);
      insert into t2 values (1, 1, 1), (2, 2, null), (3, null, null);
      insert into t3 values (1, 1, 1), (2, 2, null), (3, null, null);
      insert into t4 values (1, 1, 1), (2, 2, null), (3, null, null);
      create view v1 as select t1.x from ((t1 join t2 on ((t1.y = t2.y))) join (t3 left join t4 on (t3.y = t4.y) and (t3.z = t4.z)));
      prepare stmt1 from "select count from v1 where x = ?";
      set @parm1=1;
      execute stmt1 using @parm1;

      causes mysqld to assert and abort

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              David.Hall David Hall (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.