Bugs item #1993765, was opened at 2008-06-14 09:40
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1993765&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: Closed
>Resolution: Fixed
Priority: 6
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: nested views algebra version
Initial Comment:
If I use the algebra version (mclient -G) and I run the following queries the
mserver crashes:
create table t1(id int, age int);
create view v1 as select * from t1 where id = 0;
create view v2 as select * from v1 where age =1;
select * from v2 LIMIT 10;
drop view v2;
drop view v1;
drop table t1;
It seems it is looking for a persistent BAT from a view...
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 4056136592 (LWP 11694)]
0xf220fe28 in bind_col (tr=0x86c66b8, c=0x9380210, access=0) at
/ufs/goncalve/MonetDB/stable/sql/src/storage/bat/bat_storage.mx:190
190 if (isTemp(c) || access == RD_INS || !bat->bid) {
(gdb) p bat
$1 = (sql_delta *) 0x0
(gdb) up
#1 0xf2153e85 in mvc_bind (m=0x9310d48, sname=0x956c178 "sys", tname=0x956c1d8
"v1", cname=0x956c238 "age", access=0)
at /ufs/goncalve/MonetDB/stable/sql/src/backends/monet5/sql.mx:1286
1286 b = store_funcs.bind_col(tr, c, access);
(gdb)
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2008-06-17 09:26
Message:
Logged In: YES
user_id=43556
Originator: NO
fixed bug in recursive view handling
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-06-14 09:45
Message:
Logged In: YES
user_id=1498628
Originator: YES
A test was added at:
sql/src/test/BugTracker/Tests/nested_views_algebra_version.SF-1993765.sql
Romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1993765&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
