Jake Snipes

Results 6 comments of Jake Snipes

Incorrect result from aggregating on table joined in both subquery and CTE

Update. The subquery works in `dolt sql-client`, but returns wrong result in Pycharm. Could be driver related? ``` DBMS: MySQL (ver. 5.7.9-Vitess) Case sensitivity: plain=exact, delimited=exact Driver: MySQL Connector/J (ver....

Incorrect result from aggregating on table joined in both subquery and CTE

Yes, for sure. I will send the output that I am getting from within pycharm tomorrow (new laptop). Dolt’s cli client returned the correct results, so it might be an...

Incorrect result from aggregating on table joined in both subquery and CTE

Sharing first 10 records from CTE example (will share the rest): | taxonomy\_code | provider\_count | | :--- | :--- | | UNKNOWN | 18 | | 207R00000X | 17...

Incorrect result from aggregating on table joined in both subquery and CTE

Explain CTE (PyCharm): | plan | | :--- | | Limit\(10\) | | └─ Project | | ├─ columns: \[p.taxonomy\_code, COUNT\(\*\) as provider\_count\] | | └─ Sort\(COUNT\(\*\) DESC\) | |...

Incorrect result from aggregating on table joined in both subquery and CTE

Also noticed that the CTE returns different result each time I run it. Here's the log I get with mysql-connector-java: ``` $ dolt sql-server -u jrs -p password --config dolt.cfg...

Incorrect result from aggregating on table joined in both subquery and CTE

Thanks for the update! Unfortunately, swapping to `provider_count` has the same result (random sort). The query plan does change though: | plan | | :--- | | Limit\(10\) | |...