Bugs item #2874045, was opened at 2009-10-07 11:32
Message generated for change (Settings changed) made by nielsnes
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2874045&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 CVS Head
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: segv for unknown identifier in subquery

Initial Comment:
select (select 1) * (select vettecrash from tables);

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7f0928f1b6f0 (LWP 22280)]
0x00007f09169c5971 in list_select (l=0x0, key=0x1b92938, 
    cmp=0x7f091698a3f4 <exp_is_correlation>, dup=0x7f0916988710 <exp_dup>)
    at ../../../src/common/sql_list.mx:282
282             list *res = list_create(l->destroy);

I would expect the same error as in:
select vettecrash from tables;
!SELECT: identifier 'vettecrash' unknown


After limiting the problem to a smaller query:
>select (select vettecrash from tables);

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fb14e9396f0 (LWP 22409)]
0x00007fb13c3e2ba0 in sql_ref_inc (r=0x0) at ../../../src/common/sql_mem.mx:44
44              assert(r->refcnt > 0);

----------------------------------------------------------------------

>Comment By: Niels Nes (nielsnes)
Date: 2009-11-11 17:33

Message:
added test segv_for_unknown_identifier_in_subquery.SF-2874045.sql 

Fixed by more defensive list_select.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2874045&group_id=56967

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to