x782544391 opened a new issue, #32237:
URL: https://github.com/apache/shardingsphere/issues/32237

   ## Question
   
   similar to [#14016](https://github.com/apache/shardingsphere/issues/14016)
   
   version: 5.1.1
   
   SQL :SELECT  {som_column}
           FROM  table_a a
           LEFT JOIN  table_b  b  ON   {some_condition}
           LEFT JOIN  table_c   c  ON   {some_condition}
           LEFT JOIN  table_d  d  ON   {some_condition}
           LEFT JOIN  table_e  e  ON    {some_condition}
   (only table_a is sharding table)
   
   Question: 
          When query result is from more than one sharding table, 
shardingsphere throws the NullPointerExpection. I debug source code, found that 
ShardingSphereSchema doesn't contains non-sharding tables  in this SQL, so 
TableMetaData is null, this cause NPE.
   
   The source code is in 
org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByValue#getOrderValuesCaseSensitiveFromTables,
   line 74 cause NPE.
   
   
   Looking forward to your reply. Thanks!


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