On Wed, Apr 07, 2010 at 04:08:49PM +0400, Sergey Petrunya wrote:
Hi Sanja,
On Wed, Apr 07, 2010 at 01:54:25PM +0300, Oleksandr Byelkin wrote:
I found 1 interesting test case:
create table t1 (a int, b int); insert into t1 values (1,2),(3,4),(1,2),(3,4),(3,4),(4,5),(4,5),(5,6), (5,6),(4,5); create table t2 (c int, d int); insert into t2 values (2,3),(3,4),(5,6);
select a, b from t1 where b in (select d from t2);
It crashes but only if test case started with --debug. I assume this is with current lp:~maria-captains/maria/5.3-subqueries? I'll take a look.
Doesn't crash for me in either 5.3-subqueries or 5.3-sj-subqueries tree. Which tree are you using? BR Sergey -- Sergey Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog