Re: [Maria-discuss] MariaDB subquery

2014-04-15 Thread Sergey Petrunia
Hi James, This looks like a different problem from MDEV-6041 or MDEV-6081. I've tried to create a dataset to repeat the problem, but I didn't succeed. Is it possible for you to upload the dataset that shows the problem? If you don't want to share it publicly, it is possible to upload it to wher

Re: [Maria-discuss] MariaDB subquery

2014-04-15 Thread Sergey Petrunia
Hi, For the record: Analyzing this, I've found https://mariadb.atlassian.net/browse/MDEV-6041 and https://mariadb.atlassian.net/browse/MDEV-6081. Both are now fixed in MariaDB 10.0. On Mon, Mar 31, 2014 at 09:33:17AM +0100, James Qian Wang wrote: > Here is the table structures and query: > > C