mainSavannah Administration - Support: sr #109708, savane db field user.user_name is...

 
 

sr #109708: savane db field user.user_name is not unique

Submitter:  Peter Liscovius <peterdd>
Submitted:  Mon 17 Jun 2019 12:57:41 PM UTC
   
 
Category:  Savannah website Priority:  5 - Normal
Severity:  3 - Normal Status:  Wont Do
Privacy:  Public Assigned to:  ineiev
Operating System:  None Open/Closed:  Closed
* Mandatory Fields

Add a New Comment Rich Markup
   

Thu 20 Jun 2019 05:59:35 AM UTC, comment #1: 

This may be ignored; Savannah database has no duplicate user_names.

Ineiev <ineiev>
Site Administrator
Mon 17 Jun 2019 12:57:41 PM UTC, original submission:  

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           |
+---+-------------------+-----------------------+


Peter Liscovius <peterdd>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by ineiev (Posted a comment)
  • -email is unavailable- added by peterdd (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 3 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2019-06-20 ineiev StatusNone Wont Do
        Assigned toNone ineiev
        Open/ClosedOpen Closed

    Back to the top

    Powered by Savane 3.13-02a9.
    Corresponding source code