Tim Sehn
Tim Sehn
It's something in the `test_` repos ``` $ mv test-* ../dolt-again $ dolt sql-server Starting server with Config HP="localhost:3306"|T="28800000"|R="false"|L="info"|S="/tmp/mysql.sock" invalid ref format: refs/heads/ $ ls fiction paylesshealth test_branch_control test_remotes_table test_update_cte...
Found it: ``` $ cd testdb $ ls $ ls -al total 0 drwxr-xr-x 3 timsehn staff 96 Oct 28 12:21 . drwxr-xr-x 15 timsehn staff 480 Dec 13 09:02...
Looks like this is a repo where I deleted the main branch: ``` $ dolt branch to_keep ```
We should at least tell you the database where the error is happening.
ORDER BY expressions containing aggregation functions are not handled appropriately by the analyzer.
These work now :-) ``` test_subra/main*> create table xy (x int primary key, y int); test_subra/main*> select x, sum(y) from xy group by x order by avg(y); Empty set (0.00...
I have also seen this. @alecstein next time you see it, tar up the directory and put it on Google drive.
https://drive.google.com/file/d/10VWzRLFbxYvpwm1qbUXDhk85p-teRp3u/view?usp=sharing Here's a link with a repo that reproduces one of these. Can we please debug?
@JCOR11599 is working on this right now.
Here's an easier repro. ``` dolt init Successfully initialized dolt data repository. $ dolt sql -q "create table t1 (id int, c1 int)" $ dolt sql -q "create table t2...
Thanks. We will investigate and get back to you. As I said in the other ticket, materializing this as a column with a trigger is the workaround.