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

(-)a/installer/data/mysql/atomicupdate/bug_28854.pl (-3 / +2 lines)
Lines 21-27 return { Link Here
21
        }
21
        }
22
        say $out "item_bundles table added";
22
        say $out "item_bundles table added";
23
23
24
        my ($lost_val) = $dbh->selectrow_array( "SELECT MAX(authorised_value) FROM authorised_values WHERE category = 'LOST'", {} );
24
        my ($lost_val) = $dbh->selectrow_array( "SELECT MAX(CAST(authorised_value AS SIGNED)) FROM authorised_values WHERE category = 'LOST'", {} );
25
        $lost_val++;
25
        $lost_val++;
26
26
27
        $dbh->do(qq{
27
        $dbh->do(qq{
Lines 29-35 return { Link Here
29
        });
29
        });
30
        say $out "Missing from bundle LOST AV added";
30
        say $out "Missing from bundle LOST AV added";
31
31
32
        my ($nfl_val) = $dbh->selectrow_array( "SELECT MAX(authorised_value) FROM authorised_values WHERE category = 'NOT_LOAN'", {} );
32
        my ($nfl_val) = $dbh->selectrow_array( "SELECT MAX(CAST(authorised_value AS SIGNED)) FROM authorised_values WHERE category = 'NOT_LOAN'", {} );
33
        $nfl_val++;
33
        $nfl_val++;
34
34
35
        $dbh->do(qq{
35
        $dbh->do(qq{
36
- 

Return to bug 28854