We have a user that's trying to download a csv of a view on a branch that's not main and is getting a table not found error. We thought it was related to views not working with as of (this issue), but using the select * from `view-test/newbranch`.test2 syntax doesn't work either even though it works in dolt. It seems like something with how we set up the dolt database using in dolthubapi here. This is the PR where this was added
I added some unit tests here. I can get the branch test to pass by passing in the refName instead of an empty string to GetStreamingSqlReadQueryResults here but that doesn't work for commit refs
This is also reproducible on any repo with a view on a non-main branch using the DoltHub SQL console (example here) and comparing to Dolt
taylor@MacBook-Pro-6 test-repo-mayo % dolt sql
# Welcome to the DoltSQL shell.
# Statements must be terminated with ';'.
# "exit" or "quit" (or Ctrl-D) to exit. "\help" for help.
test-repo-mayo/main> SELECT * FROM `test-repo-mayo/another-branch`.`only_on_branch`;
+----+------------+
| id | some_pk |
+----+------------+
| 1 | 1705931475 |
+----+------------+
1 row in set (0.01 sec)
We have a user that's trying to download a csv of a view on a branch that's not
mainand is getting atable not founderror. We thought it was related to views not working withas of(this issue), but using theselect * from `view-test/newbranch`.test2syntax doesn't work either even though it works in dolt. It seems like something with how we set up the dolt database using in dolthubapi here. This is the PR where this was addedI added some unit tests here. I can get the branch test to pass by passing in the
refNameinstead of an empty string toGetStreamingSqlReadQueryResultshere but that doesn't work for commit refsThis is also reproducible on any repo with a view on a non-main branch using the DoltHub SQL console (example here) and comparing to Dolt