Skip to content

fix: heuristic queries left outer join instead just left

Jan Pavlíček requested to merge xpavlic/heuristic_fix into main

Description

The problem is if some data is missing, it is not included in a foreign database table, and in that case, select returns nothing; this fixes it.

How to test

update /etc/hosts: 147.251.18.44 id.muni.cz https://id.muni.cz/proxygui/heuristics and your perunUserID + some different logins (to have things in heuristic)

Author's checklist

  • I have followed the contribution guidelines
  • This MR has been tested or does not change functionality
  • I have added relevant merge request dependencies (if this MR has any)
  • I have added the correct labels
  • I have assigned reviewers (if any are relevant)
  • I have edited the documentation (if the changes require it) or I have noted the need for the change if I do not have access to the documentation
  • I have marked all introduced BREAKING CHANGES or necessary DEPLOYMENT NOTES in the commit message(s)

Reviewer's checklist

  • This MR has been tested or does not change functionality
  • This MR has correct commit message format

Other information

Related issues

Merge request reports