/*
error_message:
db1: Database execute error: HY000, [MySQL][ODBC 8.4(a) Driver][mysqld-8.0.11-TiDB-v8.2.0-alpha-216-gfe5858b]runtime error: index out of range [1] with length 1
db2: Database execute error: HY000, [MySQL][ODBC 8.4(a) Driver][mysqld-8.0.11-TiDB-v8.2.0-alpha-216-gfe5858b]runtime error: index out of range [1] with length 1
*/

/*
query_plan:
Projection
  TopN
    Apply
      TableReader(Build)
        TableFullScan
      Selection(Probe)
        Projection
          Limit
            Selection
              Projection
                Shuffle
                  Window
                    Sort
                      ShuffleReceiver
                        Projection
                          HashJoin
                            TableReader(Build)
                              Selection
                                TableFullScan
                            HashJoin(Probe)
                              TableReader(Build)
                                TableFullScan
                              HashJoin(Probe)
                                TableReader(Build)
                                  Selection
                                    TableFullScan
                                TableReader(Probe)
                                  Selection
                                    TableFullScan

*/
WITH 
cte_0 AS (select  
    ref_0.c_qk as c0, 
    (select c_v13rl from t_n order by c_v13rl limit 1 offset 5)
       as c1, 
    ref_0.c_qk as c2, 
    ref_0.c_mzh as c3, 
    (select min(c_d) from t_db8a)
       as c4, 
    log(
      cast((NOT NOT(cast( (cast(ref_0.c_k4duc4l as signed) != cast(ref_0.c_k4duc4l as signed)) as unsigned))) as unsigned), 
      cast((case when (ref_0.c_irfjyds3 between ref_0.c_k4duc4l and ref_0.c_irfjyds3) then ref_0.c_kq8lwb else (NOT NOT(cast( (cast(26.75 as double) <> cast(2862378972385193803 as signed)) as unsigned))) end
           > ( 
        select  
            (NOT NOT(cast( (cast(1247265298 as signed) <=> cast(6930334 as signed)) as unsigned))) as c0
          from 
            t_tjov as ref_1
          where (ref_0.c_kq8lwb is not NULL)
          order by c0 asc
          limit 1)) as unsigned)) as c5, 
    cast( (cast(ref_0.c_tutmh1 as double) < cast(ref_0.c_irfjyds3 as signed)) as unsigned) as c6, 
    ref_0.c_mzh as c7
  from 
    t_tjov as ref_0
  where (NOT NOT(cast( (cast(abs(
        cast(ref_0.c_kq8lwb as signed)) as signed) XOR cast(truncate(
        cast(ref_0.c_tutmh1 as double), 
        cast(ref_0.c_k4duc4l as signed)) as double)) as unsigned)))), 
cte_1 AS (select distinct 
    
      lag(
        cast(ref_2.c_d as double)) over (partition by ref_2.c_d order by ref_2.c_t9, ref_2.c_d, ref_2.c_jr2kq78hqt, ref_2.c_yh_3) as c0, 
    ref_2.c_d as c1, 
    ref_2.c_t9 as c2, 
    ref_2.c_t9 as c3, 
    cast(coalesce(
      case when (substring(
            cast((select count(c_jr2kq78hqt) from t_db8a)
               as signed), 
            cast(ref_2.c_t9 as signed)) not like 'd3%2q') then ref_2.c_t9 else ref_2.c_yh_3 end
        , 
      ref_2.c_yh_3
      ) as signed) as c4, 
    is_ipv4_compat(
      cast(case when (cast(null as char) like 'ct_u5%mag_') then cast((select count(c_d) from t_db8a)
           as double) else cast(ref_2.c_d as double) end
         as char)) as c5, 
    ref_2.c_yh_3 as c6
  from 
    t_db8a as ref_2
  where (ref_2.c_yh_3 is not NULL)
  order by c0, c1, c2, c3, c4, c5, c6 desc
  limit 143), 
cte_2 AS (select  
    oct(
      cast(ref_6.c_fr3uo as signed)) as c0, 
    ref_4.c_pf6z4p as c1, 
    ref_5.c__57bl_eu6 as c2, 
    cast(nullif(
      ref_4.c_fr3uo, 
      ref_5.c_fr3uo
      ) as signed) as c3, 
    ref_4.c_fr3uo as c4, 
    
      nth_value(
        cast(ref_6.c_tf_us39fv as signed), 
        32) over (partition by ref_4.c_tf_us39fv, ref_5.c_tf_us39fv, ref_3.c_jr2kq78hqt, ref_6.c_v order by ref_3.c_t9, ref_3.c_d, ref_3.c_jr2kq78hqt, ref_3.c_yh_3, ref_4.c_tf_us39fv, ref_4.c_pf6z4p, ref_4.c_v13rl, ref_4.c_fr3uo, ref_4.c_v, ref_4.c_mm8jnf, ref_4.c__57bl_eu6, ref_5.c_tf_us39fv, ref_5.c_pf6z4p, ref_5.c_v13rl, ref_5.c_fr3uo, ref_5.c_v, ref_5.c_mm8jnf, ref_5.c__57bl_eu6, ref_6.c_tf_us39fv, ref_6.c_pf6z4p, ref_6.c_v13rl, ref_6.c_fr3uo, ref_6.c_v, ref_6.c_mm8jnf, ref_6.c__57bl_eu6) as c5, 
    ref_3.c_yh_3 as c6, 
    ref_4.c_v as c7
  from 
    (((t_db8a as ref_3
          cross join t_n as ref_4
          )
        inner join t_n as ref_5
        on (ref_4.c_v = ref_5.c_v13rl ))
      left outer join t_n as ref_6
      on ((NOT NOT(cast( (cast(ref_6.c_v as double) < cast(ref_6.c_tf_us39fv as signed)) as unsigned)))))
  where ('yi9' not like 'vmaf_5%q'))
select  
    -862238766 as c0, 
    ref_7.c_irfjyds3 as c1, 
    ref_7.c_kq8lwb as c2, 
    (select c_d from t_db8a order by c_d limit 1 offset 5)
       as c3
  from 
    t_tjov as ref_7
  where ((select c_v13rl from t_n order by c_v13rl limit 1 offset 2)
       < ( 
    select  
        ref_7.c_tutmh1 as c0
      from 
        cte_2 as ref_8
      where ((ref_7.c_mzh not like '%gw')) 
        or ((NOT NOT(cast( (cast(6748334263454491778 as signed) <= cast(-2168998945811100262 as signed)) as unsigned))))
      order by c0 asc
      limit 1))
  order by c0, c1, c2, c3 desc
  limit 50;