Ok to push.
-Nirbhay
On Tuesday 01 March 2011 09:36 AM, Vinay Fisrekar wrote:
> #At file:///home/vinayf/WORK/mysql_all_version_eits/code/repo/year_bug/mysql-5.1/
> based on revid:build@stripped
>
> 3605 Vinay Fisrekar 2011-03-01
> Bug#11766165 - 59211: SELECT RETURNS DIFFERENT VALUE FOR MIN(YEAR) FUNCTION
>
> Result File Correction For Bug Fix
>
> modified:
> mysql-test/suite/engines/iuds/r/insert_year.result
> === modified file 'mysql-test/suite/engines/iuds/r/insert_year.result'
> --- a/mysql-test/suite/engines/iuds/r/insert_year.result 2010-04-06 18:06:34 +0000
> +++ b/mysql-test/suite/engines/iuds/r/insert_year.result 2011-03-01 04:06:57 +0000
> @@ -2431,7 +2431,7 @@ c1 c2 c3 c4
> 2155 2155 1998-12-26 1998-12-26 11:30:45
> SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t3;
> total_rows min_value max(c2)
> -21 1901 2155
> +21 0 2155
> SELECT * FROM t3 WHERE c3 = '1998-12-11';
> c1 c2 c3 c4
> 1990 1990 1998-12-11 1998-12-11 11:30:45
> @@ -2838,7 +2838,7 @@ c1 c2 c3 c4
> 2155 2155 1998-12-26 1998-12-26 11:30:45
> SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t3;
> total_rows min_value max(c2)
> -21 1901 2155
> +21 0 2155
> SELECT * FROM t3 WHERE c3 = '1998-12-11';
> c1 c2 c3 c4
> 1990 1990 1998-12-11 1998-12-11 11:30:45
>
>
>
>
