View | Details | Raw Unified | Return to bug 22887
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_22887.perl (-1 / +4 lines)
Lines 1-6 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
    unless ( index_exists('authorised_values', 'av_uniq') ) {
3
    unless ( index_exists('authorised_values', 'av_uniq') ) {
4
        $dbh->do(q|
5
            DELETE FROM authorised_values
6
            WHERE category="COUNTRY" AND authorised_value="CC" AND lib="Keeling"
7
        |);
4
        my $duplicates = $dbh->selectall_arrayref(q|
8
        my $duplicates = $dbh->selectall_arrayref(q|
5
            SELECT category, authorised_value, COUNT(concat(category, ':', authorised_value)) AS c
9
            SELECT category, authorised_value, COUNT(concat(category, ':', authorised_value)) AS c
6
            FROM authorised_values
10
            FROM authorised_values
7
- 

Return to bug 22887