[MCOL-5129] in (select 1+(select 1)) Created: 2022-06-12  Updated: 2022-06-27

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 6.3.1
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Kirill Perov Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

ubuntu 20,
columnstore branch develop6 latest for 12 June 2022
MDB server 10.6-enterprise


 Description   

CREATE TABLE t2 (id int(11)) engine=columnstore;
INSERT INTO t2 VALUES (1),(2);
SELECT * FROM t2 WHERE id IN (SELECT 1+(select 1));

with engine=columnstore it returns:
1
2

should be:
2

default engine returns:
2
Generated at Thu Feb 08 02:55:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.