- Count is sorted as string in result set.
Steps to reproduce:
1. Run a query: select column_a, count(*) as N from sometable group by 1;
2. Click on N to sort the result set, you'll see the number is treated as string in sorting, hence number 8 would be sorted before 70 when sorted desc.
I'm using Snowflake driver 3.6.28, Aginity Pro 0.12.198 in Win10
Please sign in to leave a comment.