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

    From =?utf-8?B?0L3QsNCx?=@21:1/5 to All on Sat Nov 23 17:50:02 2024
    Hi!

    Here's what select * from wnpp where source is null; gives me rn:
    id | type | source | title
    ---------+------+--------+----------------------------------------------------------------------------------------------------------------
    973700 | RFP | | RFP: nodejs-client (?) -- a client for browser's extensions
    1037180 | RFP | | RFP: fidus Writer -- online collaborative editor for academics
    1072197 | O | | O: bglibs-- This package contains a collection of libraries
    1072199 | O | | O: compton-- compositor for X11, based on xcompmgr
    1072818 | ITP | | ITP: hatch -- Modern, extensible Python project
    1083234 | RFH | | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies
    1087620 | | | Powerful CLI for creating and managing PrivateBin pastes with ease

    804450 | RFP | | RFP: simutrans-pak128
    813711 | RFP | | RFP: rmilter
    899031 | RFP | | RFP: roxterm
    901321 | RFP | | RFP: mpage
    901374 | O | | O: perspective-el
    904235 | O | | O: helm-projectile
    904236 | O | | O: emacs-world-time-mode
    904238 | O | | O: cycle-quotes
    904239 | O | | O: deft
    904242 | O | | O: debpaste-el
    904243 | O | | O: paredit-everywhere
    934023 | RFP | | RFP: resiprocate
    940342 | RFA | | RFA: golang-github-benbjohnson-tmpl
    940346 | RFA | | RFA: golang-github-calmh-du
    940347 | RFA | | RFA: golang-github-calmh-luhn
    940354 | RFA | | RFA: golang-github-cloudfoundry-gosigar
    940356 | RFA | | RFA: golang-github-disposaboy-jsonconfigreader
    940370 | RFA | | RFA: golang-github-influxdata-line-protocol
    940371 | RFA | | RFA: golang-github-influxdata-tdigest
    940372 | RFA | | RFA: golang-github-influxdata-yamux
    940373 | RFA | | RFA: golang-github-influxdata-yarpc
    940376 | RFA | | RFA: golang-github-jsternberg-zap-logfmt
    940379 | RFA | | RFA: golang-github-juju-retry
    940391 | RFA | | RFA: golang-github-mitchellh-multistep
    940394 | RFA | | RFA: golang-github-mkrautz-goar
    940400 | RFA | | RFA: golang-github-nats-io-jwt
    940402 | RFA | | RFA: golang-github-nats-io-nuid
    940403 | RFA | | RFA: golang-github-nu7hatch-gouuid
    940404 | RFA | | RFA: golang-github-oneofone-xxhash
    940405 | RFA | | RFA: golang-github-oschwald-geoip2-golang
    940406 | RFA | | RFA: golang-github-oschwald-maxminddb-golang
    940407 | RFA | | RFA: golang-github-pierrec-xxhash
    940410 | RFA | | RFA: golang-github-pointlander-jetset
    940411 | RFA | | RFA: golang-github-pointlander-peg
    940414 | RFA | | RFA: golang-github-rainycape-unidecode
    940415 | RFA | | RFA: golang-github-retailnext-hllpp
    940416 | RFA | | RFA: golang-github-roaringbitmap-roaring
    940419 | RFA | | RFA: golang-github-segmentio-kafka-go
    940420 | RFA | | RFA: golang-github-smira-commander
    940421 | RFA | | RFA: golang-github-smira-flag
    940422 | RFA | | RFA: golang-github-smira-go-aws-auth
    940423 | RFA | | RFA: golang-github-smira-go-ftp-protocol
    940424 | RFA | | RFA: golang-github-smira-go-xz
    940425 | RFA | | RFA: golang-github-spaolacci-murmur3
    940429 | RFA | | RFA: golang-github-templexxx-cpufeat
    940430 | RFA | | RFA: golang-github-templexxx-reedsolomon
    940432 | RFA | | RFA: golang-github-tent-http-link-go
    940435 | RFA | | RFA: golang-github-tjfoc-gmsm
    940438 | RFA | | RFA: golang-github-vjeantet-grok
    940439 | RFA | | RFA: golang-github-xlab-treeprint
    940447 | RFA | | RFA: golang-gopkg-xmlpath.v2
    966068 | O | | O: emacs-helm-ag
    982484 | RFP | | RFP: mailspring
    984462 | RFH | | RFH: open-build-service
    990802 | O | | O: propellor
    992288 | O | | O: bitlbee-facebook
    992440 | RFP | | RFP: whitesur-gtk-theme
    992441 | RFP | | RFP: whitesur-icon-theme
    994997 | O | | O: tcmu
    1004236 | RFA | | RFA: dlang-libevent
    1004237 | RFA | | RFA: dlang-openssl
    1005918 | ITP | | ITP: libneat
    1005919 | ITP | | ITP: python-adns
    1008625 | RFH | | RFH: qiskit-terra
    1020562 | RFP | | RFP: kde-service-menu-reimage
    1054138 | ITP | | ITP: prometheus-ganeti-exporter
    1054361 | ITP | | ITP: jruby-jzlib
    1061447 | O | | O: django-maintenancemode
    1063033 | O | | O: django-wkhtmltopdf
    1063171 | O | | O: python-sparkpost
    1063348 | O | | O: pdfkit
    1066858 | RFA | | RFA: python-ionoscloud
    1073548 | ITP | | ITP: td-system-tools
    1074295 | RFP | | RFP: labwc-menu-generator
    1074465 | RFP | | RFP: nvidia-fabricmanager
    1078948 | RFP | | RFP: labwc-tweaks-gtk
    1088058 | O | | O: python-webdavclient

    The first few bugs are obviously wrong
    (other services don't understand them either),
    but I can correct them manually.

    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,
    so posting this here in the hopes that someone does.

    Best,
    наб

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

    iQIzBAABCgAdFiEEfWlHToQCjFzAxEFjvP0LAY0mWPEFAmdCBB8ACgkQvP0LAY0m WPFvERAAgs/dKcWlD9Fawr1h0ZF09wVXh9ZQtzHicXHz2dV4w0EJiCCnP3Wk/gPz uSQRrQsHkfNYfsBtdh4a1AMTFTVeVjhzTSV7txnqg4ON7fzzs5WTBuwO0tUZ9A3H UjD1ffH/DT9Ot6YBdOByVEHIIF0erMX/0X+K4xQ05ebB+BpseuD1zvecBa6Bz8pY bmZ5JLWmjNdp6f1nbNXSP0mPpWy9qSCc4AdbVgtstxFksYJW7mXaIDWqIGmWxFrl 9uk6VSgDtMMZChkTt+tLulFC28Rq9s29BpCM/ysKVlmTwgJ9cBmulFeEZZRd2bUh vjJ57ZMlghEa3wTUFfHr/C7zDJjiInE7qI6bMlL9E0AZFrcXCXCj2j5QHtcSkJZr VByut3q35xe8CMNVXqhgobTBvBCfnBWgv25Jmoll85yLULSyoz5XoaG6Cipf+WEY 9vpT4xjxZuyqpx2vfZkD5Jay2eHWqfecANxYIsaGYF16/L6il99KXyDJkPv/ag2M YQHya6dT66HxTVxHQ5NsRyxae+AkJwss89G/Dy8DIZTdaeJcjkBWZv1WVfOss5NF j4PP27AYre/3mkJgNy3VlZ8OggoOS3gJfe5mdvySbRHMvlDuxCHYWJ0iT8UmShWe A6o0rj/ZXKVqAV3cZmy2Ysf4VbIrt4xTBRK7khkeUTIXYP8xeoI=
    =4315
    -----END PGP SIGNATURE-----

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From =?utf-8?B?0L3QsNCx?=@21:1/5 to All on Sat Nov 23 18:20:02 2024
    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-----

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)