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. BR Sergei -- Sergei Petrunia, Software Developer MariaDB Corporation | Skype: sergefp | Blog: http://s.petrunia.net/blog