URL:
<https://savannah.nongnu.org/support/?109708>
Summary: savane db field user.user_name is not unique
Project: Savannah Administration
Submitted by: peterdd
Submitted on: Mon 17 Jun 2019 02:57:41 PM CEST
Category: Savannah website
Priority: 5 - Normal
Severity: 3 - Normal
Status: None
Assigned to: None
Originator Email:
Operating System: None
Open/Closed: Open
Discussion Lock: Any
_______________________________________________________
Details:
On the demo database:
select count(*) c, user_name, group_concat(user_id) from user group by
user_name having c>1
+---+-------------------+-----------------------+
| c | user_name | group_concat(user_id) |
+---+-------------------+-----------------------+
| 4 | adamsmith | 92020,221,47304,72429 |
| 3 | andrewsmith | 106582,94776,101723 |
| 2 | ashleymartinez | 107573,19373 |
| 2 | bridgetprice | 20499,34106 |
| 2 | carlaellis | 75633,106150 |
| 2 | danielgoodman | 85516,87948 |
| 2 | daniellefox | 88268,78669 |
| 2 | daviddavis | 59288,67101 |
| 2 | davidedwards | 86993,93490 |
| 2 | edwardwatson | 30052,19520 |
| 2 | jasonperez | 99065,28884 |
| 2 | jeffreyjordan | 92169,103404 |
| 2 | jessicaadams | 92629,107211 |
| 2 | justinwang | 69330,73640 |
| 2 | kimberlyshaw | 90478,95200 |
| 2 | kristenpeterson | 61577,84354 |
| 2 | michellerodriguez | 58784,76762 |
| 2 | robertjohnson | 63228,93870 |
| 2 | robertwilliams | 32051,87132 |
| 2 | sarahhernandez | 13546,75041 |
| 2 | williamlopez | 76170,40977 |
+---+-------------------+-----------------------+
_______________________________________________________
Reply to this item at:
<https://savannah.nongnu.org/support/?109708>
_______________________________________________
Message sent via Savannah
https://savannah.nongnu.org/
