[MDEV-26374] Can not set optimizer_switch='expensive_pred_static_pushdown=on'; Created: 2021-08-16  Updated: 2021-08-24  Resolved: 2021-08-24

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Optimizer
Affects Version/s: 10.4.18
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Kuijun Cui Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None
Environment:

LSB Version: :core-4.1-amd64:core-4.1-noarch
Distributor ID: CentOS
Description: CentOS Linux release 7.8.2003 (Core)
Release: 7.8.2003
Codename: Core


 Description   

Hi, community,
As the title described, when testing the official document: https://mariadb.com/kb/en/histogram-based-statistics, found this issue.
Could you tell me that: is it this optimizer option still valid, which version can use it?

 Comments   
Comment by Kuijun Cui [ 2021-08-16 ]

The error prompt:
(dbausr@localhost) [(none)] 17:40:05> set @@session.optimizer_switch='expensive_pred_static_pushdown=on';
ERROR 1231 (42000): Variable 'optimizer_switch' can't be set to the value of 'expensive_pred_static_pushdown=on'

Comment by Sergei Golubchik [ 2021-08-23 ]

No, it's not valid, not listed in the optimizer switch documentation.

Comment by Ian Gilfillan [ 2021-08-24 ]

It was never actually implemented. Example using it has been removed for now.

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