[MDEV-32925] unary_minus(const_expr) will compute const_expr on fix_fields Created: 2023-12-01  Updated: 2023-12-05

Status: Open
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.5
Fix Version/s: 10.5

Type: Bug Priority: Major
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None


 Description    

create table t1 (a int);
 
insert into t1 select seq from seq_1_to_10;
 
create table t2 (a int, b int);
 
insert into t2 select seq,seq from seq_1_to_10000;


explain select -(select max(a) from t2) from t1;

Takes 6.746 sec

analyze format=json select -(select max(a) from t2) from t1;
 
{
 
  "query_optimization": {
 
    "r_total_time_ms": 7413.537268
 
  },
 
  "query_block": {
 
    "select_id": 1,
 
    "cost": 0.0124848,
 
    "r_loops": 1,
 
    "r_total_time_ms": 0.095447472,
 
...

Shows the time is spent in the optimizer.

Please check the affected/fixversion.
Generated at Thu Feb 08 10:35:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.