分页保序开启，limit 条件不能下压到基表

obclient [new]> create table t1(c1 int, c2 int, c3 int, c4 int, c5 int, c6 varchar(20), primary key(c1));
Query OK, 0 rows affected (0.396 sec)

obclient [new]> insert into t1 select row_number() over(), row_number() over(), row_number() over(), row_number() over(),row_number() over(), row_number() over() from TABLE(GENERATOR(100000));
Query OK, 100000 rows affected (1.233 sec)
Records: 100000  Duplicates: 0  Warnings: 0

obclient [new]> create table t2 (c1 int, c2 int, c3 int, c4 varchar(20));
Query OK, 0 rows affected (0.348 sec)

obclient [new]> insert into t2 select row_number() over(), row_number() over(), row_number() over(), row_number() over()  from TABLE(GENERATOR(40000));
Query OK, 40000 rows affected (0.894 sec)
Records: 40000  Duplicates: 0  Warnings: 0

obclient [new]> create table t3 (c1 int, c2 int, c3 int, c4 varchar(20));
Query OK, 0 rows affected (0.559 sec)

obclient [new]> insert into t3 select row_number() over(), row_number() over(),row_number() over(), row_number() over() from TABLE(GENERATOR(20000));
Query OK, 20000 rows affected (0.590 sec)
Records: 20000  Duplicates: 0  Warnings: 0

select t2.c2,t2.c3,t1.c5,t1.c4,t3.c2,t3.c4
from t1
    left join t2 on t1.c2 = t2.c3
    left join t3 on t3.c3 is not null
    and t3.c3 = t1.c5
where t1.c2 = 200
order by t1.c1 desc
limit 0, 10;

select
    /*+ OPT_PARAM('PRESERVE_ORDER_FOR_PAGINATION' 'true') */
    `new`.`t2`.`c2`,
    `new`.`t2`.`c3`,
    `new`.`t1`.`c5`,
    `new`.`t1`.`c4`,
    `new`.`t3`.`c2`,
    `new`.`t3`.`c4`
from (
  (
    `new`.`t1`
    left join `new`.`t2` on (`new`.`t1`.`c2` = `new`.`t2`.`c3`)
  )
  left join `new`.`t3` on (`new`.`t3`.`c3` is not null)
  and (`new`.`t3`.`c3` = `new`.`t1`.`c5`)
)
where (`new`.`t1`.`c2` = :0)
order by `new`.`t1`.`c1` desc,
    1,
    2,
    3,
    4,
    5,
    6
limit :1, :2

select
    /*+opt_param('preserve_order_for_pagination','true')*/ t2.c2,t2.c3,t1.c5,t1.c4,t3.c2,t3.c4
from (
        select *
        from t1
        where t1.c2 = 200
        order by t1.c1 desc
        limit 0, 10
    ) t1
    left join t2 on t1.c2 = t2.c3
    left join t3 on t3.c3 is not null
    and t3.c3 = t1.c5
order by t1.c1 desc
limit 0, 10;