RE: bzr commit into mysql-6.0-backup branch (hema:2676)

[Hema Sridharan]

Hi Jorgen,

Made the required changes and pushed the patch.

Thanks,

Hema Sridharan
QA Developer
Sun Microsystems / Mysql Inc, www.sun.com
 www.mysql.com
Office: Austin TX 78728, USA
 
Are you MySQL certified?  www.mysql.com/certification
 

> -----Original Message-----
> From: Jorgen.Loland@stripped [mailto:Jorgen.Loland@stripped] 
> Sent: Thursday, August 07, 2008 1:28 AM
> To: Hema Sridharan
> Cc: commits@stripped
> Subject: Re: bzr commit into mysql-6.0-backup branch (hema:2676)
> 
> It seems that this query has non-deterministic ordering:
> 
> SELECT * FROM bup_db1.v6 ORDER BY gender; On line 161 and 244
> 
> When running the tests, I get this error:
> 
> @@ -160,10 +160,10 @@
>   5	43	PHD
>   SELECT * FROM bup_db1.v6 ORDER BY gender;
>   education	gender
> -MS	F
> -Doctor	F
>   BS	F
>   BE	F
> +MS	F
> +Doctor	F
>   Undergrad	M
>   Lawyer	M
>   PHD	M
> @@ -387,14 +387,14 @@
>   5	43	PHD
>   SELECT * FROM bup_db1.v6 ORDER BY gender;
>   education	gender
> -Doctor	F
>   BS	F
>   BE	F
>   MS	F
> +Doctor	F
> +Undergrad	M
>   Lawyer	M
>   PHD	M
>   School	M
> -Undergrad	M
> 
> 
> You probably have to order on both education and gender.
> 
> Apart from that, the patch is good to push.
> 
> 
> Hema Sridharan wrote:
> > #At file:///data0/team6.0aug6/mysql-6.0-backup/
> > 
> >  2676 Hema Sridharan	2008-08-06
> >       backup_views.test modified to avoid the overlapping of the 
> > backup_view_on_view.test
> > removed:
> >   mysql-test/r/backup_view_on_view.result
> >   mysql-test/t/backup_view_on_view.test
> > modified:
> >   mysql-test/r/backup_views.result
> >   mysql-test/t/backup_views.test
> > 
> 
> --
> Jørgen Løland
> 
> --
> MySQL Code Commits Mailing List
> For list archives: http://lists.mysql.com/commits
> To unsubscribe:    http://lists.mysql.com/commits?unsub=1
> 
>