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.

Sign up for GitHub

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

Jump to bottom

API and direct SQL query return different results #320

Open
PietrH opened this issue Sep 30, 2024 · 1 comment
Open

API and direct SQL query return different results #320

PietrH opened this issue Sep 30, 2024 · 1 comment
Assignees
@PietrH
Labels
API bug Something isn't working

Comments

@PietrH
Copy link
Member

PietrH commented Sep 30, 2024

list_animal_ids() currently fails a test because the API and a local query return different results:


Failure (test-list_animal_ids.R:11:3): list_animal_ids() returns same list over api and sql ──
`result_api` (`actual`) not identical to `result_sql` (`expected`).

        actual | expected                
[22784] 73697  | 73697    [22784]        
[22785] 73698  | 73698    [22785]        
[22786] 73699  | 73699    [22786]        
               - 73700    [22787]        
               - 73701    [22788]        
               - 73702    [22789]        
               - 73703    [22790]        
               - 73704    [22791]        
               - 73705    [22792]        
               - 73706    [22793]        
    ... ...      ...      and 26 more ...

Possibly due to inbo/etnservice#45

Did the _sql helper code drift from what is currently in etnservice ?
@PietrH PietrH added bug Something isn't working API labels Sep 30, 2024
@PietrH PietrH self-assigned this Sep 30, 2024
@PietrH PietrH mentioned this issue Sep 30, 2024
Closed
8 tasks
@PietrH
Copy link
Member Author

PietrH commented Oct 22, 2024

Related to #330

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@PietrH PietrH

Labels
API bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@PietrH