On Wed, Sep 07, 2016 at 10:24:09AM +0400, Alexander Barkov wrote:
Hello Sergey and Igor,
You recently closed MDEV-10057 and MDEV-10058, but forgot to add tests.
- MDEV-10057 does not have tests at all.
- MDEV-10058 has only the parser related test,
but does not have this test:
EXPLAIN SELECT * FROM (WITH a AS (SELECT * FROM t1) SELECT * FROM t2
NATURAL JOIN t3) AS d1;
Can you please add the missing tests?
The reason for doing that was that I was fairly confident that:
- These testcases look very much like duplicates of the issues that were found
and fixed in the CTE code.
- cte_nonrecursive.test has other testcases cover whatever these cases cover,
adding these tests does not increase coverage;
but since this issue has been raised, I thought it would be easier to add these
tests than to figure it out. I've added the tests.