Patch: UDD wnpp table has source=NULL for bugs without " -- "

On Sat, Nov 23, 2024 at 05:34:42PM +0100, наб wrote:
>    1088058 | O    |        | O: python-webdavclient
> 
> The second group of bugs is valid, and UDD disagrees with other services
> (tracker and DDPO understand these).
> I failed to figure out where UDD parses these,
Found that it's a postgres view.
-- >8 --
CREATE VIEW public.wnpp AS
 SELECT bugs.id,
    "substring"(bugs.title, '^([A-Z]{1,3}): .*'::text) AS type,
    "substring"(bugs.title, '^[A-Z]{1,3}: ([^ ]+)(?: -- .*)'::text) AS source,
    bugs.title
   FROM public.bugs
  WHERE ((bugs.package = 'wnpp'::text) AND (bugs.status <> 'done'::text));
-- >8 --

Turning this into
    "substring"(bugs.title, '^[A-Z]{1,3}: ([^ ]+)(?:(?: -- .*)|$)'::text) AS source,
fixes the issue for all 76 packages:
  @@ -6667 +6667 @@
  - 1004236 | RFA | | RFA: dlang-libevent
  + 1004236 | RFA | dlang-libevent | RFA: dlang-libevent
  @@ -6813 +6813 @@
  - 940373 | RFA | | RFA: golang-github-influxdata-yarpc
  + 940373 | RFA | golang-github-influxdata-yarpc | RFA: golang-github-influxdata-yarpc
  @@ -6827 +6827 @@
  - 940404 | RFA | | RFA: golang-github-oneofone-xxhash
  + 940404 | RFA | golang-github-oneofone-xxhash | RFA: golang-github-oneofone-xxhash
  @@ -6892 +6892 @@
  - 940435 | RFA | | RFA: golang-github-tjfoc-gmsm
  + 940435 | RFA | golang-github-tjfoc-gmsm | RFA: golang-github-tjfoc-gmsm
  @@ -7017 +7017 @@
  - 1054138 | ITP | | ITP: prometheus-ganeti-exporter
  + 1054138 | ITP | prometheus-ganeti-exporter | ITP: prometheus-ganeti-exporter

Patch in
  https://salsa.debian.org/qa/udd/-/merge_requests/58

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEfWlHToQCjFzAxEFjvP0LAY0mWPEFAmdCDG0ACgkQvP0LAY0m
WPG9Xg//fuC3fUx+bqT5+LWlHh9qervxecMMUywD5D3F9GtUahKfU5pc7BZAOgg4
kxFlHrKbbPXbsowunXb1yeXvKSA6eQxDv5mme41zLOR8wauJ/f1PZS1KND9SJYFZ
Ub/xhkudxVz2vhT9wZxImoG4gbGcJ86vgb18KI86Hd60YsHHjUTG9/R7lJOJqkMs
AKyBbXwNXXvdZiNHvuaGdyv5znFijaBqEthrIuD2WWgjdekaOl2dZnS9NaaVFxoE
82IbcBsKt2XWgVL1DLFcfFW/E9eXLcszh1OCcsMC2J+adM9vQjP/s8yoz3VXhwX8
i4czpcWP1QGpqf7d5w3KT2LE4xqVNistju3fo+0APF+8gIUQ3lmwkKf1h/gVCUSJ
VVNFA8Q1ptw+2H0HooJrnTkoNuZrVypwaarbw6zF2cNAxR3BkZQLaeiGH5mDasid
JDFPGamjnm3qu2dbXr2HUzqZr+nUGaSFFB8pJ20QF6KcOGOtmrynR3voV+FFisMM
y4tqlUbNsrgJWTYmxXTFYgbxP6BSoXJmEqpJKGcMuJtojmCjygo5iY4OPBfnTdvt
CkxPV9VlP2uclIO7DIzpoKWMGFnbMaB7U/AY4zRHEmb2AxjPI/+aY623Qp2h9yQZ
VHoy/hA3NPTGJFCCuPHFqhJ8qq1njh2Q3wMcLP5PGJ1wqtqafYs=
=OIj8
-----END PGP SIGNATURE-----