maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxxx>]

Hi, Sergei!

On Jun 22, Sergei Petrunia wrote:
> Hi Sergei,
> 
> Remember I've pointed out that the testcase for lp:817966 is present 
> in 5.3 but is missing in 5.5, and we figured it was lost in the merge 
> and decided to add it?
> 
> Well, if I add the testcase into 5.5 it fails like this:
> 
> main.func_in                             [ fail ]
>         Test ended at 2012-06-20 15:11:27
> 
> CURRENT_TEST: main.func_in
> --- /home/psergey/dev2/5.5-look6/mysql-test/r/func_in.result
> +++ /home/psergey/dev2/5.5-look6/mysql-test/r/func_in.reject
> @@ -793,12 +793,10 @@
>  insert t1 values (1,1),(2,2),(3,3);
>  select * from t1 where a in ('2.1');
>  a      b
> -2      2
>  select * from t1 where b in ('2.1');
>  a      b
>  select * from t1 where a='2.1';
>  a      b
> -2      2
>  select * from t1 where b='2.1';
>  a      b
>  select * from t1 where IF(1,a,a)='2.1';
> 
> I cannot readily tell whether this is a bug or not (could be, the
> typecasting rules are changed in 5.5?)
> Do you think this should be filed as a jira issue?

I think the new result is fine. It's better that what we have in 5.3.
In 5.3 (and earlier) 2 was in some cases - but not in others - "equal"
to 2.1. Which was, in my opinion, a bug, or at least a gotcha. But with
long history, and I didn't dare to fix it - the change could potentially
break many applications.

Apparently that bug was fixed in 5.5, and 2 is no longer equal to 2.1 :)

Regards,
Sergei