savannah-hackers
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[savannah-help-public] [sr #109708] savane db field user.user_name is no


From: Peter Liscovius
Subject: [savannah-help-public] [sr #109708] savane db field user.user_name is not unique
Date: Mon, 17 Jun 2019 08:57:44 -0400 (EDT)
User-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:67.0) Gecko/20100101 Firefox/67.0

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/




reply via email to

[Prev in Thread] Current Thread [Next in Thread]