[MDEV-32526] Enable Charset Narrowing by default starting from 11.3 Created: 2023-10-20  Updated: 2023-11-15  Resolved: 2023-11-09

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Fix Version/s: 11.3.1

Type: Task Priority: Critical
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-32113 utf8mb3_key_col=utf8mb4_value cannot ... Closed

 Description   

MDEV-32113 has introduced charset narrowing optimization.

It was introduced in 10.6 and it is not enabled by default.

We should enable it by default. It should be done in 11.4 as its the earliest development release.

Also, we should consider removing the optimizer switch flag (either in this or in a later version).



 Comments   
Comment by Sergei Petrunia [ 2023-11-08 ]

serg, I now see it has been already done in 11.3 by:

commit e987b9350cb83038c73a165922986441f345a3a9
Author:	Sergei Petrunia <sergey@mariadb.com>  Mon Jun 19 17:53:16 2023
Committer:	Sergei Petrunia <sergey@mariadb.com>  Tue Sep 12 17:14:43 2023
 
MDEV-31496: Make optimizer handle UCASE(varchar_col)=...

The backport to 10.6 was done after

commit 4941ac9192394a1489f0bf01b6dd2ee5ec2906c9 (origin/bb-10.6-mdev32113-variant3, bb-10.6-mdev32113-variant3)
Author: Sergei Petrunia <sergey@mariadb.com>
Date:   Tue Sep 19 18:22:49 2023 +0300
 
    MDEV-32113: utf8mb3_key_col=utf8mb4_value cannot be used for ref

Generated at Thu Feb 08 10:32:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.