Bugfix for SQL function, inner join is necessary

crs-tools / tracker

CRS Ticket Tracker

Apache License 2.0

18 stars 11 forks source link

Bugfix for SQL function, inner join is necessary #211

Closed a-tze closed 5 years ago

a-tze commented 5 years ago

There was a wrong join in the function definition, which causes wrong behaviour as soon as there are multiple encoding profile versions for the depending and dependee profiles.

Changes the join clause in the installation script and supersedes the database migration script from January 2019.

Fixes #199

a-tze commented 5 years ago

Ping. The corrected JOIN is running flawlessly in production for multiple months now. The other fix is highly appreciated to get into master.