Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37441

Optimizer is scanning the first partition for unknown reason

    XMLWordPrintable

Details

    • Not for Release Notes
    • Q4/2025 Server Maintenance

    Description

      Partitioned Table

      DROP TABLE IF EXISTS `t1`;
      CREATE TABLE `t1` (
        id INT NOT NULL,
        dt datetime NOT NULL, 
        PRIMARY KEY (id, dt)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
       PARTITION BY RANGE (to_days(dt))
      (PARTITION `P20240101` VALUES LESS THAN (739252) ENGINE = InnoDB,
       PARTITION `P20240102` VALUES LESS THAN (739253) ENGINE = InnoDB,
       PARTITION `P20240103` VALUES LESS THAN (739254) ENGINE = InnoDB,
       PARTITION `P20240104` VALUES LESS THAN (739255) ENGINE = InnoDB,
       PARTITION `P20240105` VALUES LESS THAN (739256) ENGINE = InnoDB,
       PARTITION `P20240106` VALUES LESS THAN (739257) ENGINE = InnoDB,
       PARTITION `P20240107` VALUES LESS THAN (739258) ENGINE = InnoDB,
       PARTITION `P20240108` VALUES LESS THAN (739259) ENGINE = InnoDB,
       PARTITION `P20240109` VALUES LESS THAN (739260) ENGINE = InnoDB,
       PARTITION `P20240110` VALUES LESS THAN (739261) ENGINE = InnoDB,
       PARTITION `P20240111` VALUES LESS THAN (739262) ENGINE = InnoDB,
       PARTITION `P20240112` VALUES LESS THAN (739263) ENGINE = InnoDB,
       PARTITION `P20240113` VALUES LESS THAN (739264) ENGINE = InnoDB,
       PARTITION `P20240114` VALUES LESS THAN (739265) ENGINE = InnoDB,
       PARTITION `P20240115` VALUES LESS THAN (739266) ENGINE = InnoDB,
       PARTITION `P20240116` VALUES LESS THAN (739267) ENGINE = InnoDB,
       PARTITION `P20240117` VALUES LESS THAN (739268) ENGINE = InnoDB,
       PARTITION `P20240118` VALUES LESS THAN (739269) ENGINE = InnoDB,
       PARTITION `P20240119` VALUES LESS THAN (739270) ENGINE = InnoDB,
       PARTITION `P20240120` VALUES LESS THAN (739271) ENGINE = InnoDB,
       PARTITION `P20240121` VALUES LESS THAN (739272) ENGINE = InnoDB,
       PARTITION `P20240122` VALUES LESS THAN (739273) ENGINE = InnoDB,
       PARTITION `P20240123` VALUES LESS THAN (739274) ENGINE = InnoDB,
       PARTITION `P20240124` VALUES LESS THAN (739275) ENGINE = InnoDB,
       PARTITION `P20240125` VALUES LESS THAN (739276) ENGINE = InnoDB,
       PARTITION `P20240126` VALUES LESS THAN (739277) ENGINE = InnoDB,
       PARTITION `P20240127` VALUES LESS THAN (739278) ENGINE = InnoDB,
       PARTITION `P20240128` VALUES LESS THAN (739279) ENGINE = InnoDB,
       PARTITION `P20240129` VALUES LESS THAN (739280) ENGINE = InnoDB,
       PARTITION `P20240130` VALUES LESS THAN (739281) ENGINE = InnoDB,
       PARTITION `P20240131` VALUES LESS THAN (739282) ENGINE = InnoDB,
       PARTITION `P20240201` VALUES LESS THAN (739283) ENGINE = InnoDB,
       PARTITION `P20240202` VALUES LESS THAN (739284) ENGINE = InnoDB,
       PARTITION `P20240203` VALUES LESS THAN (739285) ENGINE = InnoDB,
       PARTITION `P20240204` VALUES LESS THAN (739286) ENGINE = InnoDB,
       PARTITION `P20240205` VALUES LESS THAN (739287) ENGINE = InnoDB,
       PARTITION `P20240206` VALUES LESS THAN (739288) ENGINE = InnoDB,
       PARTITION `P20240207` VALUES LESS THAN (739289) ENGINE = InnoDB,
       PARTITION `P20240208` VALUES LESS THAN (739290) ENGINE = InnoDB,
       PARTITION `P20240209` VALUES LESS THAN (739291) ENGINE = InnoDB,
       PARTITION `P20240210` VALUES LESS THAN (739292) ENGINE = InnoDB,
       PARTITION `P20240211` VALUES LESS THAN (739293) ENGINE = InnoDB,
       PARTITION `P20240212` VALUES LESS THAN (739294) ENGINE = InnoDB,
       PARTITION `P20240213` VALUES LESS THAN (739295) ENGINE = InnoDB,
       PARTITION `P20240214` VALUES LESS THAN (739296) ENGINE = InnoDB,
       PARTITION `P20240215` VALUES LESS THAN (739297) ENGINE = InnoDB,
       PARTITION `P20240216` VALUES LESS THAN (739298) ENGINE = InnoDB,
       PARTITION `P20240217` VALUES LESS THAN (739299) ENGINE = InnoDB,
       PARTITION `P20240218` VALUES LESS THAN (739300) ENGINE = InnoDB,
       PARTITION `P20240219` VALUES LESS THAN (739301) ENGINE = InnoDB,
       PARTITION `P20240220` VALUES LESS THAN (739302) ENGINE = InnoDB,
       PARTITION `P20240221` VALUES LESS THAN (739303) ENGINE = InnoDB,
       PARTITION `P20240222` VALUES LESS THAN (739304) ENGINE = InnoDB,
       PARTITION `P20240223` VALUES LESS THAN (739305) ENGINE = InnoDB,
       PARTITION `P20240224` VALUES LESS THAN (739306) ENGINE = InnoDB,
       PARTITION `P20240225` VALUES LESS THAN (739307) ENGINE = InnoDB,
       PARTITION `P20240226` VALUES LESS THAN (739308) ENGINE = InnoDB,
       PARTITION `P20240227` VALUES LESS THAN (739309) ENGINE = InnoDB,
       PARTITION `P20240228` VALUES LESS THAN (739310) ENGINE = InnoDB,
       PARTITION `P20240229` VALUES LESS THAN (739311) ENGINE = InnoDB,
       PARTITION `P20240301` VALUES LESS THAN (739312) ENGINE = InnoDB,
       PARTITION `P20240302` VALUES LESS THAN (739313) ENGINE = InnoDB,
       PARTITION `P20240303` VALUES LESS THAN (739314) ENGINE = InnoDB,
       PARTITION `P20240304` VALUES LESS THAN (739315) ENGINE = InnoDB,
       PARTITION `P20240305` VALUES LESS THAN (739316) ENGINE = InnoDB,
       PARTITION `P20240306` VALUES LESS THAN (739317) ENGINE = InnoDB,
       PARTITION `P20240307` VALUES LESS THAN (739318) ENGINE = InnoDB,
       PARTITION `P20240308` VALUES LESS THAN (739319) ENGINE = InnoDB,
       PARTITION `P20240309` VALUES LESS THAN (739320) ENGINE = InnoDB,
       PARTITION `P20240310` VALUES LESS THAN (739321) ENGINE = InnoDB,
       PARTITION `P20240311` VALUES LESS THAN (739322) ENGINE = InnoDB,
       PARTITION `P20240312` VALUES LESS THAN (739323) ENGINE = InnoDB,
       PARTITION `P20240313` VALUES LESS THAN (739324) ENGINE = InnoDB,
       PARTITION `P20240314` VALUES LESS THAN (739325) ENGINE = InnoDB,
       PARTITION `P20240315` VALUES LESS THAN (739326) ENGINE = InnoDB,
       PARTITION `P20240316` VALUES LESS THAN (739327) ENGINE = InnoDB,
       PARTITION `P20240317` VALUES LESS THAN (739328) ENGINE = InnoDB,
       PARTITION `P20240318` VALUES LESS THAN (739329) ENGINE = InnoDB,
       PARTITION `P20240319` VALUES LESS THAN (739330) ENGINE = InnoDB,
       PARTITION `P20240320` VALUES LESS THAN (739331) ENGINE = InnoDB,
       PARTITION `P20240321` VALUES LESS THAN (739332) ENGINE = InnoDB,
       PARTITION `P20240322` VALUES LESS THAN (739333) ENGINE = InnoDB,
       PARTITION `P20240323` VALUES LESS THAN (739334) ENGINE = InnoDB,
       PARTITION `P20240324` VALUES LESS THAN (739335) ENGINE = InnoDB,
       PARTITION `P20240325` VALUES LESS THAN (739336) ENGINE = InnoDB,
       PARTITION `P20240326` VALUES LESS THAN (739337) ENGINE = InnoDB,
       PARTITION `P20240327` VALUES LESS THAN (739338) ENGINE = InnoDB,
       PARTITION `P20240328` VALUES LESS THAN (739339) ENGINE = InnoDB,
       PARTITION `P20240329` VALUES LESS THAN (739340) ENGINE = InnoDB,
       PARTITION `P20240330` VALUES LESS THAN (739341) ENGINE = InnoDB,
       PARTITION `P20240331` VALUES LESS THAN (739342) ENGINE = InnoDB,
       PARTITION `P20240401` VALUES LESS THAN (739343) ENGINE = InnoDB,
       PARTITION `P20240402` VALUES LESS THAN (739344) ENGINE = InnoDB,
       PARTITION `P20240403` VALUES LESS THAN (739345) ENGINE = InnoDB,
       PARTITION `P20240404` VALUES LESS THAN (739346) ENGINE = InnoDB,
       PARTITION `P20240405` VALUES LESS THAN (739347) ENGINE = InnoDB,
       PARTITION `P20240406` VALUES LESS THAN (739348) ENGINE = InnoDB,
       PARTITION `P20240407` VALUES LESS THAN (739349) ENGINE = InnoDB,
       PARTITION `P20240408` VALUES LESS THAN (739350) ENGINE = InnoDB,
       PARTITION `P20240409` VALUES LESS THAN (739351) ENGINE = InnoDB,
       PARTITION `P20240410` VALUES LESS THAN (739352) ENGINE = InnoDB,
       PARTITION `P20240411` VALUES LESS THAN (739353) ENGINE = InnoDB,
       PARTITION `P20240412` VALUES LESS THAN (739354) ENGINE = InnoDB,
       PARTITION `P20240413` VALUES LESS THAN (739355) ENGINE = InnoDB,
       PARTITION `P20240414` VALUES LESS THAN (739356) ENGINE = InnoDB,
       PARTITION `P20240415` VALUES LESS THAN (739357) ENGINE = InnoDB,
       PARTITION `P20240416` VALUES LESS THAN (739358) ENGINE = InnoDB,
       PARTITION `P20240417` VALUES LESS THAN (739359) ENGINE = InnoDB,
       PARTITION `P20240418` VALUES LESS THAN (739360) ENGINE = InnoDB,
       PARTITION `P20240419` VALUES LESS THAN (739361) ENGINE = InnoDB,
       PARTITION `P20240420` VALUES LESS THAN (739362) ENGINE = InnoDB,
       PARTITION `P20240421` VALUES LESS THAN (739363) ENGINE = InnoDB,
       PARTITION `P20240422` VALUES LESS THAN (739364) ENGINE = InnoDB,
       PARTITION `P20240423` VALUES LESS THAN (739365) ENGINE = InnoDB,
       PARTITION `P20240424` VALUES LESS THAN (739366) ENGINE = InnoDB,
       PARTITION `P20240425` VALUES LESS THAN (739367) ENGINE = InnoDB,
       PARTITION `P20240426` VALUES LESS THAN (739368) ENGINE = InnoDB,
       PARTITION `P20240427` VALUES LESS THAN (739369) ENGINE = InnoDB,
       PARTITION `P20240428` VALUES LESS THAN (739370) ENGINE = InnoDB,
       PARTITION `P20240429` VALUES LESS THAN (739371) ENGINE = InnoDB,
       PARTITION `P20240430` VALUES LESS THAN (739372) ENGINE = InnoDB,
       PARTITION `P20240501` VALUES LESS THAN (739373) ENGINE = InnoDB,
       PARTITION `P20240502` VALUES LESS THAN (739374) ENGINE = InnoDB,
       PARTITION `P20240503` VALUES LESS THAN (739375) ENGINE = InnoDB,
       PARTITION `P20240504` VALUES LESS THAN (739376) ENGINE = InnoDB,
       PARTITION `P20240505` VALUES LESS THAN (739377) ENGINE = InnoDB,
       PARTITION `P20240506` VALUES LESS THAN (739378) ENGINE = InnoDB,
       PARTITION `P20240507` VALUES LESS THAN (739379) ENGINE = InnoDB,
       PARTITION `P20240508` VALUES LESS THAN (739380) ENGINE = InnoDB,
       PARTITION `P20240509` VALUES LESS THAN (739381) ENGINE = InnoDB,
       PARTITION `P20240510` VALUES LESS THAN (739382) ENGINE = InnoDB,
       PARTITION `P20240511` VALUES LESS THAN (739383) ENGINE = InnoDB,
       PARTITION `P20240512` VALUES LESS THAN (739384) ENGINE = InnoDB,
       PARTITION `P20240513` VALUES LESS THAN (739385) ENGINE = InnoDB,
       PARTITION `P20240514` VALUES LESS THAN (739386) ENGINE = InnoDB,
       PARTITION `P20240515` VALUES LESS THAN (739387) ENGINE = InnoDB,
       PARTITION `P20240516` VALUES LESS THAN (739388) ENGINE = InnoDB,
       PARTITION `P20240517` VALUES LESS THAN (739389) ENGINE = InnoDB,
       PARTITION `P20240518` VALUES LESS THAN (739390) ENGINE = InnoDB,
       PARTITION `P20240519` VALUES LESS THAN (739391) ENGINE = InnoDB,
       PARTITION `P20240520` VALUES LESS THAN (739392) ENGINE = InnoDB,
       PARTITION `P20240521` VALUES LESS THAN (739393) ENGINE = InnoDB,
       PARTITION `P20240522` VALUES LESS THAN (739394) ENGINE = InnoDB,
       PARTITION `P20240523` VALUES LESS THAN (739395) ENGINE = InnoDB,
       PARTITION `P20240524` VALUES LESS THAN (739396) ENGINE = InnoDB,
       PARTITION `P20240525` VALUES LESS THAN (739397) ENGINE = InnoDB,
       PARTITION `P20240526` VALUES LESS THAN (739398) ENGINE = InnoDB,
       PARTITION `P20240527` VALUES LESS THAN (739399) ENGINE = InnoDB,
       PARTITION `P20240528` VALUES LESS THAN (739400) ENGINE = InnoDB,
       PARTITION `P20240529` VALUES LESS THAN (739401) ENGINE = InnoDB,
       PARTITION `P20240530` VALUES LESS THAN (739402) ENGINE = InnoDB,
       PARTITION `P20240531` VALUES LESS THAN (739403) ENGINE = InnoDB,
       PARTITION `P20240601` VALUES LESS THAN (739404) ENGINE = InnoDB,
       PARTITION `P20240602` VALUES LESS THAN (739405) ENGINE = InnoDB,
       PARTITION `P20240603` VALUES LESS THAN (739406) ENGINE = InnoDB,
       PARTITION `P20240604` VALUES LESS THAN (739407) ENGINE = InnoDB,
       PARTITION `P20240605` VALUES LESS THAN (739408) ENGINE = InnoDB,
       PARTITION `P20240606` VALUES LESS THAN (739409) ENGINE = InnoDB,
       PARTITION `P20240607` VALUES LESS THAN (739410) ENGINE = InnoDB,
       PARTITION `P20240608` VALUES LESS THAN (739411) ENGINE = InnoDB,
       PARTITION `P20240609` VALUES LESS THAN (739412) ENGINE = InnoDB,
       PARTITION `P20240610` VALUES LESS THAN (739413) ENGINE = InnoDB,
       PARTITION `P20240611` VALUES LESS THAN (739414) ENGINE = InnoDB,
       PARTITION `P20240612` VALUES LESS THAN (739415) ENGINE = InnoDB,
       PARTITION `P20240613` VALUES LESS THAN (739416) ENGINE = InnoDB,
       PARTITION `P20240614` VALUES LESS THAN (739417) ENGINE = InnoDB,
       PARTITION `P20240615` VALUES LESS THAN (739418) ENGINE = InnoDB,
       PARTITION `P20240616` VALUES LESS THAN (739419) ENGINE = InnoDB,
       PARTITION `P20240617` VALUES LESS THAN (739420) ENGINE = InnoDB,
       PARTITION `P20240618` VALUES LESS THAN (739421) ENGINE = InnoDB,
       PARTITION `P20240619` VALUES LESS THAN (739422) ENGINE = InnoDB,
       PARTITION `P20240620` VALUES LESS THAN (739423) ENGINE = InnoDB,
       PARTITION `P20240621` VALUES LESS THAN (739424) ENGINE = InnoDB,
       PARTITION `P20240622` VALUES LESS THAN (739425) ENGINE = InnoDB,
       PARTITION `P20240623` VALUES LESS THAN (739426) ENGINE = InnoDB,
       PARTITION `P20240624` VALUES LESS THAN (739427) ENGINE = InnoDB,
       PARTITION `P20240625` VALUES LESS THAN (739428) ENGINE = InnoDB,
       PARTITION `P20240626` VALUES LESS THAN (739429) ENGINE = InnoDB,
       PARTITION `P20240627` VALUES LESS THAN (739430) ENGINE = InnoDB,
       PARTITION `P20240628` VALUES LESS THAN (739431) ENGINE = InnoDB,
       PARTITION `P20240629` VALUES LESS THAN (739432) ENGINE = InnoDB,
       PARTITION `P20240630` VALUES LESS THAN (739433) ENGINE = InnoDB,
       PARTITION `P20240701` VALUES LESS THAN (739434) ENGINE = InnoDB,
       PARTITION `P20240702` VALUES LESS THAN (739435) ENGINE = InnoDB,
       PARTITION `P20240703` VALUES LESS THAN (739436) ENGINE = InnoDB,
       PARTITION `P20240704` VALUES LESS THAN (739437) ENGINE = InnoDB,
       PARTITION `P20240705` VALUES LESS THAN (739438) ENGINE = InnoDB,
       PARTITION `P20240706` VALUES LESS THAN (739439) ENGINE = InnoDB,
       PARTITION `P20240707` VALUES LESS THAN (739440) ENGINE = InnoDB,
       PARTITION `P20240708` VALUES LESS THAN (739441) ENGINE = InnoDB,
       PARTITION `P20240709` VALUES LESS THAN (739442) ENGINE = InnoDB,
       PARTITION `P20240710` VALUES LESS THAN (739443) ENGINE = InnoDB,
       PARTITION `P20240711` VALUES LESS THAN (739444) ENGINE = InnoDB,
       PARTITION `P20240712` VALUES LESS THAN (739445) ENGINE = InnoDB,
       PARTITION `P20240713` VALUES LESS THAN (739446) ENGINE = InnoDB,
       PARTITION `P20240714` VALUES LESS THAN (739447) ENGINE = InnoDB,
       PARTITION `P20240715` VALUES LESS THAN (739448) ENGINE = InnoDB,
       PARTITION `P20240716` VALUES LESS THAN (739449) ENGINE = InnoDB,
       PARTITION `P20240717` VALUES LESS THAN (739450) ENGINE = InnoDB,
       PARTITION `P20240718` VALUES LESS THAN (739451) ENGINE = InnoDB,
       PARTITION `P20240719` VALUES LESS THAN (739452) ENGINE = InnoDB,
       PARTITION `P20240720` VALUES LESS THAN (739453) ENGINE = InnoDB,
       PARTITION `P20240721` VALUES LESS THAN (739454) ENGINE = InnoDB,
       PARTITION `P20240722` VALUES LESS THAN (739455) ENGINE = InnoDB,
       PARTITION `P20240723` VALUES LESS THAN (739456) ENGINE = InnoDB,
       PARTITION `P20240724` VALUES LESS THAN (739457) ENGINE = InnoDB,
       PARTITION `P20240725` VALUES LESS THAN (739458) ENGINE = InnoDB,
       PARTITION `P20240726` VALUES LESS THAN (739459) ENGINE = InnoDB,
       PARTITION `P20240727` VALUES LESS THAN (739460) ENGINE = InnoDB,
       PARTITION `P20240728` VALUES LESS THAN (739461) ENGINE = InnoDB,
       PARTITION `P20240729` VALUES LESS THAN (739462) ENGINE = InnoDB,
       PARTITION `P20240730` VALUES LESS THAN (739463) ENGINE = InnoDB,
       PARTITION `P20240731` VALUES LESS THAN (739464) ENGINE = InnoDB,
       PARTITION `P20240801` VALUES LESS THAN (739465) ENGINE = InnoDB,
       PARTITION `P20240802` VALUES LESS THAN (739466) ENGINE = InnoDB,
       PARTITION `P20240803` VALUES LESS THAN (739467) ENGINE = InnoDB,
       PARTITION `P20240804` VALUES LESS THAN (739468) ENGINE = InnoDB,
       PARTITION `P20240805` VALUES LESS THAN (739469) ENGINE = InnoDB,
       PARTITION `P20240806` VALUES LESS THAN (739470) ENGINE = InnoDB,
       PARTITION `P20240807` VALUES LESS THAN (739471) ENGINE = InnoDB,
       PARTITION `P20240808` VALUES LESS THAN (739472) ENGINE = InnoDB,
       PARTITION `P20240809` VALUES LESS THAN (739473) ENGINE = InnoDB,
       PARTITION `P20240810` VALUES LESS THAN (739474) ENGINE = InnoDB,
       PARTITION `P20240811` VALUES LESS THAN (739475) ENGINE = InnoDB,
       PARTITION `P20240812` VALUES LESS THAN (739476) ENGINE = InnoDB,
       PARTITION `P20240813` VALUES LESS THAN (739477) ENGINE = InnoDB,
       PARTITION `P20240814` VALUES LESS THAN (739478) ENGINE = InnoDB,
       PARTITION `P20240815` VALUES LESS THAN (739479) ENGINE = InnoDB,
       PARTITION `P20240816` VALUES LESS THAN (739480) ENGINE = InnoDB,
       PARTITION `P20240817` VALUES LESS THAN (739481) ENGINE = InnoDB,
       PARTITION `P20240818` VALUES LESS THAN (739482) ENGINE = InnoDB,
       PARTITION `P20240819` VALUES LESS THAN (739483) ENGINE = InnoDB,
       PARTITION `P20240820` VALUES LESS THAN (739484) ENGINE = InnoDB,
       PARTITION `P20240821` VALUES LESS THAN (739485) ENGINE = InnoDB,
       PARTITION `P20240822` VALUES LESS THAN (739486) ENGINE = InnoDB,
       PARTITION `P20240823` VALUES LESS THAN (739487) ENGINE = InnoDB,
       PARTITION `P20240824` VALUES LESS THAN (739488) ENGINE = InnoDB,
       PARTITION `P20240825` VALUES LESS THAN (739489) ENGINE = InnoDB,
       PARTITION `P20240826` VALUES LESS THAN (739490) ENGINE = InnoDB,
       PARTITION `P20240827` VALUES LESS THAN (739491) ENGINE = InnoDB,
       PARTITION `P20240828` VALUES LESS THAN (739492) ENGINE = InnoDB,
       PARTITION `P20240829` VALUES LESS THAN (739493) ENGINE = InnoDB,
       PARTITION `P20240830` VALUES LESS THAN (739494) ENGINE = InnoDB,
       PARTITION `P20240831` VALUES LESS THAN (739495) ENGINE = InnoDB,
       PARTITION `P20240901` VALUES LESS THAN (739496) ENGINE = InnoDB,
       PARTITION `P20240902` VALUES LESS THAN (739497) ENGINE = InnoDB,
       PARTITION `P20240903` VALUES LESS THAN (739498) ENGINE = InnoDB,
       PARTITION `P20240904` VALUES LESS THAN (739499) ENGINE = InnoDB,
       PARTITION `P20240905` VALUES LESS THAN (739500) ENGINE = InnoDB,
       PARTITION `P20240906` VALUES LESS THAN (739501) ENGINE = InnoDB,
       PARTITION `P20240907` VALUES LESS THAN (739502) ENGINE = InnoDB,
       PARTITION `P20240908` VALUES LESS THAN (739503) ENGINE = InnoDB,
       PARTITION `P20240909` VALUES LESS THAN (739504) ENGINE = InnoDB,
       PARTITION `P20240910` VALUES LESS THAN (739505) ENGINE = InnoDB,
       PARTITION `P20240911` VALUES LESS THAN (739506) ENGINE = InnoDB,
       PARTITION `P20240912` VALUES LESS THAN (739507) ENGINE = InnoDB,
       PARTITION `P20240913` VALUES LESS THAN (739508) ENGINE = InnoDB,
       PARTITION `P20240914` VALUES LESS THAN (739509) ENGINE = InnoDB,
       PARTITION `P20240915` VALUES LESS THAN (739510) ENGINE = InnoDB,
       PARTITION `P20240916` VALUES LESS THAN (739511) ENGINE = InnoDB,
       PARTITION `P20240917` VALUES LESS THAN (739512) ENGINE = InnoDB,
       PARTITION `P20240918` VALUES LESS THAN (739513) ENGINE = InnoDB,
       PARTITION `P20240919` VALUES LESS THAN (739514) ENGINE = InnoDB,
       PARTITION `P20240920` VALUES LESS THAN (739515) ENGINE = InnoDB,
       PARTITION `P20240921` VALUES LESS THAN (739516) ENGINE = InnoDB,
       PARTITION `P20240922` VALUES LESS THAN (739517) ENGINE = InnoDB,
       PARTITION `P20240923` VALUES LESS THAN (739518) ENGINE = InnoDB,
       PARTITION `P20240924` VALUES LESS THAN (739519) ENGINE = InnoDB,
       PARTITION `P20240925` VALUES LESS THAN (739520) ENGINE = InnoDB,
       PARTITION `P20240926` VALUES LESS THAN (739521) ENGINE = InnoDB,
       PARTITION `P20240927` VALUES LESS THAN (739522) ENGINE = InnoDB,
       PARTITION `P20240928` VALUES LESS THAN (739523) ENGINE = InnoDB,
       PARTITION `P20240929` VALUES LESS THAN (739524) ENGINE = InnoDB,
       PARTITION `P20240930` VALUES LESS THAN (739525) ENGINE = InnoDB,
       PARTITION `P20241001` VALUES LESS THAN (739526) ENGINE = InnoDB,
       PARTITION `P20241002` VALUES LESS THAN (739527) ENGINE = InnoDB,
       PARTITION `P20241003` VALUES LESS THAN (739528) ENGINE = InnoDB,
       PARTITION `P20241004` VALUES LESS THAN (739529) ENGINE = InnoDB,
       PARTITION `P20241005` VALUES LESS THAN (739530) ENGINE = InnoDB,
       PARTITION `P20241006` VALUES LESS THAN (739531) ENGINE = InnoDB,
       PARTITION `P20241007` VALUES LESS THAN (739532) ENGINE = InnoDB,
       PARTITION `P20241008` VALUES LESS THAN (739533) ENGINE = InnoDB,
       PARTITION `P20241009` VALUES LESS THAN (739534) ENGINE = InnoDB,
       PARTITION `P20241010` VALUES LESS THAN (739535) ENGINE = InnoDB,
       PARTITION `P20241011` VALUES LESS THAN (739536) ENGINE = InnoDB,
       PARTITION `P20241012` VALUES LESS THAN (739537) ENGINE = InnoDB,
       PARTITION `P20241013` VALUES LESS THAN (739538) ENGINE = InnoDB,
       PARTITION `P20241014` VALUES LESS THAN (739539) ENGINE = InnoDB,
       PARTITION `P20241015` VALUES LESS THAN (739540) ENGINE = InnoDB,
       PARTITION `P20241016` VALUES LESS THAN (739541) ENGINE = InnoDB,
       PARTITION `P20241017` VALUES LESS THAN (739542) ENGINE = InnoDB,
       PARTITION `P20241018` VALUES LESS THAN (739543) ENGINE = InnoDB,
       PARTITION `P20241019` VALUES LESS THAN (739544) ENGINE = InnoDB,
       PARTITION `P20241020` VALUES LESS THAN (739545) ENGINE = InnoDB,
       PARTITION `P20241021` VALUES LESS THAN (739546) ENGINE = InnoDB,
       PARTITION `P20241022` VALUES LESS THAN (739547) ENGINE = InnoDB,
       PARTITION `P20241023` VALUES LESS THAN (739548) ENGINE = InnoDB,
       PARTITION `P20241024` VALUES LESS THAN (739549) ENGINE = InnoDB,
       PARTITION `P20241025` VALUES LESS THAN (739550) ENGINE = InnoDB,
       PARTITION `P20241026` VALUES LESS THAN (739551) ENGINE = InnoDB,
       PARTITION `P20241027` VALUES LESS THAN (739552) ENGINE = InnoDB,
       PARTITION `P20241028` VALUES LESS THAN (739553) ENGINE = InnoDB,
       PARTITION `P20241029` VALUES LESS THAN (739554) ENGINE = InnoDB,
       PARTITION `P20241030` VALUES LESS THAN (739555) ENGINE = InnoDB,
       PARTITION `P20241031` VALUES LESS THAN (739556) ENGINE = InnoDB,
       PARTITION `P20241101` VALUES LESS THAN (739557) ENGINE = InnoDB,
       PARTITION `P20241102` VALUES LESS THAN (739558) ENGINE = InnoDB,
       PARTITION `P20241103` VALUES LESS THAN (739559) ENGINE = InnoDB,
       PARTITION `P20241104` VALUES LESS THAN (739560) ENGINE = InnoDB,
       PARTITION `P20241105` VALUES LESS THAN (739561) ENGINE = InnoDB,
       PARTITION `P20241106` VALUES LESS THAN (739562) ENGINE = InnoDB,
       PARTITION `P20241107` VALUES LESS THAN (739563) ENGINE = InnoDB,
       PARTITION `P20241108` VALUES LESS THAN (739564) ENGINE = InnoDB,
       PARTITION `P20241109` VALUES LESS THAN (739565) ENGINE = InnoDB,
       PARTITION `P20241110` VALUES LESS THAN (739566) ENGINE = InnoDB,
       PARTITION `P20241111` VALUES LESS THAN (739567) ENGINE = InnoDB,
       PARTITION `P20241112` VALUES LESS THAN (739568) ENGINE = InnoDB,
       PARTITION `P20241113` VALUES LESS THAN (739569) ENGINE = InnoDB,
       PARTITION `P20241114` VALUES LESS THAN (739570) ENGINE = InnoDB,
       PARTITION `P20241115` VALUES LESS THAN (739571) ENGINE = InnoDB,
       PARTITION `P20241116` VALUES LESS THAN (739572) ENGINE = InnoDB,
       PARTITION `P20241117` VALUES LESS THAN (739573) ENGINE = InnoDB,
       PARTITION `P20241118` VALUES LESS THAN (739574) ENGINE = InnoDB,
       PARTITION `P20241119` VALUES LESS THAN (739575) ENGINE = InnoDB,
       PARTITION `P20241120` VALUES LESS THAN (739576) ENGINE = InnoDB,
       PARTITION `P20241121` VALUES LESS THAN (739577) ENGINE = InnoDB,
       PARTITION `P20241122` VALUES LESS THAN (739578) ENGINE = InnoDB,
       PARTITION `P20241123` VALUES LESS THAN (739579) ENGINE = InnoDB,
       PARTITION `P20241124` VALUES LESS THAN (739580) ENGINE = InnoDB,
       PARTITION `P20241125` VALUES LESS THAN (739581) ENGINE = InnoDB,
       PARTITION `P20241126` VALUES LESS THAN (739582) ENGINE = InnoDB,
       PARTITION `P20241127` VALUES LESS THAN (739583) ENGINE = InnoDB,
       PARTITION `P20241128` VALUES LESS THAN (739584) ENGINE = InnoDB,
       PARTITION `P20241129` VALUES LESS THAN (739585) ENGINE = InnoDB,
       PARTITION `P20241130` VALUES LESS THAN (739586) ENGINE = InnoDB,
       PARTITION `P20241201` VALUES LESS THAN (739587) ENGINE = InnoDB,
       PARTITION `P20241202` VALUES LESS THAN (739588) ENGINE = InnoDB,
       PARTITION `P20241203` VALUES LESS THAN (739589) ENGINE = InnoDB,
       PARTITION `P20241204` VALUES LESS THAN (739590) ENGINE = InnoDB,
       PARTITION `P20241205` VALUES LESS THAN (739591) ENGINE = InnoDB,
       PARTITION `P20241206` VALUES LESS THAN (739592) ENGINE = InnoDB,
       PARTITION `P20241207` VALUES LESS THAN (739593) ENGINE = InnoDB,
       PARTITION `P20241208` VALUES LESS THAN (739594) ENGINE = InnoDB,
       PARTITION `P20241209` VALUES LESS THAN (739595) ENGINE = InnoDB,
       PARTITION `P20241210` VALUES LESS THAN (739596) ENGINE = InnoDB,
       PARTITION `P20241211` VALUES LESS THAN (739597) ENGINE = InnoDB,
       PARTITION `P20241212` VALUES LESS THAN (739598) ENGINE = InnoDB,
       PARTITION `P20241213` VALUES LESS THAN (739599) ENGINE = InnoDB,
       PARTITION `P20241214` VALUES LESS THAN (739600) ENGINE = InnoDB,
       PARTITION `P20241215` VALUES LESS THAN (739601) ENGINE = InnoDB,
       PARTITION `P20241216` VALUES LESS THAN (739602) ENGINE = InnoDB,
       PARTITION `P20241217` VALUES LESS THAN (739603) ENGINE = InnoDB,
       PARTITION `P20241218` VALUES LESS THAN (739604) ENGINE = InnoDB,
       PARTITION `P20241219` VALUES LESS THAN (739605) ENGINE = InnoDB,
       PARTITION `P20241220` VALUES LESS THAN (739606) ENGINE = InnoDB,
       PARTITION `P20241221` VALUES LESS THAN (739607) ENGINE = InnoDB,
       PARTITION `P20241222` VALUES LESS THAN (739608) ENGINE = InnoDB,
       PARTITION `P20241223` VALUES LESS THAN (739609) ENGINE = InnoDB,
       PARTITION `P20241224` VALUES LESS THAN (739610) ENGINE = InnoDB,
       PARTITION `P20241225` VALUES LESS THAN (739611) ENGINE = InnoDB,
       PARTITION `P20241226` VALUES LESS THAN (739612) ENGINE = InnoDB,
       PARTITION `P20241227` VALUES LESS THAN (739613) ENGINE = InnoDB,
       PARTITION `P20241228` VALUES LESS THAN (739614) ENGINE = InnoDB,
       PARTITION `P20241229` VALUES LESS THAN (739615) ENGINE = InnoDB,
       PARTITION `P20241230` VALUES LESS THAN (739616) ENGINE = InnoDB,
       PARTITION `P20241231` VALUES LESS THAN (739617) ENGINE = InnoDB,
       PARTITION `P20250101` VALUES LESS THAN (739618) ENGINE = InnoDB,
       PARTITION `P20250102` VALUES LESS THAN (739619) ENGINE = InnoDB,
       PARTITION `P20250103` VALUES LESS THAN (739620) ENGINE = InnoDB,
       PARTITION `P20250104` VALUES LESS THAN (739621) ENGINE = InnoDB,
       PARTITION `P20250105` VALUES LESS THAN (739622) ENGINE = InnoDB,
       PARTITION `P20250106` VALUES LESS THAN (739623) ENGINE = InnoDB,
       PARTITION `P20250107` VALUES LESS THAN (739624) ENGINE = InnoDB,
       PARTITION `P20250108` VALUES LESS THAN (739625) ENGINE = InnoDB,
       PARTITION `P20250109` VALUES LESS THAN (739626) ENGINE = InnoDB,
       PARTITION `P20250110` VALUES LESS THAN (739627) ENGINE = InnoDB,
       PARTITION `P20250111` VALUES LESS THAN (739628) ENGINE = InnoDB,
       PARTITION `P20250112` VALUES LESS THAN (739629) ENGINE = InnoDB,
       PARTITION `P20250113` VALUES LESS THAN (739630) ENGINE = InnoDB,
       PARTITION `P20250114` VALUES LESS THAN (739631) ENGINE = InnoDB,
       PARTITION `P20250115` VALUES LESS THAN (739632) ENGINE = InnoDB,
       PARTITION `P20250116` VALUES LESS THAN (739633) ENGINE = InnoDB,
       PARTITION `P20250117` VALUES LESS THAN (739634) ENGINE = InnoDB,
       PARTITION `P20250118` VALUES LESS THAN (739635) ENGINE = InnoDB,
       PARTITION `P20250119` VALUES LESS THAN (739636) ENGINE = InnoDB,
       PARTITION `P20250120` VALUES LESS THAN (739637) ENGINE = InnoDB,
       PARTITION `P20250121` VALUES LESS THAN (739638) ENGINE = InnoDB,
       PARTITION `P20250122` VALUES LESS THAN (739639) ENGINE = InnoDB,
       PARTITION `P20250123` VALUES LESS THAN (739640) ENGINE = InnoDB,
       PARTITION `P20250124` VALUES LESS THAN (739641) ENGINE = InnoDB,
       PARTITION `P20250125` VALUES LESS THAN (739642) ENGINE = InnoDB,
       PARTITION `P20250126` VALUES LESS THAN (739643) ENGINE = InnoDB,
       PARTITION `P20250127` VALUES LESS THAN (739644) ENGINE = InnoDB,
       PARTITION `P20250128` VALUES LESS THAN (739645) ENGINE = InnoDB,
       PARTITION `P20250129` VALUES LESS THAN (739646) ENGINE = InnoDB,
       PARTITION `P20250130` VALUES LESS THAN (739647) ENGINE = InnoDB,
       PARTITION `P20250131` VALUES LESS THAN (739648) ENGINE = InnoDB,
       PARTITION `P20250201` VALUES LESS THAN (739649) ENGINE = InnoDB,
       PARTITION `P20250202` VALUES LESS THAN (739650) ENGINE = InnoDB,
       PARTITION `P20250203` VALUES LESS THAN (739651) ENGINE = InnoDB,
       PARTITION `P20250204` VALUES LESS THAN (739652) ENGINE = InnoDB,
       PARTITION `P20250205` VALUES LESS THAN (739653) ENGINE = InnoDB,
       PARTITION `P20250206` VALUES LESS THAN (739654) ENGINE = InnoDB,
       PARTITION `P20250207` VALUES LESS THAN (739655) ENGINE = InnoDB,
       PARTITION `P20250208` VALUES LESS THAN (739656) ENGINE = InnoDB,
       PARTITION `P20250209` VALUES LESS THAN (739657) ENGINE = InnoDB,
       PARTITION `P20250210` VALUES LESS THAN (739658) ENGINE = InnoDB,
       PARTITION `P20250211` VALUES LESS THAN (739659) ENGINE = InnoDB,
       PARTITION `P20250212` VALUES LESS THAN (739660) ENGINE = InnoDB,
       PARTITION `P20250213` VALUES LESS THAN (739661) ENGINE = InnoDB,
       PARTITION `P20250214` VALUES LESS THAN (739662) ENGINE = InnoDB,
       PARTITION `P20250215` VALUES LESS THAN (739663) ENGINE = InnoDB,
       PARTITION `P20250216` VALUES LESS THAN (739664) ENGINE = InnoDB,
       PARTITION `P20250217` VALUES LESS THAN (739665) ENGINE = InnoDB,
       PARTITION `P20250218` VALUES LESS THAN (739666) ENGINE = InnoDB,
       PARTITION `P20250219` VALUES LESS THAN (739667) ENGINE = InnoDB,
       PARTITION `P20250220` VALUES LESS THAN (739668) ENGINE = InnoDB,
       PARTITION `P20250221` VALUES LESS THAN (739669) ENGINE = InnoDB,
       PARTITION `P20250222` VALUES LESS THAN (739670) ENGINE = InnoDB,
       PARTITION `P20250223` VALUES LESS THAN (739671) ENGINE = InnoDB,
       PARTITION `P20250224` VALUES LESS THAN (739672) ENGINE = InnoDB,
       PARTITION `P20250225` VALUES LESS THAN (739673) ENGINE = InnoDB,
       PARTITION `P20250226` VALUES LESS THAN (739674) ENGINE = InnoDB,
       PARTITION `P20250227` VALUES LESS THAN (739675) ENGINE = InnoDB,
       PARTITION `P20250228` VALUES LESS THAN (739676) ENGINE = InnoDB,
       PARTITION `P20250301` VALUES LESS THAN (739677) ENGINE = InnoDB,
       PARTITION `P20250302` VALUES LESS THAN (739678) ENGINE = InnoDB,
       PARTITION `P20250303` VALUES LESS THAN (739679) ENGINE = InnoDB,
       PARTITION `P20250304` VALUES LESS THAN (739680) ENGINE = InnoDB,
       PARTITION `P20250305` VALUES LESS THAN (739681) ENGINE = InnoDB,
       PARTITION `P20250306` VALUES LESS THAN (739682) ENGINE = InnoDB,
       PARTITION `P20250307` VALUES LESS THAN (739683) ENGINE = InnoDB,
       PARTITION `P20250308` VALUES LESS THAN (739684) ENGINE = InnoDB,
       PARTITION `P20250309` VALUES LESS THAN (739685) ENGINE = InnoDB,
       PARTITION `P20250310` VALUES LESS THAN (739686) ENGINE = InnoDB,
       PARTITION `P20250311` VALUES LESS THAN (739687) ENGINE = InnoDB,
       PARTITION `P20250312` VALUES LESS THAN (739688) ENGINE = InnoDB,
       PARTITION `P20250313` VALUES LESS THAN (739689) ENGINE = InnoDB,
       PARTITION `P20250314` VALUES LESS THAN (739690) ENGINE = InnoDB,
       PARTITION `P20250315` VALUES LESS THAN (739691) ENGINE = InnoDB,
       PARTITION `P20250316` VALUES LESS THAN (739692) ENGINE = InnoDB,
       PARTITION `P20250317` VALUES LESS THAN (739693) ENGINE = InnoDB,
       PARTITION `P20250318` VALUES LESS THAN (739694) ENGINE = InnoDB,
       PARTITION `P20250319` VALUES LESS THAN (739695) ENGINE = InnoDB,
       PARTITION `P20250320` VALUES LESS THAN (739696) ENGINE = InnoDB,
       PARTITION `P20250321` VALUES LESS THAN (739697) ENGINE = InnoDB,
       PARTITION `P20250322` VALUES LESS THAN (739698) ENGINE = InnoDB,
       PARTITION `P20250323` VALUES LESS THAN (739699) ENGINE = InnoDB,
       PARTITION `P20250324` VALUES LESS THAN (739700) ENGINE = InnoDB,
       PARTITION `P20250325` VALUES LESS THAN (739701) ENGINE = InnoDB,
       PARTITION `P20250326` VALUES LESS THAN (739702) ENGINE = InnoDB,
       PARTITION `P20250327` VALUES LESS THAN (739703) ENGINE = InnoDB,
       PARTITION `P20250328` VALUES LESS THAN (739704) ENGINE = InnoDB,
       PARTITION `P20250329` VALUES LESS THAN (739705) ENGINE = InnoDB,
       PARTITION `P20250330` VALUES LESS THAN (739706) ENGINE = InnoDB,
       PARTITION `P20250331` VALUES LESS THAN (739707) ENGINE = InnoDB,
       PARTITION `P20250401` VALUES LESS THAN (739708) ENGINE = InnoDB,
       PARTITION `P20250402` VALUES LESS THAN (739709) ENGINE = InnoDB,
       PARTITION `P20250403` VALUES LESS THAN (739710) ENGINE = InnoDB,
       PARTITION `P20250404` VALUES LESS THAN (739711) ENGINE = InnoDB,
       PARTITION `P20250405` VALUES LESS THAN (739712) ENGINE = InnoDB,
       PARTITION `P20250406` VALUES LESS THAN (739713) ENGINE = InnoDB,
       PARTITION `P20250407` VALUES LESS THAN (739714) ENGINE = InnoDB,
       PARTITION `P20250408` VALUES LESS THAN (739715) ENGINE = InnoDB,
       PARTITION `P20250409` VALUES LESS THAN (739716) ENGINE = InnoDB,
       PARTITION `P20250410` VALUES LESS THAN (739717) ENGINE = InnoDB,
       PARTITION `P20250411` VALUES LESS THAN (739718) ENGINE = InnoDB,
       PARTITION `P20250412` VALUES LESS THAN (739719) ENGINE = InnoDB,
       PARTITION `P20250413` VALUES LESS THAN (739720) ENGINE = InnoDB,
       PARTITION `P20250414` VALUES LESS THAN (739721) ENGINE = InnoDB,
       PARTITION `P20250415` VALUES LESS THAN (739722) ENGINE = InnoDB,
       PARTITION `P20250416` VALUES LESS THAN (739723) ENGINE = InnoDB,
       PARTITION `P20250417` VALUES LESS THAN (739724) ENGINE = InnoDB,
       PARTITION `P20250418` VALUES LESS THAN (739725) ENGINE = InnoDB,
       PARTITION `P20250419` VALUES LESS THAN (739726) ENGINE = InnoDB,
       PARTITION `P20250420` VALUES LESS THAN (739727) ENGINE = InnoDB,
       PARTITION `P20250421` VALUES LESS THAN (739728) ENGINE = InnoDB,
       PARTITION `P20250422` VALUES LESS THAN (739729) ENGINE = InnoDB,
       PARTITION `P20250423` VALUES LESS THAN (739730) ENGINE = InnoDB,
       PARTITION `P20250424` VALUES LESS THAN (739731) ENGINE = InnoDB,
       PARTITION `P20250425` VALUES LESS THAN (739732) ENGINE = InnoDB,
       PARTITION `P20250426` VALUES LESS THAN (739733) ENGINE = InnoDB,
       PARTITION `P20250427` VALUES LESS THAN (739734) ENGINE = InnoDB,
       PARTITION `P20250428` VALUES LESS THAN (739735) ENGINE = InnoDB,
       PARTITION `P20250429` VALUES LESS THAN (739736) ENGINE = InnoDB,
       PARTITION `P20250430` VALUES LESS THAN (739737) ENGINE = InnoDB,
       PARTITION `P20250501` VALUES LESS THAN (739738) ENGINE = InnoDB,
       PARTITION `P20250502` VALUES LESS THAN (739739) ENGINE = InnoDB,
       PARTITION `P20250503` VALUES LESS THAN (739740) ENGINE = InnoDB,
       PARTITION `P20250504` VALUES LESS THAN (739741) ENGINE = InnoDB,
       PARTITION `P20250505` VALUES LESS THAN (739742) ENGINE = InnoDB,
       PARTITION `P20250506` VALUES LESS THAN (739743) ENGINE = InnoDB,
       PARTITION `P20250507` VALUES LESS THAN (739744) ENGINE = InnoDB,
       PARTITION `P20250508` VALUES LESS THAN (739745) ENGINE = InnoDB,
       PARTITION `P20250509` VALUES LESS THAN (739746) ENGINE = InnoDB,
       PARTITION `P20250510` VALUES LESS THAN (739747) ENGINE = InnoDB,
       PARTITION `P20250511` VALUES LESS THAN (739748) ENGINE = InnoDB,
       PARTITION `P20250512` VALUES LESS THAN (739749) ENGINE = InnoDB,
       PARTITION `P20250513` VALUES LESS THAN (739750) ENGINE = InnoDB,
       PARTITION `P20250514` VALUES LESS THAN (739751) ENGINE = InnoDB,
       PARTITION `P20250515` VALUES LESS THAN (739752) ENGINE = InnoDB,
       PARTITION `P20250516` VALUES LESS THAN (739753) ENGINE = InnoDB,
       PARTITION `P20250517` VALUES LESS THAN (739754) ENGINE = InnoDB,
       PARTITION `P20250518` VALUES LESS THAN (739755) ENGINE = InnoDB,
       PARTITION `P20250519` VALUES LESS THAN (739756) ENGINE = InnoDB,
       PARTITION `P20250520` VALUES LESS THAN (739757) ENGINE = InnoDB,
       PARTITION `P20250521` VALUES LESS THAN (739758) ENGINE = InnoDB,
       PARTITION `P20250522` VALUES LESS THAN (739759) ENGINE = InnoDB,
       PARTITION `P20250523` VALUES LESS THAN (739760) ENGINE = InnoDB,
       PARTITION `P20250524` VALUES LESS THAN (739761) ENGINE = InnoDB,
       PARTITION `P20250525` VALUES LESS THAN (739762) ENGINE = InnoDB,
       PARTITION `P20250526` VALUES LESS THAN (739763) ENGINE = InnoDB,
       PARTITION `P20250527` VALUES LESS THAN (739764) ENGINE = InnoDB,
       PARTITION `P20250528` VALUES LESS THAN (739765) ENGINE = InnoDB,
       PARTITION `P20250529` VALUES LESS THAN (739766) ENGINE = InnoDB,
       PARTITION `P20250530` VALUES LESS THAN (739767) ENGINE = InnoDB,
       PARTITION `P20250531` VALUES LESS THAN (739768) ENGINE = InnoDB,
       PARTITION `P20250601` VALUES LESS THAN (739769) ENGINE = InnoDB,
       PARTITION `P20250602` VALUES LESS THAN (739770) ENGINE = InnoDB,
       PARTITION `P20250603` VALUES LESS THAN (739771) ENGINE = InnoDB,
       PARTITION `P20250604` VALUES LESS THAN (739772) ENGINE = InnoDB,
       PARTITION `P20250605` VALUES LESS THAN (739773) ENGINE = InnoDB,
       PARTITION `P20250606` VALUES LESS THAN (739774) ENGINE = InnoDB,
       PARTITION `P20250607` VALUES LESS THAN (739775) ENGINE = InnoDB,
       PARTITION `P20250608` VALUES LESS THAN (739776) ENGINE = InnoDB,
       PARTITION `P20250609` VALUES LESS THAN (739777) ENGINE = InnoDB,
       PARTITION `P20250610` VALUES LESS THAN (739778) ENGINE = InnoDB,
       PARTITION `P20250611` VALUES LESS THAN (739779) ENGINE = InnoDB,
       PARTITION `P20250612` VALUES LESS THAN (739780) ENGINE = InnoDB,
       PARTITION `P20250613` VALUES LESS THAN (739781) ENGINE = InnoDB,
       PARTITION `P20250614` VALUES LESS THAN (739782) ENGINE = InnoDB,
       PARTITION `P20250615` VALUES LESS THAN (739783) ENGINE = InnoDB,
       PARTITION `P20250616` VALUES LESS THAN (739784) ENGINE = InnoDB,
       PARTITION `P20250617` VALUES LESS THAN (739785) ENGINE = InnoDB,
       PARTITION `P20250618` VALUES LESS THAN (739786) ENGINE = InnoDB,
       PARTITION `P20250619` VALUES LESS THAN (739787) ENGINE = InnoDB,
       PARTITION `P20250620` VALUES LESS THAN (739788) ENGINE = InnoDB,
       PARTITION `P20250621` VALUES LESS THAN (739789) ENGINE = InnoDB,
       PARTITION `P20250622` VALUES LESS THAN (739790) ENGINE = InnoDB,
       PARTITION `P20250623` VALUES LESS THAN (739791) ENGINE = InnoDB,
       PARTITION `P20250624` VALUES LESS THAN (739792) ENGINE = InnoDB,
       PARTITION `P20250625` VALUES LESS THAN (739793) ENGINE = InnoDB,
       PARTITION `P20250626` VALUES LESS THAN (739794) ENGINE = InnoDB,
       PARTITION `P20250627` VALUES LESS THAN (739795) ENGINE = InnoDB,
       PARTITION `P20250628` VALUES LESS THAN (739796) ENGINE = InnoDB,
       PARTITION `P20250629` VALUES LESS THAN (739797) ENGINE = InnoDB,
       PARTITION `P20250630` VALUES LESS THAN (739798) ENGINE = InnoDB,
       PARTITION `P20250701` VALUES LESS THAN (739799) ENGINE = InnoDB,
       PARTITION `P20250702` VALUES LESS THAN (739800) ENGINE = InnoDB,
       PARTITION `P20250703` VALUES LESS THAN (739801) ENGINE = InnoDB,
       PARTITION `P20250704` VALUES LESS THAN (739802) ENGINE = InnoDB,
       PARTITION `P20250705` VALUES LESS THAN (739803) ENGINE = InnoDB,
       PARTITION `P20250706` VALUES LESS THAN (739804) ENGINE = InnoDB,
       PARTITION `P20250707` VALUES LESS THAN (739805) ENGINE = InnoDB,
       PARTITION `P20250708` VALUES LESS THAN (739806) ENGINE = InnoDB,
       PARTITION `P20250709` VALUES LESS THAN (739807) ENGINE = InnoDB,
       PARTITION `P20250710` VALUES LESS THAN (739808) ENGINE = InnoDB,
       PARTITION `P20250711` VALUES LESS THAN (739809) ENGINE = InnoDB,
       PARTITION `P20250712` VALUES LESS THAN (739810) ENGINE = InnoDB,
       PARTITION `P20250713` VALUES LESS THAN (739811) ENGINE = InnoDB,
       PARTITION `P20250714` VALUES LESS THAN (739812) ENGINE = InnoDB,
       PARTITION `P20250715` VALUES LESS THAN (739813) ENGINE = InnoDB,
       PARTITION `P20250716` VALUES LESS THAN (739814) ENGINE = InnoDB,
       PARTITION `P20250717` VALUES LESS THAN (739815) ENGINE = InnoDB,
       PARTITION `P20250718` VALUES LESS THAN (739816) ENGINE = InnoDB,
       PARTITION `P20250719` VALUES LESS THAN (739817) ENGINE = InnoDB,
       PARTITION `P20250720` VALUES LESS THAN (739818) ENGINE = InnoDB,
       PARTITION `P20250721` VALUES LESS THAN (739819) ENGINE = InnoDB,
       PARTITION `P20250722` VALUES LESS THAN (739820) ENGINE = InnoDB,
       PARTITION `P20250723` VALUES LESS THAN (739821) ENGINE = InnoDB,
       PARTITION `P20250724` VALUES LESS THAN (739822) ENGINE = InnoDB,
       PARTITION `P20250725` VALUES LESS THAN (739823) ENGINE = InnoDB,
       PARTITION `P20250726` VALUES LESS THAN (739824) ENGINE = InnoDB,
       PARTITION `P20250727` VALUES LESS THAN (739825) ENGINE = InnoDB,
       PARTITION `P20250728` VALUES LESS THAN (739826) ENGINE = InnoDB,
       PARTITION `P20250729` VALUES LESS THAN (739827) ENGINE = InnoDB,
       PARTITION `P20250730` VALUES LESS THAN (739828) ENGINE = InnoDB,
       PARTITION `P20250731` VALUES LESS THAN (739829) ENGINE = InnoDB,
       PARTITION `P20250801` VALUES LESS THAN (739830) ENGINE = InnoDB,
       PARTITION `P20250802` VALUES LESS THAN (739831) ENGINE = InnoDB,
       PARTITION `P20250803` VALUES LESS THAN (739832) ENGINE = InnoDB,
       PARTITION `P20250804` VALUES LESS THAN (739833) ENGINE = InnoDB,
       PARTITION `P20250805` VALUES LESS THAN (739834) ENGINE = InnoDB,
       PARTITION `P20250806` VALUES LESS THAN (739835) ENGINE = InnoDB,
       PARTITION `P20250807` VALUES LESS THAN (739836) ENGINE = InnoDB,
       PARTITION `P20250808` VALUES LESS THAN (739837) ENGINE = InnoDB,
       PARTITION `P20250809` VALUES LESS THAN (739838) ENGINE = InnoDB,
       PARTITION `P20250810` VALUES LESS THAN (739839) ENGINE = InnoDB,
       PARTITION `P20250811` VALUES LESS THAN (739840) ENGINE = InnoDB,
       PARTITION `P20250812` VALUES LESS THAN (739841) ENGINE = InnoDB,
       PARTITION `P20250813` VALUES LESS THAN (739842) ENGINE = InnoDB,
       PARTITION `P20250814` VALUES LESS THAN (739843) ENGINE = InnoDB,
       PARTITION `P20250815` VALUES LESS THAN (739844) ENGINE = InnoDB,
       PARTITION `P20250816` VALUES LESS THAN (739845) ENGINE = InnoDB,
       PARTITION `P20250817` VALUES LESS THAN (739846) ENGINE = InnoDB,
       PARTITION `P20250818` VALUES LESS THAN (739847) ENGINE = InnoDB,
       PARTITION `P20250819` VALUES LESS THAN (739848) ENGINE = InnoDB,
       PARTITION `P20250820` VALUES LESS THAN (739849) ENGINE = InnoDB,
       PARTITION `P20250821` VALUES LESS THAN (739850) ENGINE = InnoDB,
       PARTITION `P20250822` VALUES LESS THAN (739851) ENGINE = InnoDB,
       PARTITION `P20250823` VALUES LESS THAN (739852) ENGINE = InnoDB,
       PARTITION `P20250824` VALUES LESS THAN (739853) ENGINE = InnoDB,
       PARTITION `P20250825` VALUES LESS THAN (739854) ENGINE = InnoDB,
       PARTITION `P20250826` VALUES LESS THAN (739855) ENGINE = InnoDB,
       PARTITION `P20250827` VALUES LESS THAN (739856) ENGINE = InnoDB,
       PARTITION `P20250828` VALUES LESS THAN (739857) ENGINE = InnoDB,
       PARTITION `P20250829` VALUES LESS THAN (739858) ENGINE = InnoDB,
       PARTITION `P20250830` VALUES LESS THAN (739859) ENGINE = InnoDB,
       PARTITION `P20250831` VALUES LESS THAN (739860) ENGINE = InnoDB,
       PARTITION `P20250901` VALUES LESS THAN (739861) ENGINE = InnoDB,
       PARTITION `P20250902` VALUES LESS THAN (739862) ENGINE = InnoDB,
       PARTITION `P20250903` VALUES LESS THAN (739863) ENGINE = InnoDB,
       PARTITION `P20250904` VALUES LESS THAN (739864) ENGINE = InnoDB,
       PARTITION `P20250905` VALUES LESS THAN (739865) ENGINE = InnoDB,
       PARTITION `P20250906` VALUES LESS THAN (739866) ENGINE = InnoDB,
       PARTITION `P20250907` VALUES LESS THAN (739867) ENGINE = InnoDB,
       PARTITION `P20250908` VALUES LESS THAN (739868) ENGINE = InnoDB,
       PARTITION `P20250909` VALUES LESS THAN (739869) ENGINE = InnoDB,
       PARTITION `P20250910` VALUES LESS THAN (739870) ENGINE = InnoDB,
       PARTITION `P20250911` VALUES LESS THAN (739871) ENGINE = InnoDB,
       PARTITION `P20250912` VALUES LESS THAN (739872) ENGINE = InnoDB,
       PARTITION `P20250913` VALUES LESS THAN (739873) ENGINE = InnoDB,
       PARTITION `P20250914` VALUES LESS THAN (739874) ENGINE = InnoDB,
       PARTITION `P20250915` VALUES LESS THAN (739875) ENGINE = InnoDB,
       PARTITION `P20250916` VALUES LESS THAN (739876) ENGINE = InnoDB,
       PARTITION `P20250917` VALUES LESS THAN (739877) ENGINE = InnoDB,
       PARTITION `P20250918` VALUES LESS THAN (739878) ENGINE = InnoDB,
       PARTITION `P20250919` VALUES LESS THAN (739879) ENGINE = InnoDB,
       PARTITION `P20250920` VALUES LESS THAN (739880) ENGINE = InnoDB,
       PARTITION `P20250921` VALUES LESS THAN (739881) ENGINE = InnoDB,
       PARTITION `P20250922` VALUES LESS THAN (739882) ENGINE = InnoDB,
       PARTITION `P20250923` VALUES LESS THAN (739883) ENGINE = InnoDB,
       PARTITION `P20250924` VALUES LESS THAN (739884) ENGINE = InnoDB,
       PARTITION `P20250925` VALUES LESS THAN (739885) ENGINE = InnoDB,
       PARTITION `P20250926` VALUES LESS THAN (739886) ENGINE = InnoDB,
       PARTITION `P20250927` VALUES LESS THAN (739887) ENGINE = InnoDB,
       PARTITION `P20250928` VALUES LESS THAN (739888) ENGINE = InnoDB,
       PARTITION `P20250929` VALUES LESS THAN (739889) ENGINE = InnoDB,
       PARTITION `P20250930` VALUES LESS THAN (739890) ENGINE = InnoDB,
       PARTITION `P20251001` VALUES LESS THAN (739891) ENGINE = InnoDB,
       PARTITION `P20251002` VALUES LESS THAN (739892) ENGINE = InnoDB,
       PARTITION `P20251003` VALUES LESS THAN (739893) ENGINE = InnoDB,
       PARTITION `P20251004` VALUES LESS THAN (739894) ENGINE = InnoDB,
       PARTITION `P20251005` VALUES LESS THAN (739895) ENGINE = InnoDB,
       PARTITION `P20251006` VALUES LESS THAN (739896) ENGINE = InnoDB,
       PARTITION `P20251007` VALUES LESS THAN (739897) ENGINE = InnoDB,
       PARTITION `P20251008` VALUES LESS THAN (739898) ENGINE = InnoDB,
       PARTITION `P20251009` VALUES LESS THAN (739899) ENGINE = InnoDB,
       PARTITION `P20251010` VALUES LESS THAN (739900) ENGINE = InnoDB,
       PARTITION `P20251011` VALUES LESS THAN (739901) ENGINE = InnoDB,
       PARTITION `P20251012` VALUES LESS THAN (739902) ENGINE = InnoDB,
       PARTITION `P20251013` VALUES LESS THAN (739903) ENGINE = InnoDB,
       PARTITION `P20251014` VALUES LESS THAN (739904) ENGINE = InnoDB,
       PARTITION `P20251015` VALUES LESS THAN (739905) ENGINE = InnoDB,
       PARTITION `P20251016` VALUES LESS THAN (739906) ENGINE = InnoDB,
       PARTITION `P20251017` VALUES LESS THAN (739907) ENGINE = InnoDB,
       PARTITION `P20251018` VALUES LESS THAN (739908) ENGINE = InnoDB,
       PARTITION `P20251019` VALUES LESS THAN (739909) ENGINE = InnoDB,
       PARTITION `P20251020` VALUES LESS THAN (739910) ENGINE = InnoDB,
       PARTITION `P20251021` VALUES LESS THAN (739911) ENGINE = InnoDB,
       PARTITION `P20251022` VALUES LESS THAN (739912) ENGINE = InnoDB,
       PARTITION `P20251023` VALUES LESS THAN (739913) ENGINE = InnoDB,
       PARTITION `P20251024` VALUES LESS THAN (739914) ENGINE = InnoDB,
       PARTITION `P20251025` VALUES LESS THAN (739915) ENGINE = InnoDB,
       PARTITION `P20251026` VALUES LESS THAN (739916) ENGINE = InnoDB,
       PARTITION `P20251027` VALUES LESS THAN (739917) ENGINE = InnoDB,
       PARTITION `P20251028` VALUES LESS THAN (739918) ENGINE = InnoDB,
       PARTITION `P20251029` VALUES LESS THAN (739919) ENGINE = InnoDB,
       PARTITION `P20251030` VALUES LESS THAN (739920) ENGINE = InnoDB,
       PARTITION `P20251031` VALUES LESS THAN (739921) ENGINE = InnoDB,
       PARTITION `P20251101` VALUES LESS THAN (739922) ENGINE = InnoDB,
       PARTITION `P20251102` VALUES LESS THAN (739923) ENGINE = InnoDB,
       PARTITION `P20251103` VALUES LESS THAN (739924) ENGINE = InnoDB,
       PARTITION `P20251104` VALUES LESS THAN (739925) ENGINE = InnoDB,
       PARTITION `P20251105` VALUES LESS THAN (739926) ENGINE = InnoDB,
       PARTITION `P20251106` VALUES LESS THAN (739927) ENGINE = InnoDB,
       PARTITION `P20251107` VALUES LESS THAN (739928) ENGINE = InnoDB,
       PARTITION `P20251108` VALUES LESS THAN (739929) ENGINE = InnoDB,
       PARTITION `P20251109` VALUES LESS THAN (739930) ENGINE = InnoDB,
       PARTITION `P20251110` VALUES LESS THAN (739931) ENGINE = InnoDB,
       PARTITION `P20251111` VALUES LESS THAN (739932) ENGINE = InnoDB,
       PARTITION `P20251112` VALUES LESS THAN (739933) ENGINE = InnoDB,
       PARTITION `P20251113` VALUES LESS THAN (739934) ENGINE = InnoDB,
       PARTITION `P20251114` VALUES LESS THAN (739935) ENGINE = InnoDB,
       PARTITION `P20251115` VALUES LESS THAN (739936) ENGINE = InnoDB,
       PARTITION `P20251116` VALUES LESS THAN (739937) ENGINE = InnoDB,
       PARTITION `P20251117` VALUES LESS THAN (739938) ENGINE = InnoDB,
       PARTITION `P20251118` VALUES LESS THAN (739939) ENGINE = InnoDB,
       PARTITION `P20251119` VALUES LESS THAN (739940) ENGINE = InnoDB,
       PARTITION `P20251120` VALUES LESS THAN (739941) ENGINE = InnoDB,
       PARTITION `P20251121` VALUES LESS THAN (739942) ENGINE = InnoDB,
       PARTITION `P20251122` VALUES LESS THAN (739943) ENGINE = InnoDB,
       PARTITION `P20251123` VALUES LESS THAN (739944) ENGINE = InnoDB,
       PARTITION `P20251124` VALUES LESS THAN (739945) ENGINE = InnoDB,
       PARTITION `P20251125` VALUES LESS THAN (739946) ENGINE = InnoDB,
       PARTITION `P20251126` VALUES LESS THAN (739947) ENGINE = InnoDB,
       PARTITION `P20251127` VALUES LESS THAN (739948) ENGINE = InnoDB,
       PARTITION `P20251128` VALUES LESS THAN (739949) ENGINE = InnoDB,
       PARTITION `P20251129` VALUES LESS THAN (739950) ENGINE = InnoDB,
       PARTITION `P20251130` VALUES LESS THAN (739951) ENGINE = InnoDB,
       PARTITION `P20251201` VALUES LESS THAN (739952) ENGINE = InnoDB,
       PARTITION `P20251202` VALUES LESS THAN (739953) ENGINE = InnoDB,
       PARTITION `P20251203` VALUES LESS THAN (739954) ENGINE = InnoDB,
       PARTITION `P20251204` VALUES LESS THAN (739955) ENGINE = InnoDB,
       PARTITION `P20251205` VALUES LESS THAN (739956) ENGINE = InnoDB,
       PARTITION `P20251206` VALUES LESS THAN (739957) ENGINE = InnoDB,
       PARTITION `P20251207` VALUES LESS THAN (739958) ENGINE = InnoDB,
       PARTITION `P20251208` VALUES LESS THAN (739959) ENGINE = InnoDB,
       PARTITION `P20251209` VALUES LESS THAN (739960) ENGINE = InnoDB,
       PARTITION `P20251210` VALUES LESS THAN (739961) ENGINE = InnoDB,
       PARTITION `P20251211` VALUES LESS THAN (739962) ENGINE = InnoDB,
       PARTITION `P20251212` VALUES LESS THAN (739963) ENGINE = InnoDB,
       PARTITION `P20251213` VALUES LESS THAN (739964) ENGINE = InnoDB,
       PARTITION `P20251214` VALUES LESS THAN (739965) ENGINE = InnoDB,
       PARTITION `P20251215` VALUES LESS THAN (739966) ENGINE = InnoDB,
       PARTITION `P20251216` VALUES LESS THAN (739967) ENGINE = InnoDB,
       PARTITION `P20251217` VALUES LESS THAN (739968) ENGINE = InnoDB,
       PARTITION `P20251218` VALUES LESS THAN (739969) ENGINE = InnoDB,
       PARTITION `P20251219` VALUES LESS THAN (739970) ENGINE = InnoDB,
       PARTITION `P20251220` VALUES LESS THAN (739971) ENGINE = InnoDB,
       PARTITION `P20251221` VALUES LESS THAN (739972) ENGINE = InnoDB,
       PARTITION `P20251222` VALUES LESS THAN (739973) ENGINE = InnoDB,
       PARTITION `P20251223` VALUES LESS THAN (739974) ENGINE = InnoDB,
       PARTITION `P20251224` VALUES LESS THAN (739975) ENGINE = InnoDB,
       PARTITION `P20251225` VALUES LESS THAN (739976) ENGINE = InnoDB,
       PARTITION `P20251226` VALUES LESS THAN (739977) ENGINE = InnoDB,
       PARTITION `P20251227` VALUES LESS THAN (739978) ENGINE = InnoDB,
       PARTITION `P20251228` VALUES LESS THAN (739979) ENGINE = InnoDB,
       PARTITION `P20251229` VALUES LESS THAN (739980) ENGINE = InnoDB,
       PARTITION `P20251230` VALUES LESS THAN (739981) ENGINE = InnoDB,
       PARTITION `P20251231` VALUES LESS THAN (739982) ENGINE = InnoDB,
       PARTITION `P20260101` VALUES LESS THAN (739983) ENGINE = InnoDB,
       PARTITION `PMAX` VALUES LESS THAN MAXVALUE ENGINE = InnoDB);
      

      Query

      SELECT COUNT(1) FROM t1 WHERE dt BETWEEN '2025-06-30' AND '2025-07-01';
      

      Optimizer should just scan partitions P20250630,P20250701 but for some reason it also scans P20240101.

      Query Explain plan

      MariaDB [test]> explain partitions SELECT COUNT(1) FROM t1 WHERE dt BETWEEN '2025-06-30' AND '2025-07-01';
      +------+-------------+-------+-------------------------------+------+---------------+------+---------+------+------+-------------+
      | id   | select_type | table | partitions                    | type | possible_keys | key  | key_len | ref  | rows | Extra       |
      +------+-------------+-------+-------------------------------+------+---------------+------+---------+------+------+-------------+
      |    1 | SIMPLE      | t1    | P20240101,P20250630,P20250701 | ALL  | NULL          | NULL | NULL    | NULL | 3    | Using where |
      +------+-------------+-------+-------------------------------+------+---------------+------+---------+------+------+-------------+
      1 row in set (0.003 sec)
      

      MariaDB [test]> explain format=json  SELECT COUNT(1) FROM t1 WHERE dt BETWEEN '2025-06-30' AND '2025-07-01'\G
      *************************** 1. row ***************************
      EXPLAIN: {
        "query_block": {
          "select_id": 1,
          "cost": 7.3330534,
          "nested_loop": [
            {
              "table": {
                "table_name": "t1",
                "partitions": ["P20240101", "P20250630", "P20250701"],
                "access_type": "ALL",
                "loops": 1,
                "rows": 3,
                "cost": 7.3330534,
                "filtered": 100,
                "attached_condition": "t1.dt between '2025-06-30 00:00:00.000000' and '2025-07-01 00:00:00.000000'"
              }
            }
          ]
        }
      }
      1 row in set (0.002 sec)
      

      Strangely, this only seems to happen if the WHERE clause spans across multiple month partitions.
      But for the same month partition, it does not exhibit this behaviour.

      MariaDB [test]> explain partitions SELECT COUNT(1) FROM test.t1 aa WHERE aa.dt BETWEEN '2025-08-02' AND '2025-08-12';
      +------+-------------+-------+---------------------------------------------------------------------------------------------------------------+------+---------------+------+---------+------+------+-------------+
      | id   | select_type | table | partitions                                                                                                    | type | possible_keys | key  | key_len | ref  | rows | Extra       |
      +------+-------------+-------+---------------------------------------------------------------------------------------------------------------+------+---------------+------+---------+------+------+-------------+
      |    1 | SIMPLE      | aa    | P20250802,P20250803,P20250804,P20250805,P20250806,P20250807,P20250808,P20250809,P20250810,P20250811,P20250812 | ALL  | NULL          | NULL | NULL    | NULL | 11   | Using where |
      +------+-------------+-------+---------------------------------------------------------------------------------------------------------------+------+---------------+------+---------+------+------+-------------+
      1 row in set (0.001 sec)
      

      Attachments

        Activity

          People

            Gosselin Dave Gosselin
            susmeet.khaire Susmeet Khaire
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.