kimmking edited a comment on issue #6220: URL: https://github.com/apache/shardingsphere/issues/6220#issuecomment-651705906
It's a bug and fix in master branch now. https://github.com/apache/shardingsphere/issues/5857 You can wait for 5.0.0-rc1 or modify it as: > SELECT count(*) FROM table1 WHERE deleted_at IS NULL or > SELECT count(*) FROM table1 as a1 WHERE a1.deleted_at IS 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: us...@infra.apache.org