[MDEV-25345] SHOW ... WHERE crashes on IN-to-subquery conversion Created: 2021-04-06  Updated: 2021-04-06  Resolved: 2021-04-06

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.3, 10.4, 10.5
Fix Version/s: N/A

Type: Bug Priority: Blocker
Reporter: Sergei Golubchik Assignee: Sergei Petrunia
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-21603 Crashing SHOW TABLES with derived tab... Closed

 Description   

Test case:

set @@in_predicate_conversion_threshold=10;
 
use mysql;
 
show tables where tables_in_mysql in ('1','2','3','4','5','6','7','8','9');
 
show tables where tables_in_mysql in ('1','2','3','4','5','6','7','8','9','boom');



 Comments   
Comment by Elena Stepanova [ 2021-04-06 ]

This is the same as MDEV-21603. Please close both after fixing.

Generated at Thu Feb 08 09:37:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.