Bugs item #2620437, was opened at 2009-02-20 17:14
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2620437&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: limit in the subquery
Initial Comment:
the Folgewirkung query crashes the mserver:
select id from tables where id not in (select id from columns limit 10);
mserver debug:
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7fffe181f950 (LWP 12655)]
0x0000003830832f05 in raise () from /lib64/libc.so.6
(gdb) up
#1 0x0000003830834a73 in abort () from /lib64/libc.so.6
(gdb) up
#2 0x000000383082bef9 in __assert_fail () from /lib64/libc.so.6
(gdb) up
#3 0x00007fffe26283db in exp_bin (sql=0x7fffe20ac138, e=0x7fffe2108818,
left=0x7fffe0f3d208, right=0x7fffe0f6d048, grp=0x0, sel=0x0) at
/ufs/goncalve/MonetDB/current/sql/src/server/rel_bin.mx:411
411 assert(0);
(gdb) l
406 is_select = 1;
407 }
408 if (re2)
409 r2 = exp_bin(sql, e->f, left, right, grp, sel);
410 if (!l || !r || (re2 && !r2)) {
411 assert(0);
412 if (l) stmt_destroy(l);
413 if (r) stmt_destroy(r);
414 if (r2) stmt_destroy(r2);
415 return NULL;
(gdb)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2620437&group_id=56967
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
