[GitHub] [shardingsphere] CheerwayRen commented on issue #8038: left join+order by cause NullPointerException

[GitBox]

CheerwayRen commented on issue #8038:
URL: https://github.com/apache/shardingsphere/issues/8038#issuecomment-864956928


   > @CheerwayRen I tried the demo, the `5.0.0-alpha` version has this problem, 
the latest `5.0.0-beta` has been fixed, please upgrade the version.
   
   
![image](https://user-images.githubusercontent.com/38515283/122753772-4ef4fa00-d2c5-11eb-9f7e-678d68cc988f.png)
   Hello, after I upgrade the version, the previous problem has been solved, 
but when MySQL configures sql_ mode is only_ full_ group_ by, there is a 
problem with SQL itself, but the framework throws  array out of bounds 
exception. When I modify sql_ mode to support the wrong group query, this 
exception will still be thrown: the sql is 
   SELECT
        msam.MALL_ID AS mallId,
        msad.SALE_YMD as saleYmd
        FROM
        mng_sale_amount_month msam
        LEFT JOIN mng_sale_amount_day msad ON msad.MONTH_ID = msam.ID
        WHERE
        msad.SALE_YMD IN ('20201201', '20210101') group by MALL_ID order by 
MALL_ID;


-- 
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.

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