Bugs item #1983341, was opened at 2008-06-03 12:36
Message generated for change (Comment added) made by romulog
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1983341&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 2.24
Status: Open
Resolution: None
Priority: 6
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: schema from declared table...

Initial Comment:
The following code crashed Mserver5 SQL (including the algebra version):
create table t1 (id int, age int);

create function f1()
RETURNS table (idd int, aage int)
BEGIN
        DECLARE TABLE cover(
                id int, htmidEnd int
        );
        INSERT into cover
                SELECT id, age
                FROM t1;
        RETURN TABLE (
        SELECT   id , htmidEnd
            FROM cover H
            WHERE 1 > id);
END;

select * from f1() n;

Some debug information:
>[New Thread 1098918224 (LWP 2776)]
[New Thread 1107310928 (LWP 2777)]

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1107310928 (LWP 2777)]
0x00002aaabecc718c in _dumpstmt (sql=0x11694f8, mb=0x6d82228, s=0x6e9a8d8) at 
/ufs/goncalve/MonetDB/stable/sql/src/backends/monet5/sql_gencode.mx:1387
1387                            q = pushStr(mb, q, c->t->s->base.name);
Missing separate debuginfos, use: debuginfo-install bzip2.x86_64 
e2fsprogs.x86_64 glibc.x86_64 keyutils.x86_64 krb5.x86_64 libselinux.x86_64 
ncurses.x86_64 openssl.x86_64 pcre.x86_64 readline.x86_64 zlib.x86_64
(gdb) p c
$3 = (sql_column *) 0x6eb66b8
(gdb) p c->t
$4 = (struct sql_table *) 0x6d85bd8
(gdb) p c->t->s
$5 = (struct sql_schema *) 0x0
(gdb) 


Romulo

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

>Comment By: Romulo Goncalves (romulog)
Date: 2008-06-03 13:50

Message:
Logged In: YES 
user_id=1498628
Originator: YES

Test added at:

sql/src/test/BugTracker/Tests/schema_from_declared_table.SF-1983341.sql

Romulo

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

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to