From e78ac0ab15da5fb8538da0992feba8814b76d0b2 Mon Sep 17 00:00:00 2001
From: Don Armstrong <don@donarmstrong.com>
Date: Mon, 7 Aug 2017 14:03:33 -0700
Subject: [PATCH] fix the bin->bin_ver join in updatesqlcache

---
 bin/debbugs-updatesqlcache | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

diff --git a/bin/debbugs-updatesqlcache b/bin/debbugs-updatesqlcache
index 4a8be5e..0c00c59 100755
--- a/bin/debbugs-updatesqlcache
+++ b/bin/debbugs-updatesqlcache
@@ -227,10 +227,11 @@ sub update_cache {
 	    search_rs({'me.modified' => {'>=',$last_query_time},
 		      },
 		     {columns => [qw(bug_binpackage.id)],
-		      join => {bin_ver =>
+		      join => {bin =>
+			      {bin_vers =>
 			      {bin_pkg =>
 			       'bug_binpackage'
-			      }},
+			      }}},
 		      result_class => 'DBIx::Class::ResultClass::HashRefInflator',
 		     },
 		     )->all();
@@ -241,7 +242,7 @@ sub update_cache {
 	    search_rs({'me.modified' => {'>=',$last_query_time},
 		      },
 		     {columns => [qw(bug_srcpackage.id)],
-		      join => {src_ver =>
+		      join => {source =>
 			      {src_pkg =>
 			       'bug_srcpackage'
 			      }},
-- 
2.39.2