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;
