Package: qa.debian.org
Severity: normal
Hi,
in some tables names are not stripped from spaces. Example:
udd=> select '"' || u.name || '"' as name_with_spaces, uploader from uploaders
u where name like '% ' or name like ' %' ;
name_with_spaces | uploader
--------------------------+-------------------------------------------
" Mehdi Dogguy" | Mehdi Dogguy <me...@debian.org>
" David Paleino" | David Paleino <da...@debian.org>
" Stéphane Glondu" | Stéphane Glondu <glo...@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <z...@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <z...@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <z...@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <z...@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <z...@debian.org>
"Andreas Tille " | Andreas Tille <ti...@debian.org>
" LI Daobing" | LI Daobing <lidaob...@debian.org>
" David Paleino" | David Paleino <da...@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <z...@debian.org>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <yo...@debian.org>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <yo...@debian.org>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <yo...@debian.org>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <yo...@debian.org>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <yo...@debian.org>
"Colin Tuckley " | Colin Tuckley <col...@debian.org>
"Colin Tuckley " | Colin Tuckley <col...@debian.org>
"Colin Tuckley " | Colin Tuckley <col...@debian.org>
(20 rows)
in other tables names are containing quotes that should be stripped as well:
select distinct done, done_name, done_email, owner, owner_name, owner_email
from archived_bugs where done_name like '%"%' or owner_name like '%"%' order by
done_name;
done
| done_name
| done_email
| owner
| owner_name
| owner_email
---------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------+----------------------------------------------
<der...@debian.org>
|
| der...@debian.org
| "vane...@gmail.com" <vane...@gmail.com>
| "vane...@gmail.com"
| vane...@gmail.com
<twer...@debian.org>
|
| twer...@debian.org
| "Varun Hiremath" <varunhirem...@gmail.com>
| "Varun Hiremath"
| varunhirem...@gmail.com
alexan...@belikoff.net (Alexander L. Belikoff)
|
| alexan...@belikoff.net
| "Alexander L. Belikoff" <alexan...@belikoff.net>
| "Alexander L. Belikoff"
| alexan...@belikoff.net
a...@debian.org (Andreas B. Mundt)
|
| a...@debian.org
| "Andreas B. Mundt" <a...@debian.org>
| "Andreas B. Mundt"
| a...@debian.org
antoine.romain.dum...@gmail.com (Antoine R. Dumont (@ardumont))
|
| antoine.romain.dum...@gmail.com
| "Antoine R. Dumont" <antoine.romain.dum...@gmail.com>
| "Antoine R. Dumont"
| antoine.romain.dum...@gmail.com
antoine.romain.dum...@gmail.com (Antoine R. Dumont)
|
| antoine.romain.dum...@gmail.com
| "Antoine R. Dumont" <antoine.romain.dum...@gmail.com>
| "Antoine R. Dumont"
| antoine.romain.dum...@gmail.com
artu...@hell.pl (Artur R. Czechowski)
|
| artu...@hell.pl
| "Artur R. Czechowski" <artu...@hell.pl>
| "Artur R. Czechowski"
| artu...@hell.pl
...
IMHO the parser should strip spaces and quotes that can be found at beginning
and end of strings.
Kind regards
Andreas.
