[MDEV-4236] EXIST2IN in any place of the query Created: 2013-03-03  Updated: 2015-11-17

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Subquery, Optimizer
Fix Version/s: None

Type: Task Priority: Major
Reporter: Oleksandr Byelkin Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: optimizer

Issue Links:
Relates
relates to MDEV-4246 Assertion `!exists_transformed || nul... Open
Sub-Tasks:
Key
Summary
Type
Status
Assignee
MDEV-4246 Assertion `!exists_transformed || nul... Technical task Open Oleksandr Byelkin  

 Description   

Remove IN NULL processing in converted EXISTS for IN2EXISTS and Materialization strategies.



 Comments   
Comment by Oleksandr Byelkin [ 2013-03-03 ]

IN2EXISTS:
left part NULL processed in Item_in_optimizer::val_int()
NULL caused by presence of NULL in answer processed in Item_in_subselect::val_*

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