[MDEV-5234] subselect_hash_sj_engine::make_semi_join_conds creates AND with single argument Created: 2013-11-04  Updated: 2020-07-26  Resolved: 2020-07-26

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 5.3.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Oleksandr Byelkin Assignee: Oleksandr Byelkin
Resolution: Incomplete Votes: 0
Labels: need_feedback


 Description   

subselect_hash_sj_engine::make_semi_join_conds creates in case of single column IN query we will have Item_cond_and with single argument.

 Comments   
Comment by Oleksandr Byelkin [ 2013-11-04 ]

<SanjaByelkin> timour: it might be good idea to put DBUG_ASSERT(!is_cond_and(this) || !is_cond_or(this) || list.elements > 1)
<SanjaByelkin> in Item_cond::fix_fields
<timour> SanjaByelkin, also in quick_fix_fields - it is called often on synthetic Items (especially AND/OR)

Comment by Elena Stepanova [ 2015-06-02 ]

sanja,

Is it applicable to 10.x?
If yes, please update the Affects/Fix versions (and adjust priority if necessary); if it's 5.3-only bug, obviously it won't be fixed, please close it as "Won't fix" then.
Thanks.

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