MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Sergei Golubchik Date:August 24 2009 4:03pm
Subject:Re: bzr commit into mysql-5.1-bugteam branch (davi:3036) Bug#45261
View as plain text  
Hi, Davi!

On Jul 23, Davi Arnaut wrote:
>  3036 Davi Arnaut	2009-07-23
>       Bug#45261: Crash, stored procedure + decimal
>       
>       The problem was that creating a DECIMAL column from decimal
>       value could lead to a assertion as decimal values can have
>       a higher precision than those attached to a table. The assert
>       could be triggered by creating a table from a decimal with
>       a large (> 30) scale. Also, there was a problem in calculating
>       the number of digits in the integral and fractional parts if
>       both exceeded the maximum number of digits permitted by the
>       new decimal type.
>       
>       The solution is to ensure that truncation procedure is executed
>       when deducing a DECIMAL column from a decimal value of higher
>       precision. If the integer part is equal to or bigger than the
>       maximum precision for the DECIMAL type (65), the integer part
>       is truncated to fit and the fractional becomes zero. Otherwise,
>       the fractional part is truncated to fit into the space left
>       after the integer part is copied.
>       
>       This patch borrows code and ideas from Martin Hansson's patch.

Ok to push.
(assuming you'll do changes that Martin wanted)

Regards / Mit vielen Grüßen,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  Principal Software Engineer/Server Architect
/_/  /_/\_, /___/\___\_\___/  Sun Microsystems GmbH, HRB München 161028
       <___/                  Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Häring
Thread
bzr commit into mysql-5.1-bugteam branch (davi:3036) Bug#45261Davi Arnaut24 Jul
  • Re: bzr commit into mysql-5.1-bugteam branch (davi:3036) Bug#45261Martin Hansson11 Aug
    • Re: bzr commit into mysql-5.1-bugteam branch (davi:3036) Bug#45261Davi Arnaut11 Aug
      • Re: bzr commit into mysql-5.1-bugteam branch (davi:3036) Bug#45261Martin Hansson12 Aug
        • Re: bzr commit into mysql-5.1-bugteam branch (davi:3036) Bug#45261Davi Arnaut12 Aug
  • Re: bzr commit into mysql-5.1-bugteam branch (davi:3036) Bug#45261Sergei Golubchik24 Aug