[MCOL-841] Query aborts mysqld Created: 2017-07-28  Updated: 2019-07-10  Resolved: 2019-07-10

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.1.0
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hall (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MCOL-684 Prepare statement with parameter subs... Closed

 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



 Comments   
Comment by David Hall (Inactive) [ 2017-07-28 ]

May be a duplicate, may be a subset, or overlap in some other way.

Generated at Thu Feb 08 02:24:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.