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 <[email protected]>
" David Paleino" | David Paleino <[email protected]>
" Stéphane Glondu" | Stéphane Glondu <[email protected]>
" Stefano Zacchiroli" | Stefano Zacchiroli <[email protected]>
" Stefano Zacchiroli" | Stefano Zacchiroli <[email protected]>
" Stefano Zacchiroli" | Stefano Zacchiroli <[email protected]>
" Stefano Zacchiroli" | Stefano Zacchiroli <[email protected]>
" Stefano Zacchiroli" | Stefano Zacchiroli <[email protected]>
"Andreas Tille " | Andreas Tille <[email protected]>
" LI Daobing" | LI Daobing <[email protected]>
" David Paleino" | David Paleino <[email protected]>
" Stefano Zacchiroli" | Stefano Zacchiroli <[email protected]>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <[email protected]>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <[email protected]>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <[email protected]>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <[email protected]>
" Nikita V. Youshchenko" | Nikita V. Youshchenko <[email protected]>
"Colin Tuckley " | Colin Tuckley <[email protected]>
"Colin Tuckley " | Colin Tuckley <[email protected]>
"Colin Tuckley " | Colin Tuckley <[email protected]>
(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
---------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------+----------------------------------------------
<[email protected]>
|
| [email protected]
| "[email protected]" <[email protected]>
| "[email protected]"
| [email protected]
<[email protected]>
|
| [email protected]
| "Varun Hiremath" <[email protected]>
| "Varun Hiremath"
| [email protected]
[email protected] (Alexander L. Belikoff)
|
| [email protected]
| "Alexander L. Belikoff" <[email protected]>
| "Alexander L. Belikoff"
| [email protected]
[email protected] (Andreas B. Mundt)
|
| [email protected]
| "Andreas B. Mundt" <[email protected]>
| "Andreas B. Mundt"
| [email protected]
[email protected] (Antoine R. Dumont (@ardumont))
|
| [email protected]
| "Antoine R. Dumont" <[email protected]>
| "Antoine R. Dumont"
| [email protected]
[email protected] (Antoine R. Dumont)
|
| [email protected]
| "Antoine R. Dumont" <[email protected]>
| "Antoine R. Dumont"
| [email protected]
[email protected] (Artur R. Czechowski)
|
| [email protected]
| "Artur R. Czechowski" <[email protected]>
| "Artur R. Czechowski"
| [email protected]
...
IMHO the parser should strip spaces and quotes that can be found at beginning
and end of strings.
Kind regards
Andreas.
