Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

weird behavior with fixtures using count(*) #161

Open
majazaloznik opened this issue Mar 23, 2022 · 1 comment
Open

weird behavior with fixtures using count(*) #161

majazaloznik opened this issue Mar 23, 2022 · 1 comment

Comments

@majazaloznik
Copy link
Contributor

Using the vignette example with the nycflights data, if I change the query to a simple select count(*) the saved fixture has a value of 0 instead of the actual output of the query. (It works fine with the original select statement).

I'm not sure though, I might be doing something wrong. But this is what my output looks like:

> start_db_capturing()
> fun_db()
  count
1 133004
> stop_db_capturing()
> with_mock_db(
      fun_db()
 )
  count
1     0
@jonkeane
Copy link
Collaborator

jonkeane commented Sep 10, 2022

Sorry I didn't reply to this earlier. That does indeed seem wrong. Is it possible to re-run that with debugging on? YOu can enable that with something like set_dittodb_debug_level(3) (or really any integer over 2..). That might point to where the bug is.

And of course if you're interested in submitting a PR, I would be happy to review + provide some pointers. If not, I can try and take a stab at it myself.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants