[GitHub] [shardingsphere] strongduanmu commented on issue #17466: select union subquery NullPointerException

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

strongduanmu commented on issue #17466:
URL: https://github.com/apache/shardingsphere/issues/17466#issuecomment-1173777764

   Format sql:
   
   ```sql
   SELECT af.id, af.appid, af.uuid, af.wallet_id, af.currency
   	, af.existing_balance, af.original_balance, af.balance_change, af.create_time, af.micro_time
   	, af.operation_type, af.operation_mode
   FROM api_flow af
   WHERE af.create_time >= ""
   	AND af.create_time < ""
   UNION
   SELECT af.id, af.appid, af.uuid, af.wallet_id, af.currency
   	, af.existing_balance, af.original_balance, af.balance_change, af.create_time, af.micro_time
   	, af.operation_type, af.operation_mode
   FROM (
   	SELECT DISTINCT wallet_id
   	FROM api_flow
   	WHERE create_time >= ""
   		AND create_time < ""
   ) t
   	INNER JOIN api_fund_check_end cf ON t.wallet_id = cf.wallet_id
   	INNER JOIN api_flow af
   	ON cf.wallet_id = af.wallet_id
   		AND cf.micro_time = af.micro_time
   ```


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

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