Bug#1057778: qa.debian.org: [udd] some names are not stripped from blanks and quotes
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 <mehdi@debian.org>
" David Paleino" | David Paleino <dapal@debian.org>
" Stéphane Glondu" | Stéphane Glondu <glondu@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <zack@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <zack@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <zack@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <zack@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <zack@debian.org>
"Andreas Tille " | Andreas Tille <tille@debian.org>
" LI Daobing" | LI Daobing <lidaobing@debian.org>
" David Paleino" | David Paleino <dapal@debian.org>
" Stefano Zacchiroli" | Stefano Zacchiroli <zack@debian.org>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <yoush@debian.org>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <yoush@debian.org>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <yoush@debian.org>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <yoush@debian.org>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <yoush@debian.org>
"Colin Tuckley " | Colin Tuckley <colint@debian.org>
"Colin Tuckley " | Colin Tuckley <colint@debian.org>
"Colin Tuckley " | Colin Tuckley <colint@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
---------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------+----------------------------------------------
<dererk@debian.org> | | dererk@debian.org | "vanecgs@gmail.com" <vanecgs@gmail.com> | "vanecgs@gmail.com" | vanecgs@gmail.com
<twerner@debian.org> | | twerner@debian.org | "Varun Hiremath" <varunhiremath@gmail.com> | "Varun Hiremath" | varunhiremath@gmail.com
alexander@belikoff.net (Alexander L. Belikoff) | | alexander@belikoff.net | "Alexander L. Belikoff" <alexander@belikoff.net> | "Alexander L. Belikoff" | alexander@belikoff.net
andi@debian.org (Andreas B. Mundt) | | andi@debian.org | "Andreas B. Mundt" <andi@debian.org> | "Andreas B. Mundt" | andi@debian.org
antoine.romain.dumont@gmail.com (Antoine R. Dumont (@ardumont)) | | antoine.romain.dumont@gmail.com | "Antoine R. Dumont" <antoine.romain.dumont@gmail.com> | "Antoine R. Dumont" | antoine.romain.dumont@gmail.com
antoine.romain.dumont@gmail.com (Antoine R. Dumont) | | antoine.romain.dumont@gmail.com | "Antoine R. Dumont" <antoine.romain.dumont@gmail.com> | "Antoine R. Dumont" | antoine.romain.dumont@gmail.com
arturcz@hell.pl (Artur R. Czechowski) | | arturcz@hell.pl | "Artur R. Czechowski" <arturcz@hell.pl> | "Artur R. Czechowski" | arturcz@hell.pl
...
IMHO the parser should strip spaces and quotes that can be found at beginning and end of strings.
Kind regards
Andreas.
Reply to: