PIO and LIO different with different where order

 set max_recursive_iterations = 100000000;

drop table if exists  `t1`;

CREATE TABLE `t1` (

 `c1` int(11) DEFAULT NULL,

 `c2` int(11) DEFAULT NULL

   ) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

      INSERT INTO `t1`  (

with recursive series as (

select 5552698 as c2,FLOOR(1697580000 + (RAND() * 10000)) as c1 union all

select c2 +1 as c2, FLOOR(1697580000 + (RAND() * 10000))  as c1  from series

where c2 < 26562718)

select c1,c2 from series);

SELECT calSetTrace(1);

select calFlushCache();

select count(1) from t1 where c1 between 1697580000 and 1697598000 and c2 in (5552698,5552869,5553096,5553534,5553798,5554779,5555176);

SELECT calGetTrace();

SELECT calSetTrace(1);

select calFlushCache();

select count(1) from t1 where c2 in (5552698,5552869,5553096,5553534,5553798,5554779,5555176) and c1 between 1697580000 and 1697598000;

SELECT calGetTrace();

Desc Mode Table TableOID ReferencedColumns PIO  LIO  PBE  Elapsed Rows

BPS  PM   t1    3111     (c1,c2)           5122 5120 6167 0.136   1024

TAS  UM   -     -        -                 -    -    -    0.123   1

TNS  UM   -     -        -                 -    -    -    0.000   1

Desc Mode Table TableOID ReferencedColumns PIO  LIO  PBE  Elapsed Rows

BPS  PM   t1    3111     (c1,c2)           9216 9214 6167 0.196   1024

TAS  UM   -     -        -                 -    -    -    0.170   1

TNS  UM   -     -        -                 -    -    -    0.000   1