[MCOL-5006] select with subquery select gives incorrect result Created: 2022-03-04  Updated: 2022-03-29

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

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


 Description   

See test005.sh
/home/calpont/regression/mysql/queries/working_dml/qa_sub/mts_1.0400.sql

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

SELECT 1+(select 1) returns 2:

SELECT 1+(select 1);
 
+--------------+
 
| 1+(select 1) |
 
+--------------+
 
|            2 |
 
+--------------+


SELECT * FROM t2 WHERE id IN (2);
 
+------+
 
| id   |
 
+------+
 
|    2 |
 
+------+

Yet when the subselect is select 1 + select 2, it returns more rows than it ought

SELECT * FROM t2 WHERE id IN (SELECT 1+(select 1));
 
+------+
 
| id   |
 
+------+
 
|    1 |
 
|    2 |
 
+------+



 Comments   
Comment by David Hall (Inactive) [ 2022-03-04 ]

When fixed, please add mtr test

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