Re: [I] [Bug] SELECT中存在多个 Window RANK 时，除第一个以外的RANK排序错误 [iotdb]

Sun, 17 May 2026 17:37:58 -0700 


Wei-hao-Li commented on issue #17635:
URL: https://github.com/apache/iotdb/issues/17635#issuecomment-4473130006

   > [@DaZuiZui](https://github.com/DaZuiZui) 
[@Wei-hao-Li](https://github.com/Wei-hao-Li) 
[@JackieTien97](https://github.com/JackieTien97) 
我进行了进一步测试，发现了如下几个问题，**为方便测试和复现我将建表、数据准备和CASE SQL都添加到了 附件中，方便复现和排查问题**：
   > 
   > [测试rank.sql](https://github.com/user-attachments/files/27903809/rank.sql)
   > 
   > case 1：对震幅和收盘价排序，ASC和DESC，结果是正确的
   > 
   > select
   >     "time",
   >     amplitude,
   >     close_hfq,
   >     ma_5,
   >     ma_64,
   >     ma_120,
   > --    RANK() OVER (ORDER BY "time" ) AS rank_time,
   >     RANK() OVER (ORDER BY "amplitude" DESC) AS rank_amplitude,
   >     RANK() OVER (ORDER BY "close_hfq" DESC) AS rank_close_hfq
   > --    RANK() OVER (ORDER BY ma_5) AS rank_ma5,
   > --    RANK() OVER (ORDER BY ma_64 DESC) AS rank_ma64,
   > --    RANK() OVER (ORDER BY ma_120) AS rank_ma120
   > FROM quant.stock_kline_weekly
   > WHERE "time" >= 2026-04-11
   > AND symbol = '600000'
   > ORDER BY "time";
   > DESC 情况 <img alt="Image" width="1302" height="641" 
src="https://private-user-images.githubusercontent.com/154792500/593719919-9ec08eb9-302b-4ad7-9449-568dd55db3ba.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzkwNjQ4ODEsIm5iZiI6MTc3OTA2NDU4MSwicGF0aCI6Ii8xNTQ3OTI1MDAvNTkzNzE5OTE5LTllYzA4ZWI5LTMwMmItNGFkNy05NDQ5LTU2OGRkNTVkYjNiYS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjYwNTE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI2MDUxOFQwMDM2MjFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1iNTZmNjFhZDg3M2ViMWUwOTY3NDdlZjExZTk3NWY3ZGZiMTIzOTI4ZjkzYjQzNjA3ZDlhN2Q1MmVhMDNmOWFkJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZyZXNwb25zZS1jb250ZW50LXR5cGU9aW1hZ2UlMkZwbmcifQ.u6UoeaVC2GQ1l9McEtrtI5PjY5h58RctEPisbQSUl14";>
 ASC 情况 <img alt="Image" width="975" height="668" 
src="https://private-user-images.githubusercontent.
 
com/154792500/593720444-7e5a381c-baaf-4d93-ad32-c95ae9ff48b2.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzkwNjQ4ODEsIm5iZiI6MTc3OTA2NDU4MSwicGF0aCI6Ii8xNTQ3OTI1MDAvNTkzNzIwNDQ0LTdlNWEzODFjLWJhYWYtNGQ5My1hZDMyLWM5NWFlOWZmNDhiMi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjYwNTE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI2MDUxOFQwMDM2MjFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0yMGY3OWQzMDRiNTQ4MWMyZmNjOWFmMTRlOWFlYzM5ODk1ZjE0YzA5ODk1YjVlZWZmZTUwZTNmNzBhMTAyZTBhJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZyZXNwb25zZS1jb250ZW50LXR5cGU9aW1hZ2UlMkZwbmcifQ.w-S9tawk8LNJYKLfjkyd8eP5Gx4OYooHafZcGODcSCs">
   > 
   > ### 以下是异常情况
   > case 2: 一旦我第一个rank带上时间，则会影响其后面的一个rank结果
   > 
   > <img alt="Image" width="1247" height="695" 
src="https://private-user-images.githubusercontent.com/154792500/593721354-ef459c63-5e85-4270-8731-b605f4252242.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzkwNjQ4ODEsIm5iZiI6MTc3OTA2NDU4MSwicGF0aCI6Ii8xNTQ3OTI1MDAvNTkzNzIxMzU0LWVmNDU5YzYzLTVlODUtNDI3MC04NzMxLWI2MDVmNDI1MjI0Mi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjYwNTE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI2MDUxOFQwMDM2MjFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0wNTdmNTllOGIxMzYxMzg0NmMxZjljZmFlMGJhMjYxNTA0MjdjZjNmM2I5ZDMxN2NiYzdiYzcyOWUzODA3MTRjJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZyZXNwb25zZS1jb250ZW50LXR5cGU9aW1hZ2UlMkZwbmcifQ.J-q4D3GFHTqHjZ31teW6aOuJfYbvzSmNlUbmfUm1DVc";>
 time DESC，time ASC 跟随了 time DESC，这也 不对 <img alt="Image" width="1294" 
height="729" src="https://pri
 
vate-user-images.githubusercontent.com/154792500/593721602-a18e201e-f002-45a1-af8b-3acc65d93711.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzkwNjQ4ODEsIm5iZiI6MTc3OTA2NDU4MSwicGF0aCI6Ii8xNTQ3OTI1MDAvNTkzNzIxNjAyLWExOGUyMDFlLWYwMDItNDVhMS1hZjhiLTNhY2M2NWQ5MzcxMS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjYwNTE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI2MDUxOFQwMDM2MjFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1kNDI4MjQ4YTkwMmNlZWY2OWNkZjgxY2NjZGE5M2JiMGVkMDFlYTg5MmFiMDhjNGQ1M2Q0YjIxYjYyMTRiOTM1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZyZXNwb25zZS1jb250ZW50LXR5cGU9aW1hZ2UlMkZwbmcifQ.BKKwyvPUcrdYkT0nXIWW-OgoowZBKr34axn09ilAvGU">
   > 2列 关于 time 的rank，后面那一列rank不会影响其后面的rank结果 <img alt="Image" width="1266" 
height="651" 
src="https://private-user-images.githubusercontent.com/154792500/593721126-b08b5c30-8512-4a2c-8413-e7116845bfb9.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzkwNjQ4ODEsIm5iZiI6MTc3OTA2NDU4MSwicGF0aCI6Ii8xNTQ3OTI1MDAvNTkzNzIxMTI2LWIwOGI1YzMwLTg1MTItNGEyYy04NDEzLWU3MTE2ODQ1YmZiOS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjYwNTE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI2MDUxOFQwMDM2MjFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0xNjY3MTQxMmZlNGY0YmRkYjdmZWZlMjIwMjQ1NTQ2MTZkNjViZTIwYzc3NDY0YjRjN2Y0ZjBhZTBhYzI3MGU0JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZyZXNwb25zZS1jb250ZW50LXR5cGU9aW1hZ2UlMkZwbmcifQ.Hikkmr7YjBXSy9bgg_1MxoZAplYy2wMWSYDzILL6aLs";>
   > 
   > 但是排序不对 <img alt="Image" width="1283" height="583" 
src="https://private-user-images.githubusercontent.com/154792500/593724885-93a3d62d-74cc-4172-8306-c8f991a783dc.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzkwNjQ4ODEsIm5iZiI6MTc3OTA2NDU4MSwicGF0aCI6Ii8xNTQ3OTI1MDAvNTkzNzI0ODg1LTkzYTNkNjJkLTc0Y2MtNDE3Mi04MzA2LWM4Zjk5MWE3ODNkYy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjYwNTE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI2MDUxOFQwMDM2MjFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1jZWQ1YmI1NmYwOGNhOTBiYTYwOTk1OTFlYjI1YmNlOWEwNjhjNjk2N2NiZTZiZTFkNGJkMDIzNDRhZDQ2YzRiJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZyZXNwb25zZS1jb250ZW50LXR5cGU9aW1hZ2UlMkZwbmcifQ.cMaJfnurQE5ThF7c5w2UAvR1T7YvPgVAXA0Ub5x7jt0";>
   > 
   > case 3：当我使用 ma 3、13、120测试时，后面的排序完全跟随于第一个 rank
   > 
   > <img alt="Image" width="1425" height="965" 
src="https://private-user-images.githubusercontent.com/154792500/593723080-b73a7921-db85-4328-a2fa-d3b1faaa952c.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzkwNjQ4ODEsIm5iZiI6MTc3OTA2NDU4MSwicGF0aCI6Ii8xNTQ3OTI1MDAvNTkzNzIzMDgwLWI3M2E3OTIxLWRiODUtNDMyOC1hMmZhLWQzYjFmYWFhOTUyYy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjYwNTE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI2MDUxOFQwMDM2MjFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT04ZTY1YWJkMzYyNDhmZDJkZDZiYzJiZTQzZjRhNWQ2NThmMjMzN2I2MDZkMzIxZmNjNDc5ZDliOWY3OTAzZDg1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZyZXNwb25zZS1jb250ZW50LXR5cGU9aW1hZ2UlMkZwbmcifQ.FAD3M3fvbiiJhNekl8DBDEkaErdJ0LutvMwBF88kyx4";>
   
   我试了一下确实还有问题，之前的修复没有覆盖到这个 case，我这两天再修一下


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to