Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@charsbar
Created March 14, 2013 02:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save charsbar/a5c2452128b5fd6e5b69 to your computer and use it in GitHub Desktop.
Save charsbar/a5c2452128b5fd6e5b69 to your computer and use it in GitHub Desktop.
duplicated cpan distributions uploaded by different authors
sqlite> select distv, group_concat(author), group_concat(path) from uploads where type="cpan" group by distv having count(distinct(author)) > 1 order by distv;
distv = Acme-emcA-0.10
group_concat(author) = AUDREYT,AUTRIJUS
group_concat(path) = A/AU/AUDREYT/Acme-emcA-0.10.tar.gz,A/AU/AUTRIJUS/Acme-emcA-0.10.tar.gz
distv = Algorithm-KMeans-1.20
group_concat(author) = DINGZEZHU,AVIKAK
group_concat(path) = D/DI/DINGZEZHU/Algorithm-KMeans-1.20.tar.gz,A/AV/AVIKAK/Algorithm-KMeans-1.20.tar.gz
distv = Algorithm-Munkres-0.07
group_concat(author) = ANAGHAKK,TPEDERSE
group_concat(path) = A/AN/ANAGHAKK/Algorithm-Munkres-0.07.tar.gz,T/TP/TPEDERSE/Algorithm-Munkres-0.07.tar.gz
distv = Apache-ASP-2.62
group_concat(author) = CHAMAS,ZETA
group_concat(path) = C/CH/CHAMAS/Apache-ASP-2.62.tar.gz,Z/ZE/ZETA/Apache-ASP-2.62.tar.gz
distv = Apache-DBI-1.09
group_concat(author) = ABH,PHRED
group_concat(path) = A/AB/ABH/Apache-DBI-1.09.tar.gz,P/PH/PHRED/Apache-DBI-1.09.tar.gz
distv = B-Generate-1.12_03
group_concat(author) = JJORE,JCROMIE
group_concat(path) = J/JJ/JJORE/B-Generate-1.12_03.tar.gz,J/JC/JCROMIE/B-Generate-1.12_03.tar.gz
distv = BTRIEVE-Native-0.03
group_concat(author) = ILYAZ,SGOELDNER
group_concat(path) = I/IL/ILYAZ/os2/582+/BTRIEVE-Native-0.03.tar.gz,S/SG/SGOELDNER/BTRIEVE-Native-0.03.tar.gz
distv = Bit-Vector-7.2
group_concat(author) = ANDK,STBEY
group_concat(path) = A/AN/ANDK/Bit-Vector-7.2.tar.gz,S/ST/STBEY/Bit-Vector-7.2.tar.gz
distv = Bundle-MusicBrainz-Server-0.01
group_concat(author) = MAFR,JAYJ
group_concat(path) = M/MA/MAFR/Bundle-MusicBrainz-Server-0.01.tar.gz,J/JA/JAYJ/Bundle-MusicBrainz-Server-0.01.tar.gz
distv = Business-OnlinePayment-PaymenTech-2.03
group_concat(author) = IVAN,MWELLS
group_concat(path) = I/IV/IVAN/Business-OnlinePayment-PaymenTech-2.03.tar.gz,M/MW/MWELLS/Business-OnlinePayment-PaymenTech-2.03.tar.gz
distv = CGI-PathInfo-1.03
group_concat(author) = LEOCHARRE,SNOWHARE
group_concat(path) = L/LE/LEOCHARRE/CGI-PathInfo-1.03.tar.gz,S/SN/SNOWHARE/CGI-PathInfo-1.03.tar.gz
distv = Cache-Memcached-libmemcached-0.02011
group_concat(author) = DMAKI,TIMB
group_concat(path) = D/DM/DMAKI/Cache-Memcached-libmemcached-0.02011.tar.gz,T/TI/TIMB/Cache-Memcached-libmemcached-0.02011.tar.gz
distv = Catalyst-Action-REST-0.91
group_concat(author) = FLORA,BOBTFISH
group_concat(path) = F/FL/FLORA/Catalyst-Action-REST-0.91.tar.gz,B/BO/BOBTFISH/Catalyst-Action-REST-0.91.tar.gz
distv = Catalyst-Authentication-Store-DBIx-Class-0.1503
group_concat(author) = BOBTFISH,MSTROUT
group_concat(path) = B/BO/BOBTFISH/Catalyst-Authentication-Store-DBIx-Class-0.1503.tar.gz,M/MS/MSTROUT/Catalyst-Authentication-Store-DBIx-Class-0.1503.tar.gz
distv = Catalyst-Plugin-Authentication-Store-Htpasswd-0.02
group_concat(author) = DKAMHOLZ,NUFFIN
group_concat(path) = D/DK/DKAMHOLZ/Catalyst-Plugin-Authentication-Store-Htpasswd-0.02.tar.gz,N/NU/NUFFIN/Catalyst-Plugin-Authentication-Store-Htpasswd-0.02.tar.gz
distv = Catalyst-Plugin-Static-Simple-0.14
group_concat(author) = AGRUNDMA,MRAMBERG
group_concat(path) = A/AG/AGRUNDMA/Catalyst-Plugin-Static-Simple-0.14.tar.gz,M/MR/MRAMBERG/Catalyst-Plugin-Static-Simple-0.14.tar.gz
distv = Catalyst-View-TT-0.35
group_concat(author) = BOBTFISH,LSAUNDERS
group_concat(path) = B/BO/BOBTFISH/Catalyst-View-TT-0.35.tar.gz,L/LS/LSAUNDERS/Catalyst-View-TT-0.35.tar.gz
distv = CatalystX-Component-Traits-0.14
group_concat(author) = BOBTFISH,RKITOVER
group_concat(path) = B/BO/BOBTFISH/CatalystX-Component-Traits-0.14.tar.gz,R/RK/RKITOVER/CatalystX-Component-Traits-0.14.tar.gz
distv = Class-DBI-Relationship-IsA-0.05
group_concat(author) = TEEJAY,RHUNDT
group_concat(path) = T/TE/TEEJAY/Class-DBI-Relationship-IsA-0.05.tar.gz,R/RH/RHUNDT/Class-DBI-Relationship-IsA-0.05.tar.gz
distv = Class-Load-0.19
group_concat(author) = DROLSKY,DOY
group_concat(path) = D/DR/DROLSKY/Class-Load-0.19.tar.gz,D/DO/DOY/Class-Load-0.19.tar.gz
distv = Convert-Recode-1.04
group_concat(author) = GAAS,EDAVIS
group_concat(path) = G/GA/GAAS/Convert-Recode-1.04.tar.gz,E/ED/EDAVIS/Convert-Recode-1.04.tar.gz
distv = Crypt-Enigma-1.4
group_concat(author) = FRIFFIN,ALIZTA
group_concat(path) = F/FR/FRIFFIN/Crypt-Enigma-1.4.tar.gz,A/AL/ALIZTA/Crypt-Enigma-1.4.tar.gz
distv = Crypt-Vigenere-0.07
group_concat(author) = FRIFFIN,ALIZTA
group_concat(path) = F/FR/FRIFFIN/Crypt-Vigenere-0.07.tar.gz,A/AL/ALIZTA/Crypt-Vigenere-0.07.tar.gz
distv = CtCmd-1.09
group_concat(author) = ALEVENSO,RATL
group_concat(path) = A/AL/ALEVENSO/CtCmd-1.09.tar.gz,R/RA/RATL/CtCmd-1.09.tar.gz
distv = Curses-UI-0.72
group_concat(author) = MARCUS,MMAKAAY
group_concat(path) = M/MA/MARCUS/Curses-UI-0.72.tar.gz,M/MM/MMAKAAY/Curses-UI-0.72.tar.gz
distv = Curses-UI-0.73
group_concat(author) = MARCUS,MMAKAAY
group_concat(path) = M/MA/MARCUS/Curses-UI-0.73.tar.gz,M/MM/MMAKAAY/Curses-UI-0.73.tar.gz
distv = DBD-DB2-0.78-5.8.4
group_concat(author) = HOYMICH,IBMTORDB2
group_concat(path) = H/HO/HOYMICH/db2/perl58/DBD-DB2-0.78-5.8.4.tar.gz,I/IB/IBMTORDB2/Binaries/perl58/DBD-DB2-0.78-5.8.4.tar.gz
distv = Data-Stream-Bulk-0.08
group_concat(author) = FLORA,DOY
group_concat(path) = F/FL/FLORA/Data-Stream-Bulk-0.08.tar.gz,D/DO/DOY/Data-Stream-Bulk-0.08.tar.gz
distv = Data-Verifier-0.51
group_concat(author) = GPHAT,JSHIRLEY
group_concat(path) = G/GP/GPHAT/Data-Verifier-0.51.tar.gz,J/JS/JSHIRLEY/Data-Verifier-0.51.tar.gz
distv = Dendral-HTTP-Response-0.1.0
group_concat(author) = JUNKER,STELLAR
group_concat(path) = J/JU/JUNKER/Dendral-HTTP-Response-0.1.0.tar.gz,S/ST/STELLAR/Dendral-HTTP-Response-0.1.0.tar.gz
distv = Devel-PartialDump-0.12
group_concat(author) = FLORA,NUFFIN
group_concat(path) = F/FL/FLORA/Devel-PartialDump-0.12.tar.gz,N/NU/NUFFIN/Devel-PartialDump-0.12.tar.gz
distv = Getopt-Chain-0.017
group_concat(author) = RKRIMEN,ROKR
group_concat(path) = R/RK/RKRIMEN/Getopt-Chain-0.017.tar.gz,R/RO/ROKR/Getopt-Chain-0.017.tar.gz
distv = HTML-Fraction-0.40
group_concat(author) = LBROCARD,MARKF
group_concat(path) = L/LB/LBROCARD/HTML-Fraction-0.40.tar.gz,M/MA/MARKF/HTML-Fraction-0.40.tar.gz
distv = HTML-Summary-0.017
group_concat(author) = AWRIGLEY,TGROSE
group_concat(path) = A/AW/AWRIGLEY/HTML-Summary-0.017.tar.gz,T/TG/TGROSE/HTML-Summary-0.017.tar.gz
distv = HTTP-Server-Simple-0.45_02
group_concat(author) = JESSE,JASONMAY
group_concat(path) = J/JE/JESSE/HTTP-Server-Simple-0.45_02.tar.gz,J/JA/JASONMAY/HTTP-Server-Simple-0.45_02.tar.gz
distv = KiokuDB-0.48
group_concat(author) = FLORA,NUFFIN
group_concat(path) = F/FL/FLORA/KiokuDB-0.48.tar.gz,N/NU/NUFFIN/KiokuDB-0.48.tar.gz
distv = KiokuDB-Backend-DBI-1.16
group_concat(author) = DRUOSO,NUFFIN
group_concat(path) = D/DR/DRUOSO/KiokuDB-Backend-DBI-1.16.tar.gz,N/NU/NUFFIN/KiokuDB-Backend-DBI-1.16.tar.gz
distv = Lingua-AF-Numbers-1.1
group_concat(author) = FRIFFIN,ALIZTA
group_concat(path) = F/FR/FRIFFIN/Lingua-AF-Numbers-1.1.tar.gz,A/AL/ALIZTA/Lingua-AF-Numbers-1.1.tar.gz
distv = Lingua-JP-Kanjidic-1.1
group_concat(author) = PETDANCE,SIMON
group_concat(path) = P/PE/PETDANCE/Lingua-JP-Kanjidic-1.1.tar.gz,S/SI/SIMON/Lingua-JP-Kanjidic-1.1.tar.gz
distv = Lingua-NL-Numbers-1.2
group_concat(author) = FRIFFIN,ALIZTA
group_concat(path) = F/FR/FRIFFIN/Lingua-NL-Numbers-1.2.tar.gz,A/AL/ALIZTA/Lingua-NL-Numbers-1.2.tar.gz
distv = Log-Dispatch-Message-Passing-0.006
group_concat(author) = GHENRY,BOBTFISH
group_concat(path) = G/GH/GHENRY/Log-Dispatch-Message-Passing-0.006.tar.gz,B/BO/BOBTFISH/Log-Dispatch-Message-Passing-0.006.tar.gz
distv = MDV-Packdrakeng-1.13
group_concat(author) = NANARDON,TVIGNAUD
group_concat(path) = N/NA/NANARDON/MDV-Packdrakeng-1.13.tar.gz,T/TV/TVIGNAUD/MDV-Packdrakeng-1.13.tar.gz
distv = Mail-SRS-0.15
group_concat(author) = FREESIDE,SHEVEK
group_concat(path) = F/FR/FREESIDE/Mail-SRS-0.15.tar.gz,S/SH/SHEVEK/Mail-SRS-0.15.tar.gz
distv = Mail-SpamAssassin-3.3.2
group_concat(author) = KMCGRAIL,PARKER
group_concat(path) = K/KM/KMCGRAIL/Mail-SpamAssassin-3.3.2.tar.gz,P/PA/PARKER/Mail-SpamAssassin-3.3.2.tar.gz
distv = Mail-Thread-2.41
group_concat(author) = RCLAMP,SIMON
group_concat(path) = R/RC/RCLAMP/Mail-Thread-2.41.tar.gz,S/SI/SIMON/Mail-Thread-2.41.tar.gz
distv = Math-Cephes-0.47
group_concat(author) = ADOPTME,RKOBES
group_concat(path) = A/AD/ADOPTME/Math-Cephes-0.47.tar.gz,R/RK/RKOBES/Math-Cephes-0.47.tar.gz
distv = Message-Stack-0.20
group_concat(author) = ANELSON,GPHAT
group_concat(path) = A/AN/ANELSON/Message-Stack-0.20.tar.gz,G/GP/GPHAT/Message-Stack-0.20.tar.gz
distv = MooseX-Types-DateTime-0.04
group_concat(author) = FLORA,NUFFIN
group_concat(path) = F/FL/FLORA/MooseX-Types-DateTime-0.04.tar.gz,N/NU/NUFFIN/MooseX-Types-DateTime-0.04.tar.gz
distv = MouseX-Getopt-0.31
group_concat(author) = GFUJI,TOKUHIROM
group_concat(path) = G/GF/GFUJI/MouseX-Getopt-0.31.tar.gz,T/TO/TOKUHIROM/MouseX-Getopt-0.31.tar.gz
distv = Net-DNS-0.68
group_concat(author) = NLNETLABS,OLAF
group_concat(path) = N/NL/NLNETLABS/Net-DNS-0.68.tar.gz,O/OL/OLAF/Net-DNS-0.68.tar.gz
distv = Net-SSH2-0.07
group_concat(author) = AWA,DBROBINS
group_concat(path) = A/AW/AWA/AWA/Net-SSH2-0.07.tar.gz,D/DB/DBROBINS/Net-SSH2-0.07.tar.gz
distv = Net-UCP-0.41
group_concat(author) = ITGURU,NEMUX
group_concat(path) = I/IT/ITGURU/Net-UCP-0.41.tgz,N/NE/NEMUX/Net-UCP-0.41.tgz
distv = NetPacket-0.04
group_concat(author) = CGANESAN,ATRAK
group_concat(path) = C/CG/CGANESAN/NetPacket-0.04.tar.gz,A/AT/ATRAK/NetPacket-0.04.tar.gz
distv = POE-Component-FastCGI-0.18
group_concat(author) = GETTY,BINGOS
group_concat(path) = G/GE/GETTY/POE-Component-FastCGI-0.18.tar.gz,B/BI/BINGOS/POE-Component-FastCGI-0.18.tar.gz
distv = POE-Component-Supervisor-0.07
group_concat(author) = NUFFIN,MSTROUT
group_concat(path) = N/NU/NUFFIN/POE-Component-Supervisor-0.07.tar.gz,M/MS/MSTROUT/POE-Component-Supervisor-0.07.tar.gz
distv = Parse-Method-Signatures-1.003012
group_concat(author) = FLORA,ASH
group_concat(path) = F/FL/FLORA/Parse-Method-Signatures-1.003012.tar.gz,A/AS/ASH/Parse-Method-Signatures-1.003012.tar.gz
distv = Parse-SVNDiff-0.03
group_concat(author) = AUTRIJUS,SAMV
group_concat(path) = A/AU/AUTRIJUS/Parse-SVNDiff-0.03.tar.gz,S/SA/SAMV/Parse-SVNDiff-0.03.tar.gz
distv = Plucene-1.19
group_concat(author) = STRYTOAST,SIMON
group_concat(path) = S/ST/STRYTOAST/Plucene-1.19.tar.gz,S/SI/SIMON/Plucene-1.19.tar.gz
distv = RT-Authen-ExternalAuth-0.11
group_concat(author) = FALCONE,ALEXMV
group_concat(path) = F/FA/FALCONE/RT-Authen-ExternalAuth-0.11.tar.gz,A/AL/ALEXMV/RT-Authen-ExternalAuth-0.11.tar.gz
distv = RT-Extension-MergeUsers-0.02
group_concat(author) = KEVINR,JESSE
group_concat(path) = K/KE/KEVINR/RT-Extension-MergeUsers-0.02.tar.gz,J/JE/JESSE/RT-Extension-MergeUsers-0.02.tar.gz
distv = RT-Extension-MobileUI-1.02
group_concat(author) = FALCONE,ALEXMV
group_concat(path) = F/FA/FALCONE/RT-Extension-MobileUI-1.02.tar.gz,A/AL/ALEXMV/RT-Extension-MobileUI-1.02.tar.gz
distv = RTx-Calendar-0.14
group_concat(author) = FALCONE,TSIBLEY
group_concat(path) = F/FA/FALCONE/RTx-Calendar-0.14.tar.gz,T/TS/TSIBLEY/RTx-Calendar-0.14.tar.gz
distv = SGML-Parser-OpenSP-0.99
group_concat(author) = BJOERN,MAXIS
group_concat(path) = B/BJ/BJOERN/SGML-Parser-OpenSP-0.99.tar.gz,M/MA/MAXIS/SGML-Parser-OpenSP-0.99.tar.gz
distv = SVG-2.50
group_concat(author) = FANGLY,RONAN
group_concat(path) = F/FA/FANGLY/SVG-2.50.tar.gz,R/RO/RONAN/SVG-2.50.tar.gz
distv = Scalar-Defer-0.13
group_concat(author) = AUDREYT,NUFFIN
group_concat(path) = A/AU/AUDREYT/Scalar-Defer-0.13.tar.gz,N/NU/NUFFIN/Scalar-Defer-0.13.tar.gz
distv = Scalar-Defer-0.22
group_concat(author) = ALEXMV,JESSE
group_concat(path) = A/AL/ALEXMV/Scalar-Defer-0.22.tar.gz,J/JE/JESSE/Scalar-Defer-0.22.tar.gz
distv = Search-GIN-0.07
group_concat(author) = DRUOSO,XSAWYERX
group_concat(path) = D/DR/DRUOSO/Search-GIN-0.07.tar.gz,X/XS/XSAWYERX/Search-GIN-0.07.tar.gz
distv = Sendmail-AccessDB-1.01
group_concat(author) = DREDD,STEPHANJ
group_concat(path) = D/DR/DREDD/Sendmail-AccessDB-1.01.tar.gz,S/ST/STEPHANJ/Sendmail-AccessDB-1.01.tar.gz
distv = ShipIt-0.55
group_concat(author) = BRADFITZ,MIYAGAWA
group_concat(path) = B/BR/BRADFITZ/ShipIt-0.55.tar.gz,M/MI/MIYAGAWA/ShipIt-0.55.tar.gz
distv = Task-WebGUI-2.0000
group_concat(author) = COLINK,RIZEN
group_concat(path) = C/CO/COLINK/Task-WebGUI-2.0000.tar.gz,R/RI/RIZEN/Task-WebGUI-2.0000.tar.gz
distv = Text-Context-3.5
group_concat(author) = TMTM,SIMON
group_concat(path) = T/TM/TMTM/Text-Context-3.5.tar.gz,S/SI/SIMON/Text-Context-3.5.tar.gz
distv = Text-FixedLength-Extra-1.1
group_concat(author) = TKEEFER,TBONE
group_concat(path) = T/TK/TKEEFER/Text-FixedLength-Extra-1.1.tar.gz,T/TB/TBONE/Text-FixedLength-Extra-1.1.tar.gz
distv = Text-MacroScript-1.38
group_concat(author) = ADOPTME,SUMMER
group_concat(path) = A/AD/ADOPTME/Text-MacroScript-1.38.tar.gz,S/SU/SUMMER/Text-MacroScript-1.38.tar.gz
distv = Text-NSP-1.21
group_concat(author) = BTMCINNES,TPEDERSE
group_concat(path) = B/BT/BTMCINNES/Text-NSP-1.21.tar.gz,T/TP/TPEDERSE/Text-NSP-1.21.tar.gz
distv = Text-SenseClusters-LabelEvaluation-Driver-0.08
group_concat(author) = ANANDJHA,AANANDJHA
group_concat(path) = A/AN/ANANDJHA/Text-SenseClusters-LabelEvaluation-Driver-0.08.tar.gz,A/AA/AANANDJHA/Text-SenseClusters-LabelEvaluation-Driver-0.08.tar.gz
distv = WebService-Solr-0.21
group_concat(author) = BRICAS,SUREN
group_concat(path) = B/BR/BRICAS/WebService-Solr-0.21.tar.gz,S/SU/SUREN/WebService-Solr-0.21.tar.gz
distv = Wizard-LDAP-0.1006
group_concat(author) = AMAR,JWIED
group_concat(path) = A/AM/AMAR/Wizard-LDAP-0.1006.tar.gz,J/JW/JWIED/Wizard-LDAP-0.1006.tar.gz
distv = WordNet-SenseRelate-TargetWord-0.07
group_concat(author) = TPEDERSE,SID
group_concat(path) = T/TP/TPEDERSE/WordNet-SenseRelate-TargetWord-0.07.tar.gz,S/SI/SID/WordNet-SenseRelate-TargetWord-0.07.tar.gz
distv = Xorg-XLFD-0.014
group_concat(author) = PEGI,WOLDRICH
group_concat(path) = P/PE/PEGI/Xorg-XLFD-0.014.tar.gz,W/WO/WOLDRICH/Xorg-XLFD-0.014.tar.gz
distv = examples
group_concat(author) = FERNANDES,SRIRAM
group_concat(path) = F/FE/FERNANDES/ex/examples.tar.gz,S/SR/SRIRAM/examples.tar.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment