commit cf09e11c982b0366c365088b470a98b36d3d81b1
from: Omar Polo <op@omarpolo.com>
date: Thu Apr 14 12:29:44 2022 UTC

select distinct pkgpath

commit - c00beb4f5897498a7b25154d50dfe0f12934dc3f
commit + cf09e11c982b0366c365088b470a98b36d3d81b1
blob - b52927f9fb48957c983fa5e156d1386074eddefe
blob + 502131eab478759678c41dbe7b9c5d695b059274
--- mkftsidx/ports.c
+++ mkftsidx/ports.c
@@ -30,8 +30,8 @@
 #define SQLPORTS "/usr/local/share/sqlports"
 #endif
 
-#define QNUM "select count(*) from portsq;"
-#define QALL "select pkgstem, comment, descr_contents from portsq;"
+#define QNUM "select count(distinct pkgstem) from portsq;"
+#define QALL "select distinct pkgstem, comment, descr_contents from portsq;"
 
 static int
 countports(sqlite3 *db)