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-05 15:43
Message:
Logged In: YES
user_id=1498628
Originator: YES
The test was improved and it shows that the bug is not complete fixed.
I just add new selection:
select * from f1() n;
And now the mserver is again crashing:
>[New Thread 1098918224 (LWP 20645)]
[New Thread 1107310928 (LWP 20646)]
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1107310928 (LWP 20646)]
0x00002aaabed4715b in validate_tables (s=0x293ddc8, os=0x1379748) at
/ufs/goncalve/MonetDB/current/sql/src/storage/store.mx:2415
2415 for (o = t->columns.set->h, p =
ot->columns.set->h; o && p; o = o->next, p = p->next) {
(gdb) p ot->columns
$11 = {destroy = 0x2aaabed3e71b <column_destroy>, set = 0x2924168, dset =
0x0, nelm = 0x0}
(gdb) p t->columns
$12 = {destroy = 0x2aaabed3e71b <column_destroy>, set = 0x0, dset = 0x0,
nelm = 0x0}
(gdb)
Romulo
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2008-06-05 09:15
Message:
Logged In: YES
user_id=572415
Originator: NO
(Only) Now that testing has confirmed Niels' fix for SQL/4, SQL/5 &
SQL/Algebra,
we can savely close this bug report.
----------------------------------------------------------------------
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
