Re: Bug#1057778: qa.debian.org: [udd] some names are not stripped from blanks and quotes (Was: UDD contains names where spaces are not stripped)

2023-12-08 Thread Andreas Tille
Control: usertag -1 udd The problem was discussed on Debian-QA list. The discussion starts here: https://lists.debian.org/debian-qa/2023/12/msg7.html I opened this bug report to keep a record of the discussion in BTS. There is one statement by Lucas Nussbaum[1] defending the current si

Re: UDD contains names where spaces are not stripped

2023-12-07 Thread Lucas Nussbaum
On 07/12/23 at 20:24 +0100, Andreas Tille wrote: > Am Thu, Dec 07, 2023 at 07:59:38PM +0100 schrieb Lucas Nussbaum: > > On 07/12/23 at 09:58 +0100, Andreas Tille wrote: > > > Hi, > > > > > > by chance I realised that the uploaders table contains some names where > > > names > > > are not stripped

Re: UDD contains names where spaces are not stripped

2023-12-07 Thread Andreas Tille
Am Thu, Dec 07, 2023 at 07:59:38PM +0100 schrieb Lucas Nussbaum: > On 07/12/23 at 09:58 +0100, Andreas Tille wrote: > > Hi, > > > > by chance I realised that the uploaders table contains some names where > > names > > are not stripped: > > > > udd=> select '"' || u.name || '"' as name_with_space

Re: UDD contains names where spaces are not stripped

2023-12-07 Thread Lucas Nussbaum
On 07/12/23 at 09:58 +0100, Andreas Tille wrote: > Hi, > > by chance I realised that the uploaders table contains some names where names > are not stripped: > > udd=> select '"' || u.name || '"' as name_with_spaces, uploader from > uploaders u where name like '% ' or name like ' %' ; > name

UDD contains names where spaces are not stripped

2023-12-07 Thread Andreas Tille
Hi, by chance I realised that the uploaders table contains some names where names are not stripped: udd=> select '"' || u.name || '"' as name_with_spaces, uploader from uploaders u where name like '% ' or name like ' %' ; name_with_spaces | uploader ---