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: Fixed
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-05 08:21
Message:
Logged In: YES
user_id=1498628
Originator: YES
If it is fixed why is not closed?
Romulo
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2008-06-04 22:38
Message:
Logged In: YES
user_id=43556
Originator: NO
The bug is fixed. The declared tables were not created properly. Now the
are created in a special schema (%dt%).
----------------------------------------------------------------------
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
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
