List:Commits« Previous MessageNext Message »
From:Roy Lyseng Date:September 28 2010 7:53am
Subject:Re: bzr commit into mysql-5.1-bugteam branch (Sergey.Glukhov:3510)
Bug#54484
View as plain text  
Hi Gluh and Martin,

did you check what happens when RIGHT OUTER JOIN is replaced with just JOIN?

It appears to me that it is not the outer join specification that is the problem 
here...

Thanks,
Roy

On 28.09.10 09.23, Martin Hansson wrote:
> +CREATE TABLE t1(f1 VARCHAR(6) NOT NULL,
> +FULLTEXT KEY(f1),UNIQUE(f1));
> +INSERT INTO t1 VALUES ('test');
> +PREPARE stmt FROM
> +'SELECT 1 FROM t1 WHERE 1>
> + ALL((SELECT 1 FROM t1 RIGHT OUTER JOIN t1 a
> + ON (MATCH(t1.f1) against (""))
> + WHERE t1.f1 GROUP BY t1.f1)) xor f1 or f1>  1';
> +EXECUTE stmt;
> +1
> +1
> +EXECUTE stmt;
> +1
> +1
> +DEALLOCATE PREPARE stmt;

Thread
bzr commit into mysql-5.1-bugteam branch (Sergey.Glukhov:3510)Bug#54484Sergey Glukhov16 Sep
  • Re: bzr commit into mysql-5.1-bugteam branch (Sergey.Glukhov:3510)Bug#54484Martin Hansson28 Sep
    • Re: bzr commit into mysql-5.1-bugteam branch (Sergey.Glukhov:3510)Bug#54484Roy Lyseng28 Sep