shishank2311 commented on issue #27459: URL: https://github.com/apache/shardingsphere/issues/27459#issuecomment-1650100200
Version: - 8.0.33-ShardingSphere-Proxy 5.3.2 Project Used: - ShardingSphere_Proxy Expected behaviour: - count(distinct column_name) should always return a 'BIGINT' value. Actual behaviour: - some times returns BIGINT sometimes VARCHAR(63). Self-Analysis: - return value's datatype is aslways same as the column's data type when distinct is used, when 'distinct' not used count always returns BIGINT. Example Query: - select count(distinct colum_name) from table_name. Note:- Make sure to try on columns with different types to check properly and also check with count() without distinct to confirm the behavior. 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]
