[PATCH] cve-tools/cves-applied2: fix dump-bugs

Thadeu Lima de Souza Cascardo cascardo at canonical.com
Wed Mar 14 19:37:24 UTC 2018

After some changes to the database, Tid is an ambiguous field name. Use i.Tid
instead, which was the intended behaviour before the commit. Notice Tid was not
used as an alias, as that is not how aliases work on SQL.

Fixes: c56a42395dadfc6e15bf9c97ef33b0a949506882 ("cve-autotriage: switch ROWID to a Tid PRIMARY KEY")
Signed-off-by: Thadeu Lima de Souza Cascardo <cascardo at canonical.com>
 cve-tools/cves-applied2 | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/cve-tools/cves-applied2 b/cve-tools/cves-applied2
index 244d7b99..8691f3ae 100755
--- a/cve-tools/cves-applied2
+++ b/cve-tools/cves-applied2
@@ -552,8 +552,8 @@ class IdStore:
     def dump_bugs(this):
         cur = this.__con.execute("select distinct i.id,series,source,tag from IdDetail i, TagDetail t " + \
-                                 "where Tid=t.Tid and i.Id like 'bug#%' and " + \
-                                 "Version='pending' order by Tid desc, Iorder;")
+                                 "where i.Tid=t.Tid and i.Id like 'bug#%' and " + \
+                                 "Version='pending' order by i.Tid desc, Iorder;")
         for row in cur:
             (bug, series, source, tag) = row

More information about the kernel-team mailing list