[GitHub] [shardingsphere] leolv123 opened a new issue #7072: select 'count' column data, why return null?

Tue, 25 Aug 2020 19:06:12 -0700 


leolv123 opened a new issue #7072:
URL: https://github.com/apache/shardingsphere/issues/7072


   sharding print the log as follows:
   
   ``Sharding-Sphere-SQL : Logic SQL: select 
goods_size,waybill_id,`count`,goods_type
           from
           waybill_goods
           where enabled_flag=1
             AND (  
               waybill_id = ?
            or 
               waybill_id = ?
            )::: [[151027917487616978, 151027802266016180]]
   
   Sharding-Sphere-SQL                      : Actual SQL: oms_waybill_9 ::: 
select goods_size,waybill_id,`count`,goods_type
           from
           waybill_goods_78
           where enabled_flag=1
             AND (  
               waybill_id = ?
            or 
               waybill_id = ?
            ) ::: [[151027917487616978, 151027802266016180]]
   
   Sharding-Sphere-SQL                      : Actual SQL: oms_waybill_1 ::: 
select goods_size,waybill_id,`count`,goods_type
           from
           waybill_goods_80
           where enabled_flag=1
             AND (  
               waybill_id = ?
            or 
               waybill_id = ?
            ) ::: [[151027917487616978, 151027802266016180]]
   
   mysql output data as follows: 
   
![image](https://user-images.githubusercontent.com/34678371/91246803-5f127a80-e783-11ea-8d12-8216111028a5.png)
   
   
   Final return result as follows: 
   
![image](https://user-images.githubusercontent.com/34678371/91246901-9ed96200-e783-11ea-93f8-3c58dde95faa.png)
   
   why the column 'count' return null ???
   
   
   
   
   
   


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

Reply via email to