Short key index not utilized as expected

[taiyang-li]

Steps to reproduce the behavior (Required)

1. create olap table

   CREATE TABLE `mytable` (
   `reportTime` bigint(20) NULL COMMENT "",
   `appId` bigint(20) NULL COMMENT "",
   `day` date NULL AS str2date(from_unixtime(reportTime), '%Y-%m-%d %H:%i:%s') COMMENT "",
   `rtime` datetime NULL AS str_to_date(from_unixtime(reportTime), '%Y-%m-%d %H:%i:%s') COMMENT ""
   ) ENGINE=OLAP 
   DUPLICATE KEY(`reportTime`, `appId`)
   PARTITION BY date_trunc('day', day)
   DISTRIBUTED BY HASH(`reportTime`, `appId`)
   PROPERTIES (
   "compression" = "LZ4",
   "partition_live_number" = "3",
   "replicated_storage" = "true",
   "replication_num" = "2"
   );

2. insert some random data
3. set enable_profile = true;
4. SELECT COUNT() FROM default.mytable WHERE day='2024-07-10' and reportTime >= 1720583999;
5. login fe webui, refer to corresponding profile of current query.

                - RemainingRowsAfterShortKeyFilter: 376.326M (376325576)
                  - __MAX_OF_RemainingRowsAfterShortKeyFilter: 2.056M (2056416)
                  - __MIN_OF_RemainingRowsAfterShortKeyFilter: 1.049M (1048576)
                - SegmentRuntimeZoneMapFilterRows: 0
                - SegmentZoneMapFilterRows: 0
                - ShortKeyFilter: 1.143us
                  - __MAX_OF_ShortKeyFilter: 9.063us
                  - __MIN_OF_ShortKeyFilter: 354ns
                - ShortKeyFilterRows: 0
                - ShortKeyRangeNumber: 0
                - ZoneMapIndexFilterRows: 0
                - ZoneMapIndexFiter: 3.258ms
                  - __MAX_OF_ZoneMapIndexFiter: 118.163ms
                  - __MIN_OF_ZoneMapIndexFiter: 183.467us

Expected behavior (Required)

ShortKeyFilterRows is not zero, and short key index is utilized

Real behavior (Required)

ShortKeyFilterRows is zero, and short key index is not utilized

StarRocks version (Required)

StarRocks Version: 3.3.0-19a3f66 (it was also found in 3.2.0)

[taiyang-li]

No one replied, let's close it.