[GitHub] [incubator-doris] hf200012 commented on issue #9545: [Bug] Error in join operation using subquery containing row_number

[GitBox <gi...@apache.org>]

hf200012 commented on issue #9545:
URL: https://github.com/apache/incubator-doris/issues/9545#issuecomment-1125790882

   upgrade 1.0 
   ```
   mysql> insert into test.rownumber_test_00
       -> select
       -> t0.id,
       -> t1.name
       -> from
       -> test.rownumber_test_01 t0
       -> left join
       -> (select
       -> t.client_actor_id,
       -> t.name
       -> from
       -> (select
       -> t1.client_actor_id,
       -> t2.name,
       -> row_number()OVER(PARTITION BY t1.client_actor_id,t1.service_actor_id,t1.service_application,t2.name ORDER BY t1.refresh_token_expiration desc) AS rn
       -> from test.rownumber_test_02 t1
       -> left join test.rownumber_test_03 t2
       -> on t1.id = t2.token_id and t2.is_deleted_flg=0
       -> where t1.is_deleted_flg=0) t
       -> where t.rn = 1
       -> ) t1
       -> on t0.id= t1.client_actor_id
       -> ;
   Query OK, 0 rows affected (0.04 sec)
   {'label':'insert_4e331671d65a4303-834e7fea963d08cc', 'status':'VISIBLE', 'txnId':'17042'}
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org